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