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.

Vincent

_________________________________________________________________
    To unsubscribe: mail [EMAIL PROTECTED] with
               "unsubscribe" as the Subject
  archives at http://www.lazarus.freepascal.org/mailarchives

Reply via email to