Subject Re: basic question for database design
Author nelson_henrique
Mr. Ulrich,

> 1.) Are there any arguments for or against to use one generator for
> all tables, or should I use several generators? Or maybe one
generator
> for every table?

You can use generators to do some things.
You can share a generator with some tables, but you need to respect
generator value limit (2.147.483.647).

> 2.) I have read something about the concept of meaningless primary
> indizes, but in master-detail relation of two tables, I use primary
> index of master table for defining master-detail relation. Do I
break
> this concept with this? Do I have to add another data-column to
define
> master-detail relation?

If you use the Master.PK as Detail.PK, you can have only one Detail
record for each Master record (Relation One To One). If you want to
do this, it's Ok. But if you want relation One to Many, you need to
use another field to be your Detail.PK.

Regards