On Mon, 2006-23-10 at 17:14 -0500, Daniel Espinosa wrote: > Attached you'll find a DataBase Schema for GnuCash. > > This is in order to bigin the development to support DB backend (and > replase the actual file one). > > I added a Inventory Table (or Class) in wich you can have the > merchandise in a small business like a small store. >
What version of Dia do you have? I have 0.94, and when I load it, I get a number of messages about connection points which do not exist. It's a good start, but I have some issues with the schema: 1) Accounts: parent is not null. However, the top level accounts (Assets, Liabilities, ...) don't have a parent. In addition, the parent should be a foreign key reference back to the Accounts table. 2) You have a Currencys (should be Currencies) table. However, tables which should have a foreign key reference to it just have type "integer". In addition, this should probably be a Commodities table to include stocks and mutual funds. 3) An account can have a type which is a commodity (for stock or mutual fund accounts). 4) You need to split Transactions in Transactions and Splits. A Transaction will include the date (currently, both entry date and posting date (the one you see)), description, commodity (currency?). A Split will include the memo, reconciliation state and reconciliation date (end date of the statement), credit or debit amount (can be 1 field with +ve or -ve value), account, ... 5) The current XML schema stores other info with each Account. The info seems to be related to recently or commonly used transactions. 6) You need to add a Price table for commodity prices and currency exchange rates. I don't use the GnuCash business features, so I won't comment on those tables. Phil _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
