Db structure

Chris Shoemaker c.shoemaker at cox.net
Sun Aug 9 16:44:25 EDT 2009


On Sun, Aug 09, 2009 at 03:46:46PM -0400, Phil Longstaff wrote:
> For the most part, I've tried to make the db schema match the XML schema, 
> including warts.  There are 2 places I'd like to change, and am looking for 
> feedback:
>
> 2) Each budget stores all of the budget information in slots, with path names 
> of <guid>/<period> (e.g. 294ddec82b0840980d98203/12).  These should be moved 
> to a new budget_values table with columns id (autoinc/primary key), 
> account_guid, period_num, budget_value (numeric).  This would allow better 
> access to the budget info by external tools.

That seems reasonable to me.  The use of slots was originally just to
avoid the proliferation of C structs.

-chris


More information about the gnucash-devel mailing list