Re: Database Design Question - any suggestion?
From: Ja Lar <ingen_at_mail.her>
Date: Mon, 6 Dec 2004 21:06:24 +0100
Message-ID: <41b4bc19$0$223$edfadb0f_at_dread11.news.tele.dk>
Date: Mon, 6 Dec 2004 21:06:24 +0100
Message-ID: <41b4bc19$0$223$edfadb0f_at_dread11.news.tele.dk>
"Troels Arvin" <troels_at_arvin.dk> skrev i en meddelelse
news:pan.2004.12.06.19.04.50.515498_at_arvin.dk...
> On Mon, 06 Dec 2004 18:15:43 +0100, Ja Lar wrote:
>
>> I think it is a bad advice to encode business-meaning in the PK.
>
> In the spirit of your laconic message:
>
> I think it's good advice in this case.
I think it's a bad advice in any case. Why not - in this case - at least use
(split to) a composite key, possibly with each column a FK (a code) to a set
of values,eg: "color" , "size" etc.?
The need for a CHECK on a representation-determined format on a single
column key seems cautionary.
Received on Mon Dec 06 2004 - 21:06:24 CET