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