DB design document

[Dave Peticolas]

"Phillip Shelton" writes:
> <quote>
> ACCOUNT
> -------
> account_guid                    char    32
> parent_account_guid             char    32      -> account.account_guid
> group_guid                      char    32      -> account_group.group_guid
> account_type                    integer         ->
> account_types.acct_type_code
> account_code                    char    20      a mnemonic for the user
> account_name                    text            bank, lienholder, etc.
> description                     text            long explanation of the
> account
> commodity_guid                  char    32      ->
> commodities.commodity_guid
> balance                         rational
> cleared_balance                 rational
> reconciled_balance              rational
> share_balance                   rational
> share_cleared_balance           rational
> share_reconciled_balance        rational
> commodity_scu                   integer         smallest convertible unit
> 
> kvp_data                                        ???
> </quote>
> 
> 
> should there be a smallest convertible unit for the security(damount) as
> well as for the commodity?  Or do only splits have securities?

You're right, there should be one for both.

dave