pull down to refresh
9 sats \ 3 replies \ @Bell_curve 12 Feb \ parent \ on: The government doesn't use SQL (or Elon has never used SQL) devs
I guess SSN is not a primary key
Even if its not a primary key, it could still have UNIQUE constraint applied.
I imagine there a valid reasons why they don't have it set. The amount of people either unintentionally or intentionally using the wrong SSN is probably non-trivial. Having it as a unique/primary key would prohibit you from doing some other transaction involving that person.....
I mean technically a SSN is "only" supposed to refer to your social security account, it was never intended to become a universal identifier....
reply
I can't wait for the next judical activist to rule on primary keys, foreign keys, unique constraints, inner/outer joins.
No master/slave architecture! 13th amendment prohibits any kind of slave.
reply
Is there a good reason for using the wrong SSN?
reply