Subject | Re: basic question for database design |
---|---|
Author | nelson_henrique |
Post date | 2004-04-30T15:09:36Z |
Mr. Ulrich,
You can share a generator with some tables, but you need to respect
generator value limit (2.147.483.647).
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
> 1.) Are there any arguments for or against to use one generator forgenerator
> all tables, or should I use several generators? Or maybe one
> 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 primarybreak
> indizes, but in master-detail relation of two tables, I use primary
> index of master table for defining master-detail relation. Do I
> this concept with this? Do I have to add another data-column todefine
> 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