SQL schema diagram

[Sébastien de Menten]

Thank you John. I knew this very nice diagram but it comes with a lot of
objects that do not exist in the DB which made it difficult for me at the
beginning to make sense of the tables. Hence, I though it would be useful
to have a 100% SQL view.
kr
sebastien

On Mon, Mar 30, 2015 at 7:16 PM, John Ralls <jralls at ceridwen.us> wrote:

>
> > On Mar 30, 2015, at 1:07 AM, Sébastien de Menten <sdementen at gmail.com>
> wrote:
> >
> > If you want to query a gnucash sql book, you may find interesting the
> > schema diagram in attachment where the foreign keys are shown (and hence
> > most of the simple relationships between tables, ie all except slots and
> > some relations between business objects).
>
> There’s a clearer ERD on http://wiki.gnucash.org/wiki/SQL.
>
> Regards,
> John Ralls
>
>