Subject Re: basic question for database design
Author Ulrich
Hello Artur,

> I like global generators. One generator is enough, since the main
> propose of it is to unique identify the row.

Ok, I don't use one generator for every table. For tables which are
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, and
some
> numbers will be lost. If you will use just one generator, maybe
> int64
> will be a better option.

Yes, I thought about that too, and for this reason I use Int64 as
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