[GNC] Database schema documentation

John Ralls jralls at ceridwen.us
Thu Jul 9 23:54:34 EDT 2020 

https://wiki.gnucash.org/wiki/SQL

There's a linked ERD that also shows how the various key-value parameters (also called slots) relate to the data stored in tables.

Regards,
John Ralls

> On Jul 9, 2020, at 7:29 PM, Tom Hatzigeorgiou <tomhatz at hotmail.com> wrote:
> 
> has anyone created a data dictionary of the database that is created if you save your gnucash data in a DB format. It doesn't matter the database, it seems to create same table structures in SQLite and PostgreSQL that I checked.
> 
> what I'm looking for is, definitions on the data that the tables hold and how you can connect those tables together on a sql statement. foreign keys to those tables would also be helpful.
> I'm hoping that I can write selects to look for transactions and/or create reports out of my data.
> 
> thank you
> 
> 
> 
> ________________________________
> From: gnucash-user <gnucash-user-bounces+tomhatz=hotmail.com at gnucash.org> on behalf of gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>
> Sent: Thursday, July 9, 2020 12:00 PM
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: gnucash-user Digest, Vol 208, Issue 36
> 
> Send gnucash-user mailing list submissions to
>        gnucash-user at gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>        gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
>        gnucash-user-owner at gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>   1. Re:  GnuCash list (Adrien Monteleone)
>   2. Re:  Gnucash - user (flywire)
>   3.  Reconcile also opens Interest Payment box? (lj)
>   4. Re:  Reconcile also opens Interest Payment box? (jean laroche)
>   5. Re:  Gnucash - user (Liz)
>   6.  Unable to compile gnucash-4.0 on one computer
>      (Md. Aminul Islam Khan)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 8 Jul 2020 15:45:31 -0500
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] GnuCash list
> Message-ID: <205F824D-2AB5-4979-83D5-14650BCB9406 at lusfiber.net>
> Content-Type: text/plain;       charset=utf-8
> 
> 
> 
>> On Jul 8, 2020 w28d190, at 7:02 AM, Bruce Irving via gnucash-user <gnucash-user at gnucash.org> wrote:
>> 
>> From: Robert Heller <heller at deepsoft.com>
>> 
>> Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL,
>> Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they would
>> be reading postings in an actual webforum.  The idea of an "E-Mail List" as
>> something separate from a forum is actually foreign to these people.  And yes
>> many people would prefer a web-forum (not me -- I hate web forums and avoid
>> them whenever possible).
>> 
>> Thank you, Robert.  Yes, it is foreign to me.
>> Unfortunately, I do not save the messages.  I needed to reinstall my OS and all my applications.  They do offer gnucash version 1:2.6.19-1.  They also offer flatpak which is currently 4.0-3.
>> After reading the difficulties, I was going to wait until it smoothed out before installing but, in this case, had no choice but to upgrade.  Now, I have a couple of nits to pick:
>> 
>> I started bookkeeping BC (before computer) so I'm familiar with debits and credits.  Unfortunately. I couldn't find where to use formal accounting rules.
> 
> 
> Preferences > Accounts > Labels > Use Formal Accounting Labels
> 
> The ?rules? of GnuCash are double-entry.
> 
> You still have to know how to structure your transactions though. It won?t do that for you. (the ?business features? can handle this somewhat)
> 
> 
>> I recently made an entry, (I work in the general ledger.) and, as usual double checked it in the account register where it looked wrong.  So I corrected it and looked at it in the other account where it again looked wrong.  After 3 corrections, I finally realized the the accounts were different from what I was used to.
> 
> What were you seeing that you think looked wrong and what are you used to?
> 
> 
>> I had heard several express difficulty with column widths.
> 
> The Help manual covers this. It is a matter of dragging the header separator as needed. For the moment, this has to be done per account, though Invoices/Bills can now (as of 4.0) have a layout ?remembered?.
> 
> 
>> I usually work with two or more windows open at once.  But now, GNC requires me to use full screen.
> 
> No it does not. I don?t use it full screen. And while opening two instances with two different books side-by-side isn?t ?usual?, it can be done. Each OS may be a bit different in how you accomplish it though. You can also specify Preferences > Register Defaults > Other Defaults > Register opens in a new window.
> 
> 
>> In both of those cases, I had read there was a solution.  With a mailing list, I can't browse through the previous posts to find the answers to my issues.
> 
> There is an archive of the list here: https://lists.gnucash.org/pipermail/gnucash-user/
> 
> The search feature is currently broken, but you can use ?site:lists.gnucash.org search terms? in your favorite search engine to search only the mailing list server for ?search terms?
> 
> Regards,
> Adrien
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 9 Jul 2020 09:11:58 +1000
> From: flywire <flywire0 at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Cc: Derek Atkins <derek at ihtfp.com>
> Subject: Re: [GNC] Gnucash - user
> Message-ID:
>        <CAOthWL11SeXRO-Co+uXQiLxnOAwTaK33f=ar0p28_0Tgy2_png at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
> I understand it is a word-picture.
> 
> 
> The wheel is a big technological improvement to reduce the work of moving a
> sled, a flat device for moving an irregularly shaped object across the
> ground.
> btw, almost no snow in Australia.
> 
>>> mailman3 would put wheels on the sled.
>>> 
>>> I must admit I don't know exactly what you mean by this.  :-)
>> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Wed, 8 Jul 2020 17:54:47 -0400
> From: lj <lj618 at pobox.com>
> To: gnucash-user at lists.gnucash.org
> Subject: [GNC] Reconcile also opens Interest Payment box?
> Message-ID: <re5fbf$d4n$1 at ciao.gmane.io>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)
> 
> For just one of my accounts, the following odd thing started happening this
> month. I open the register and click Reconcile.  The expected Reconcile
> Information dialog box opens, but on top of that I get an Interest Payment
> box. Why would this pop up over Reconcile? Why only for one account? It
> started this month. What did I do to cause this?
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Wed, 8 Jul 2020 16:59:41 -0700
> From: jean laroche <ripngo at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Reconcile also opens Interest Payment box?
> Message-ID: <aa23a73d-11d6-8bfb-1e01-8f54d2a111dd at gmail.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> There's a Preference for that under Register, Reconciling
> Jean
> 
> On 7/8/2020 2:54 PM, lj wrote:
>> Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)
>> 
>> For just one of my accounts, the following odd thing started happening
>> this month. I open the register and click Reconcile.? The expected
>> Reconcile Information dialog box opens, but on top of that I get an
>> Interest Payment box. Why would this pop up over Reconcile? Why only for
>> one account? It started this month. What did I do to cause this?
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Thu, 9 Jul 2020 21:49:25 +1000
> From: Liz <edodd at billiau.net>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Gnucash - user
> Message-ID: <20200709214925.6731603b at billiau.net>
> Content-Type: text/plain; charset=US-ASCII
> 
> On Tue, 7 Jul 2020 15:03:20 +0100
> david whiting <dw at davidwhiting.me.uk> wrote:
> 
>> If you do a google search for "gnucash forum" the top two hits are
>> results from nabble. If you click on either one of these you'll see
>> the login/register link top left that sign you up to nabble.
>> 
>> Perhaps this is how some people think that this is the correct way to
>> sign up. They are doing something that is normal these days, a google
>> search for what they want to find (gnucash forum) and aren't aware of
>> the subtle difference between using nabble and signing up to the
>> mailing list. There's a very good chance they won't get close to the
>> wiki so perhaps it will make no difference how clearly it is
>> described in the wiki.
>> 
>> See attached.
>> 
>> David
> 
> I use DDG, and just checked, Gnucash.org is the first entry returned.
> 
> I s'pose Google would like us to buy ads to get to the top of their
> search??
> 
> Liz
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Thu, 9 Jul 2020 20:10:38 +0600
> From: "Md. Aminul Islam Khan" <aikhanlab at gmail.com>
> To: Gnucash user list <gnucash-user at gnucash.org>
> Subject: [GNC] Unable to compile gnucash-4.0 on one computer
> Message-ID:
>        <CAGzip+wMABHaSiLqa6NQwNBWiQwA5h=5tbKayrX-ZSZbY9aTVw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
> Hello all,
> Using Ubuntu 18.04 on two computers, was using gnucash-3.9 on both.
> Directories are identical. I could compile gnucash-4.0 on one computer.
> Same commands used in both computers:
> 1. cd build-gnucash-3.9, sudo ninja uninstall, sudo ninja clean
> 2. Downloaded the source file, gnucash-4.0, extracted.
> 3. mkdir build-gnucash-4.0, cd build-gnucash-4.0
> 4. cmake -GNinja -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash-4.0
> 5. sudo ninja
> The other computer results in:------------------------------
> [741/894] Generating
> ../../../../lib/x86_64-linux-gnu/guile/2.0/site-ccache/tests/test-qif-parse.go
> wrote
> `/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/x86_64-linux-gnu/guile/2.0/site-ccache/tests/test-qif-parse.go'
> [742/894] Linking CXX executable bin/gnucash
> FAILED: bin/gnucash
> : && /usr/bin/c++  -Wno-error=deprecated-declarations  -Werror -Wall
> -Wmissing-declarations -Wno-unused -Wno-error=parentheses
> gnucash/CMakeFiles/gnucash.dir/gnucash.cpp.o
> gnucash/CMakeFiles/gnucash.dir/gnucash-commands.cpp.o
> gnucash/CMakeFiles/gnucash.dir/gnucash-core-app.cpp.o
> gnucash/CMakeFiles/gnucash.dir/gnucash-gresources.c.o  -o bin/gnucash
> -Wl,-rpath,/home/aikhan/Applications_src_build/build-gnucash-4.0/lib:/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/gnucash:
> lib/libgnc-module.so lib/gnucash/libgnc-qif-import.so
> lib/gnucash/libgnc-csv-import.so lib/gnucash/libgnc-csv-export.so
> lib/gnucash/libgnc-log-replay.so lib/gnucash/libgnc-bi-import.so
> lib/gnucash/libgnc-customer-import.so -lguile-2.0 -lgc -lglib-2.0
> /usr/lib/x86_64-linux-gnu/libboost_date_time.so
> /usr/lib/x86_64-linux-gnu/libboost_regex.so
> /usr/lib/x86_64-linux-gnu/libboost_locale.so
> /usr/lib/x86_64-linux-gnu/libboost_filesystem.so
> /usr/lib/x86_64-linux-gnu/libboost_system.so
> /usr/lib/x86_64-linux-gnu/libboost_program_options.so
> lib/gnucash/libgnc-generic-import.so lib/libgnc-gnome.so
> lib/gnucash/libgnc-ledger-core.so lib/gnucash/libgnc-report.so
> /usr/lib/x86_64-linux-gnu/libboost_locale.so
> /usr/lib/x86_64-linux-gnu/libboost_filesystem.so
> /usr/lib/x86_64-linux-gnu/libboost_system.so
> /usr/lib/x86_64-linux-gnu/libboost_program_options.so
> lib/gnucash/libgnc-register-gnome.so lib/gnucash/libgnc-register-core.so
> lib/gnucash/libgnc-gnome-search.so lib/libgnc-html.so
> /usr/lib/x86_64-linux-gnu/libwebkit2gtk-4.0.so /usr/lib/x86_64-linux-gnu/
> libsoup-2.4.so /usr/lib/x86_64-linux-gnu/libjavascriptcoregtk-4.0.so
> lib/gnucash/libgnc-gnome-utils.so /usr/lib/x86_64-linux-gnu/libgtk-3.so
> /usr/lib/x86_64-linux-gnu/libgdk-3.so /usr/lib/x86_64-linux-gnu/
> libpangocairo-1.0.so /usr/lib/x86_64-linux-gnu/libpango-1.0.so
> /usr/lib/x86_64-linux-gnu/libatk-1.0.so
> /usr/lib/x86_64-linux-gnu/libcairo-gobject.so
> /usr/lib/x86_64-linux-gnu/libcairo.so /usr/lib/x86_64-linux-gnu/
> libgdk_pixbuf-2.0.so /usr/lib/x86_64-linux-gnu/libgio-2.0.so
> /usr/lib/x86_64-linux-gnu/libgobject-2.0.so /usr/lib/x86_64-linux-gnu/
> libglib-2.0.so lib/libgnc-backend-xml-utils.so -lz -ldl -lsecret-1
> lib/libgnc-app-utils.so lib/libgnucash-guile.so lib/libgnc-locale-tax.so
> -lguile-2.0 -lgc -lgio-2.0 -lxslt -lxml2 lib/libgnc-engine.so
> /usr/lib/x86_64-linux-gnu/libboost_date_time.so
> /usr/lib/x86_64-linux-gnu/libboost_regex.so -lgobject-2.0 -licui18n -licuuc
> -licudata -Wl,--export-dynamic -lgmodule-2.0 -pthread
> lib/libgnc-core-utils.so -lglib-2.0 && :
> lib/gnucash/libgnc-csv-import.so: undefined reference to
> `boost::re_detail_106501::icu_regex_traits_implementation::do_transform(int
> const*, int const*, icu_65::Collator const*) const'
> collect2: error: ld returned 1 exit status
> [743/894] Generating
> ../../lib/x86_64-linux-gnu/guile/2.0/site-ccache/gnucash/report/trep-engine.go
> wrote
> `/home/aikhan/Applications_src_build/build-gnucash-4.0/lib/x86_64-linux-gnu/guile/2.0/site-ccache/gnucash/report/trep-engine.go'
> ninja: build stopped: subcommand failed.
> -----------------------------------------------------
> Help please.
> Regards,
> aikhan
> 
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> 
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> ------------------------------
> 
> End of gnucash-user Digest, Vol 208, Issue 36
> *********************************************
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

More information about the gnucash-user mailing list