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

write
preview
109 sats \ 2 replies \ @freetx 12 Feb

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
0 sats \ 0 replies \ @Bell_curve 12 Feb

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
0 sats \ 0 replies \ @Bell_curve 12 Feb

Is there a good reason for using the wrong SSN?

#883712

reply