| Subject | Re: basic question for database design | 
|---|---|
| Author | Ulrich | 
| Post date | 2004-05-01T06:13:06Z | 
Hello Artur,
storing only some lookup data, I use a common generator. Only the main
data tables like customers, articles and invoices have their own.
 
primary key for all tables.
Thanks for your help.
Regards - Ulrich
            > I like global generators. One generator is enough, since the mainOk, I don't use one generator for every table. For tables which are
> propose of it is to unique identify the row.
storing only some lookup data, I use a common generator. Only the main
data tables like customers, articles and invoices have their own.
> Remember that sometimes you rollback, sometimes you delete, andsome
> numbers will be lost. If you will use just one generator, maybeYes, I thought about that too, and for this reason I use Int64 as
> int64
> will be a better option.
primary key for all tables.
> that it's excellent for a master/detail relation.That was what I would like to hear ;-)
Thanks for your help.
Regards - Ulrich