Entity-Relationship Diagram

[Christian Stimming]

Am Freitag, 22. April 2011 schrieb John Ralls:
> The ERD is finally done and available for download at
> https://github.com/downloads/jralls/gnucash/gnucash_erd.png.
> 
> For ease of access I've added a link to it on the SQL wiki page.
> 
> One comment: It's a bit scary how much has gotten stuffed into KVP over the
> years. I think I found it all...

Thanks a lot for collecting all these relations! Indeed the KVP contains way 
too much stuff...

The "post_date" field of the Transaction is stored in two places, not (only) 
in KVP: It is stored directly in the object as a DATETIME field. Additionally, 
a year ago I added storing that date as a GDATE in the KVP, so that we can get 
rid of the timezone issue sometime in the future (because DATETIME is simply 
the wrong type for that field, 
https://bugzilla.gnome.org/show_bug.cgi?id=137017 ). However, the GDate kvp is 
currently only being set - I think it is never read anywhere, because the 
DATETIME field is used everywhere and I haven't gotten around to implement the 
actual usage code for that. Can you recognize this explanation in the code, or 
did I mess up my memories already?

Also, the two fields in Account which are stored as KVP should IMHO be moved 
into real fields ASAP. But indeed, currently they are stored as KVP.

Regards,

Christian