> Is there some clear documentation of the SQL schema somewhere?
https://wiki.gnucash.org/wiki/SQL
https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences
> MySQL and SQLite3 date storage has changed a bit. Once converted, MySQL
> and SQLite3 database will be loadable only by GnuCash 2.6.19 and later.
Was PostgreSQL omitted from this statement accidentally, or do the
changes not apply to that database backend?
> Am going to look at writing some SQL to pull this out of the GNU cash database
You will be looking for the "reconcile_date" column on the "splits"
table. I use PostgreSQL and I'm curious to hear about any fancy SQL
you come up with!
Wiliam
___