DB design document

David Merrill dmerrill@lupercalia.net
Tue, 19 Dec 2000 22:24:58 -0500


On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote:
> <quote>
> ACCOUNT_GROUP
> -------------
> group_guid              char    32
> group_name              text            name of the group of accounts
> notes                   text            any notes the user wishes to make
> 
> An account group is just what it sounds like, a group of accounts.
> 
> All accounts in an account group must be denominated in the same commodity.
> </quote>
> <question>
> Where do you keep which accounts are in the group?
> </question>

:)

Good question.

I just added a group_guid field to the account table. An account can
only belong to one group. Is that wrong?

-- 
Dr. David C. Merrill                     http://www.lupercalia.net
Linux Documentation Project                dmerrill@lupercalia.net
Collection Editor & Coordinator            http://www.linuxdoc.org
                                       Finger me for my public key

By the Earth that is Her body
By the Air that is Her breath
By the Fire of Her bright spirit
By the Waters of Her living Womb,
The circle is cast.
		-- Traditional Circle Casting