I'd have a problem with this because of the issue of changing names
(ie a woman gets married,etc)  I don't think a primary key should
involve data that could change.

My $.02

Marlon

On Thu, 1 Jul 2004 09:56:23 -0400, Todd <[EMAIL PROTECTED]> wrote:
>
> I believe he means that the combination of those four columns creates a
> unique identifier that can be used as the primary key, much as FirstName +
> MiddleName + LastName + DateOfBirth would go a long way to uniquely
> identifying you.
>
>
> ----- Original Message -----
> From: "brobborb" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, July 01, 2004 9:28 AM
> Subject: Re: Which to use as primary key?
>
> > You can only have 1 primary key.  and usually it is the unique identifier.
> however, those 4 columns can possibly be foreign keys.  I am not sure what
> your exact schema is, i am just generalizing.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to