Re: Surrogate primary key plus unique constraint vs. natural primary key: data integrity?
From: Cimode <cimode_at_hotmail.com>
Date: Tue, 12 Mar 2013 08:56:45 -0700 (PDT)
Message-ID: <22060730-7dda-46b5-9978-d346128961a2_at_googlegroups.com>
Date: Tue, 12 Mar 2013 08:56:45 -0700 (PDT)
Message-ID: <22060730-7dda-46b5-9978-d346128961a2_at_googlegroups.com>
All unique identifiers are at some point in time a surrogate key. Only designer's subjectivity qualify them as natural or primary key.
In the context of guaranteeing data integrity, I am still amazed at how such implementation-driven minor point triggers so much debate.
Received on Tue Mar 12 2013 - 16:56:45 CET