Re: DB design document

2000-12-19 Thread Dave Peticolas
"Phillip Shelton" writes: > Depends on how you use groupings. Are we going to allow someone to have an > account that is part of credit and part of clothes, part of sport, part of > hobbies ... > > There was a question some time ago about being able to get away from having > a tree of accounts an

Re: DB design document

2000-12-19 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote: > > > > ACCOUNT_GROUP > > - > > group_guid char32 > > group_name textname of the group of accounts > > notes textany notes t

RE: DB design document

2000-12-19 Thread Phillip Shelton
Depends on how you use groupings. Are we going to allow someone to have an account that is part of credit and part of clothes, part of sport, part of hobbies ... There was a question some time ago about being able to get away from having a tree of accounts and moving to a connected graph. This w

Re: DB design document

2000-12-19 Thread David Merrill
On Wed, Dec 20, 2000 at 12:05:29PM +1000, Phillip Shelton wrote: > You will possibly need to keep a checkpoint on the share_* values as well. > > These are, I assume, the balances for the damounts in the splits? Yes. I corrected it. -- Dr. David C. Merrill http://www.luperc

Re: DB design document

2000-12-19 Thread David Merrill
On Tue, Dec 19, 2000 at 06:57:34PM -0800, Dave Peticolas wrote: > "Phillip Shelton" writes: > > > > ACCOUNT_GROUP > > - > > group_guid char32 > > group_name textname of the group of accounts > > notes textany note

Re: DB design document

2000-12-19 Thread David Merrill
On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote: > > ACCOUNT_GROUP > - > group_guid char32 > group_name textname of the group of accounts > notes textany notes the user wishes to make > > An accou

Re: DB design document

2000-12-19 Thread Dave Peticolas
"Phillip Shelton" writes: > > ACCOUNT_GROUP > - > group_guid char32 > group_name textname of the group of accounts > notes textany notes the user wishes to make > > An account group is just what it sounds like, a

RE: DB design document

2000-12-19 Thread Phillip Shelton
You will possibly need to keep a checkpoint on the share_* values as well. These are, I assume, the balances for the damounts in the splits? Phill ___ gnucash-devel mailing list [EMAIL PROTECTED] http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucas

RE: DB design document

2000-12-19 Thread Phillip Shelton
ACCOUNT_GROUP - group_guid char32 group_name textname of the group of accounts notes textany notes the user wishes to make An account group is just what it sounds like, a group of accounts. All accounts in an ac

Re: DB design document

2000-12-19 Thread linas
It's been rumoured that David Merrill said: > > On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote: > > David Merrill <[EMAIL PROTECTED]> writes: > > > > > Please take a look at the latest revision of my design document and > > > give me some feedback. > > > * design an API that's

Re: DB design document

2000-12-19 Thread David Merrill
On Tue, Dec 19, 2000 at 12:21:52AM -0800, Dave Peticolas wrote: > "Phillip Shelton" writes: > > (Taken from David M's schema.txt) > > SPLIT > > - > > account_guidchar32 ->account.account_guid > > transaction_guidchar > > ->transaction.transact

Query API

2000-12-19 Thread Christopher Browne
On 18 Dec 2000 13:00:56 EST, the world broke into rejoicing as Derek Atkins <[EMAIL PROTECTED]> said: > Christopher Browne <[EMAIL PROTECTED]> writes: > > It shouldn't be a situation of the GUI submitting database queries; > > instead, the GUI should submit _transaction_ queries to the engine, an

Re: DB design document

2000-12-19 Thread Dave Peticolas
"Phillip Shelton" writes: > (Taken from David M's schema.txt) > SPLIT > - > account_guidchar32 ->account.account_guid > transaction_guidchar > ->transaction.transaction_guid > split_guid char32 > action