Hacker News new | ask | show | jobs
by Thiez 1850 days ago
In the Netherlands SSNs are not unique, they handed out some duplicate ones back in the day. So not great as a primary key. Besides, I think using them as primary keys is illegal anyway.
3 comments

In Denmark they are specifically not allowed to be used as a primary key. I mean many do, but technically your suppose to have a separate internal ID and then you use the SSN to look up that ID.
Huh? How does sign-in work for people with duplicate ID’s?
SSN's predate sign-in and the internet. Anyway there is a digital government sigle-sign-on solution called DigID, but you need to create an account etc for it using an e-mail address as the sign-in.
Imagine a man with a stick or gun coming to your office to shackle you in chains for how you arranged your database schema.