MySQL table designing for an Accounting system
I am designing an online accounting system as a college project. I have the following transactions:
- Sales in cash $300
- Cash borrowed from Smith $250
- Electricity bill paid $50
I saw Double Entry Accounting in a Relational Database and designed a Transaction table (a minus sign means the amount is credited). Ids 1 and 2 belong to transaction 1, ids 3 and 4 belong to transaction 2, and so on.
How can I identify each row pair as a single transaction in MySQL database?
If the first transaction is selected there is no relationship between the two rows.
Solution
Drop the two-line design unless it's really necessary. Merge the rows, add a field to store whether it was cash, and use the amount value sign to show whether it was credited or debited.
- Get count of unique values with the column name in Laravel 5.2 Collection
- Dynamic fees calculated from custom checkout fields in WooCommerce
- Can we get only users with Gravatar profile image by db query?
- CodeIgniter's $this->input->post() returns null when string parameter doesn't match form field name containing square braces
- getting the 1st row in a database
- Conditionally filter records using LIKE on identically named columns from two tables in CodeIgniter
- How can I change a file's extension using PHP?
- What is a "channel" in Monolog logger?
- Get the first element of an array
- Problems with installing composer
- Undefined property when trying to access column not mentioned in CodeIgniter query's SELECT clause
- Accessing a property of CodeIgniter's row() emits an error when no results: Trying to get property of non object
- Wordpress Search Function to only search posts
- PHP array delete by value (not key)
- CodeIgniter active record query to return rows where a column value is LIKE one of potentially multiple values
- Adding 10 on to each value in a mysql query
- How to do queries with pdo db connection function?
- MySQL stored procedure caused `Commands out of sync`
- Custom views for cgridview based on role
- Hide out of stock related products in WooCommerce
- Codeigniter 2.1 - MySQL and regexp
- The mysqli extension is missing. Please check your PHP configuration , even though file is available in defined path
- How to write update query in Laravel 5.2
- Is it possible to use mysqli as database driver in Laravel?
- Why all queries written in controller file instead of model in laravel
- How can I explode a value in database and use it in select query?
- Is there any library file for laravel multi-auth using API Authentication (Passport)?
- How to copy column from one table data to another table and insert more columns same time?
- Laravel eloquent where replace and compare
- Delete distinct data