On Mon, 29 Jun 2009 21:30:56 -0400, Phil Longstaff <plongst...@rogers.com> wrote: > Here's a first cut at the database schema. It only covers the main tables > and > types (not business tables). I will put this information into the header > files > so that it gets put into the doxygen developers documentation. > > Although there are some fields which contain guids which reference other > tables, they are not defined as foreign fields (yet). 2 reasons: 1) > sqlite3 > doesn't enforce foreign fields (although it is apparently possible to use
> triggers to do some checking) and 2) gnucash is not a database app and > doesn't > necessarily enforce the checking (2 known instances - the "add price" > dialog > creates (and therefore stores) a new price before the commodity has been > set, > and lots in the LOTS table sometimes have the account_guid set to NULL). Thanks. :) I'll start working on my implementation in the next days then. The accounts-Table has a field "non_std_scu". I guess a std-scu would be the one of the associated currency but does it not violate the first normal form to save this in an extra field? Marcus _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
