Seems simple, but... if you avoid the use of plurals, the table names will
From: Greg Stein [mailto:gstein_at_gmail.com]
Sent: Thursday, April 01, 2010 3:02 PM
To: Jan Horák
Subject: Re: SQL backend database scheme
A couple small nits:
* maybe use "txn_id" rather than "txt_id". the latter sounds like
"text" rather than "transaction", and "txn" is used in the APIs
* transactions_proplist has a txnprop_id which is never referenced.
I'd suggest making <txn_id, name> the primary key.
2010/3/29 Jan Horák <horak.honza_at_gmail.com>:
> Hi everybody,
> I've prepared a database scheme of the upcoming MySQL backend, it is
> I have arisen from BDB and FSFS backend design, some previous analyses:
> and from historic MySQL backend design:
> Any ideas or comments will be appreciated.
> Jan Horak
Received on 2010-04-01 21:34:44 CEST