On Mon, 2006-10-09 at 20:55 +0200, Vincent Snijders wrote:
> Christian Ulrich wrote:
> >>Multiple-fields-primary keys, for
> >>example, I consider as a bad design. (I can imagine some
> >>exceptions, but those are really rare)
> >
> >
> > Why ? I have at example an article table wher the primary key consists
> > of
> > article number + version + language
> >
> > Why an primary key that consists of these 3 fields is not an good idea
> > ??
> >
>
> Because if you want to use that article in order item table or a bill of
> materials table, you need to add 3 fields as foreign key.
Oh, yes. That also. ;)
Joost
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
