3 ms·
It's less about literature, and more about experience. Over the years just about every natural key I've seen ends up being either not-universal (-everyone- has
by bruce511 3y ago
It's less about literature, and more about experience.
Over the years just about every natural key I've seen ends up being either not-universal (-everyone- has a phone number right? Even that new-born baby?) Or not unique (phone numbers can be shared) or mutable (like people's names changing).
It's just so much easier to add a column and use a surrogate key. I prefer uuids because they are unique And immutable - properties I really appreciate in primary keys.
- beachy 3y agoIt's an easy challenge. Just ask someone to name a natural key that will never change. They are as rare as rocking horse shit.