Updated DDL for SQL backend

[Derek Atkins]

Josh Sled <jsled at asynchronous.org> writes:

> There's a deeper modeling issue with SXes. We use a seperate, parallel
> AccountGroup to store template transaction data, in which Accounts are
> named as the string representation of the SXes GUID, and contain
> Transactions with Splits which have their *real* Accounts, as well as
> the credit and debit cell text formulae, in KVP frames.

I know David was working to re-model the AccountGroup...

> I don't see a reason to model this differently in the DB than in the
> object model.  Though we might want to change the object model.
>
>
> Also, in the DDL, SXes still have an sx_id, though as QOF entities they
> are GUID-posessing objects, and thus should follow the pattern of those.

How closely should the DB Schema map to the QOF object model?

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available