3 ms·
> Natural keys exist They probably do, but everytime I thought something was good as a natural key, I've been wrong
by williamdclt 5y ago
> Natural keys exist
They probably do, but everytime I thought something was good as a natural key, I've been wrong
- phkahler 5y agoAgreed. The simplest example is names. People don't have unique names so you combine it with some other stuff (birthdate, SSN) and call it a primary key. Then someone gets married and changes their name. To anyone doing this for a short amount of time this example is obvious. The point is that almost everything you might think of as a "natural key" is not good enough and you'll get burned when you find out what the reasons are.
- deleted 5y ago[deleted]