Schema

[Phillip Shelton]

> -----Original Message-----
> > Um, could you explain GUIDs? I am lost.
>
> Globally Unique ID, also known as UUID or Universal Unique ID. It is a
> 32 byte value usually calculated using the machine's MAC address and
> the time, plus some random stuff, plus more stuff I don't understand.
> It is guaranteed to be unique.
>
> The specification on UUIDs is available from The Open Group at
> http://www.opennc.org/onlinepubs/9629399/apdxa.htm
>

Thank you.

> > > split_guid                      char    32
> > > action                                          ???
> > > memo                            varchar         any notes the user
> > > enters
> > > reconciled                      char    1       Y/N
> > > damount                         money           does this
> mean debit
> > > amount?
> >
> > It is the smallest amount that this account can change by.
> GnuCash is
> > now using a variation on rational numbers which have a
> numerator, the
> > value, and a denominator, the damont.
>
> So 'd' stands for denominator. Okay, thanks.
>
> But then why is it in the SPLIT table?

I was wrong. See the mail from Bill.

> > > TRANSACTION
> > > -----------
> > > transaction_guid                char    32
> > > transaction_date                date            date of event
> >
> > These need a note field as well.
> >
> > A transaction is the unit that is entered in the ledger,
> and the splits
> > are for which accounts are affected by the transaction.  Others will
> > have a better explanation I am sure.
>
> So the note field is equivalent to "memo" in your register? There is
> already a memo field in the SPLIT table. Isn't it redundant to have it
> here?

The idea here was that I could have a note on the transaction saying one
thing about all the splits and then seperate notes on the splits.