DB design document

Dave Peticolas dave@krondo.com
Tue, 19 Dec 2000 22:40:10 -0800


David Merrill writes:
> 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?

That is correct.

dave