DB design document

[Phillip Shelton]

<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?