What the use of 'slots' table in gnucash with mysql

[Art]

Someone else can give you an authoritative response, but I've noticed mine has notes or dates associated with some transactions. I've tweaked it from SQL scripts, but always after backing up my database. Mostly I just avoid deleting or creating any record on any table outside of GnuCash. The "name" field on all of "my" records is either "'notes'" or "'date-posted'", so it appears to be a metadata thing. I've noticed that the "'date-posted'" records also have a "null" "string_val" entry with a valid "gdate_val" entry and vice-versa which suggests a "virtual" table indirection for flexibility.


- Art



________________________________
 From: Jorge Zapata <jorge.zapata at jazg.net>
To: gnucash-devel at gnucash.org 
Sent: Sunday, September 16, 2012 12:12 PM
Subject: What the use of 'slots' table in gnucash with mysql
 
Hi, I'm developing a PHP web application and I want this app to read/write
into gnucash mysql database just like the program does. I have an idea what
is the goal of most of the tables but I simply don't what's the use of
slots table.
I activated a log in mysql server just to understand which insertions are
performed by gnucash in simple transactions and I've realized that every
insertion involves the slots table.
Can someone explain me what slots table does? If I don't want to consider
sots table in my application will that cause a problem when working with
the same database but using the program?

Thanks

-- 
*Ing. Jorge A. Zapata Guridi*
*Software Developer*
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel