2006/10/24, Phil Longstaff <[EMAIL PROTECTED]>: > On Mon, 2006-23-10 at 22:38 -0400, Josh Sled wrote: > > It'll probably be the case that the SQL DDL statements will be easier to > > work with than these pictures. Just plain text like... > > > > CREATE TABLE accounts > > ( > > id int NOT NULL, > > name String, > > parent int NOT NULL, -- fk(Account.id) > > [...] > > ) > > > > ...is better. > > I've attached a first cut at DDL for the core stuff. It doesn't include > slots, lots, some sched txn stuff.
I love to see the DDL (Database Definition Language?), but I consider that to finish the graphic schema could be better (I made a lot of changes) and is usefull when you don't use SQL but libgda or other toolkit to create the Database Definition and relations. >I based it on the code which writes > out XML. I don't understand some of the interactions with pieces of the > sched txn stuff or lots. The contents of slots seems to me to be object > dependent i.e budget slots will be different than account slots. I also > haven't looked too much at the business stuff yet. I imagine I will > tackle it in a similar manner to what I do now i.e. convert XML > definitions to table definitions. However, I don't use the business > features, so won't really be able to test it. > I'll study you DDL and try to include it in the graphic (I sended the 0.1 version) version 0.2. -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE) _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
