I'm working on a web application for our business with my brother. Our application is pretty simple, and will be developed with php and mysql.
- Clients and providers ABMs
- Articles Inventory (we do not manage stock, because we resell from our providers)
- Account balance for our clients and providers
I'm stuck on accounting tables... Here is my model:
I'm in doubt about the account table; I'm thinking about use a trigger when purchases change Status (delivered to client) then updating the Account balance but I don't know if this model is good for managing Accounts for my Clients.
I'm looking for opinions about my mistakes!! Thank you.