• asdfasdfasdf@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    13 days ago

    Just curious, but if SSNs were not recycled after death, would there be any reason not to use them as a primary key?

    • franzfurdinand@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      edit-2
      13 days ago

      They’re sequential, so the values above and below yours are valid SSNs of people born in the same hospital around the same time.

      This would make it trivially easy to get access to records you shouldn’t

    • tiredofsametab@fedia.io
      link
      fedilink
      arrow-up
      0
      ·
      13 days ago

      As the user posted, one human can have more than one SSN in their lifetime. Many humans will never have an SSN. Some of those humans may have a TIN. Some humans may have at least one TIN and one SSN at some point.