Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Separate foreign keys with shared ID space
"Laconic2" <laconic2_at_comcast.net> wrote in message
news:dqKdnYKfZI3MJJPcRVn-sA_at_comcast.com...
>
> "Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message
> news:410affcf$1_at_post.usenet.com...
>
> > A PK should have no business meaning. Therefore, I'll not add such a
> column
> > to the primary key.
>
> This is too strongly stated.
>
> The following sounds better to me:
>
> A PK should have no business meaning other than to identify (an instance
of)
> an entity or a (reified) relationship.
>
I completely agree with you!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=