Re: Separate foreign keys with shared ID space

From: Laconic2 <laconic2_at_comcast.net>
Date: Mon, 2 Aug 2004 18:01:43 -0400
Message-ID: <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. Received on Tue Aug 03 2004 - 00:01:43 CEST

Original text of this message