Re:Be Careful with UUID or GUID as Primary Keys
by ksenzee on Friday June 09, 2017 @05:49PM
(#14524873)
Even that is not a forever guarantee. Laws can and do change.
[ Parent
| on HN ]
Re:Be Careful with UUID or GUID as Primary Keys
by dbenhur on Friday June 09, 2017 @06:14PM
(#14525006)
And people act outside the bounds of the law. SSN seems like a good natural key candidate, until you discover some of the people your business interacts with are illegal aliens.
Re:Be Careful with UUID or GUID as Primary Keys
by int_19h on Friday June 09, 2017 @08:38PM
(#14525595)
Or legal aliens, like tourists. Or foreigners, who aren't even in the country. Or really anyone else who doesn't work in the country, and doesn't have to report taxes.
Ironically, many illegal immigrants actually do report taxes. In which case they use ITIN, which is compatible to SSN format-wise (###-##-####)... but it is not unique over time.
Re:Be Careful with UUID or GUID as Primary Keys
by squeaky-clean on Friday June 09, 2017 @06:08PM
(#14524972)
Definitely true, but at a certain point you need to draw a line. If these things were to change, the entire product would have to change, not just what I use as my keys, so I think natural keys are a safe bet in my case.