4 ms·
I’m not sure it does the job of a natural key though. When you renew a card you can keep the number but get new exp/security number which should probably be con
by hombre_fatal 1y ago
I’m not sure it does the job of a natural key though. When you renew a card you can keep the number but get new exp/security number which should probably be considered a different record.
The bigger issue: I also wouldn’t be quick to assume I know the idiosyncrasies of all card systems, like whether they reuse numbers.
- deleted 1y ago[deleted]
- ThunderSizzle 1y agoThe natural step is a multicolumn key (e.g. the key includes all three data points). I've seen tables where primary keys were 7-10 columns long. It's a nightmare to work with when joining.