Subject | RE: Re[2]: [firebird-support] Primary Key, Foreign Key |
---|---|
Author | Alan McDonald |
Post date | 2003-11-20T10:32:34Z |
> >If TBL_PERSON and TBL_PARTY share the same PK - why don't youIf it's the same thing then I would argue the same ting again..
> just have the
> >fields in TBL_PARTY to the TBL_PERSON table.
>
> :))) Because I have a TBL_COMPANY as well.
>
> --
> Best regards,
> Alexander mailto:saho@...
You don't win anything in terms of storage, or speed or efficiency by
separating fields across tables when they all share the same PK.
Use FK logic for where it applies - i.e. many records for a single
master/parent
Alan