26 Feb
2019
26 Feb
'19
5:21 a.m.
At 08:38 2019-02-25, Ed Leafe ed@leafe.com wrote:
On Feb 25, 2019, at 10:26 AM, Ted Roche tedroche@gmail.com wrote:
There's a couple of issues with using SSNs.
Technically, they are not unique. Several people have received duplicate numbers, so they're not ideal primary keys.
They are presumably being used as PKs for tables representing humans, no? Then the vast majority of potential records would have null values, since most humans are not citizens of the USA.
You do not have to be a USA citizen to have an SSN. I had one when I worked down there on a visa; it might even still be assigned to me.
Sincerely,
Gene Wirchenko