MarkK
bit cruncher
- Local time
- Today, 00:54
- Joined
- Mar 17, 2004
- Messages
- 8,608
Your structure would be way simpler if you abandon the idea that a category and an account are not the same thing. I think Quicken misleads in that regard. A 'Category' in Quicken, if you think about it as an accounting principle, is just another Account. Quicken does that so you can define the 'from' account and the 'to' account on a single line, but it effectively hides the reality. Groceries is an expense account. Bank is an asset account. Quicken treats groceries as a different type of object, but in accounting terms, its not.
So if you had tables Transaction, Post, and Account, you could get rid of tables CheckCat, Category, Transfer, Invoice, and InvoiceItems, because all of that could be modeled with typed rows in other tables, like an invoice is just a transaction that posts a debit to a revenue account and posts a balancing credit to a receivable or bank account.
SubCategories disappear too with a self-referencing account table, which enables definition of sub-accounts.
So if you had tables Transaction, Post, and Account, you could get rid of tables CheckCat, Category, Transfer, Invoice, and InvoiceItems, because all of that could be modeled with typed rows in other tables, like an invoice is just a transaction that posts a debit to a revenue account and posts a balancing credit to a receivable or bank account.
SubCategories disappear too with a self-referencing account table, which enables definition of sub-accounts.
