DB design document

[Dave Peticolas]

"Phillip Shelton" writes:
> (Taken from David M's schema.txt)
> SPLIT
> -----
> account_guid                    char    32      ->account.account_guid
> transaction_guid                char
>       ->transaction.transaction_guid
> split_guid                      char    32
> action                                          ???
> status                          char 1
> 'U'ncleared/'C'leared/'R'econciled
> split_amount                    rational        amount of the commodity
>                                                 positive is a debit value
>                                                 negative is a credit value
>                                                 (or vice versa?)
> damount                         rational        units of a security
> date_reconciled.tv_sec                          ???
> date_reconciled.tv_nsec                         ???
> share_balance                   rational        "
> share_cleared_balance           rational        "
> share_reconciled_balance        rational        "
> kvp_data                                        ???
> notes                           text            any notes the user enters
> 
> 
> <question>
> Aren't date_reconciled.tv_sec and date_reconciled.tv_nsec just the timestamp
> of the reconiliation?
> </question>

In the past yes, but now they are set to the date you choose
in the 'reconciliation info' window that pops up when you
start a reconciliation. By default, it is the current date.

dave