3 ms·
SSN are supposed to be unique. They are not. If you try to use them as a unique identifier in a database, your customers/end users will be sorry. In the payroll
by Tangurena2 4y ago
SSN are supposed to be unique. They are not. If you try to use them as a unique identifier in a database, your customers/end users will be sorry. In the payroll app that I'm currently working on, 111111111 is used as a temporary number. Which ends up not being temporary enough.
- paledot 4y ago> your customers/end users will be sorry So will you, because your database is now bleeding red-hot PII across every query and foreign key. Chances are you'll now end up with a web interface that uses SSNs in its URLs. Holy hell, how was this even considered?
- kube-system 4y agoFWIW, they did say unique identifier, not primary key.
- paledot 4y agoFair point. Hopefully that was just me jumping to an uncharitable conclusion, and if so I apologize.