I’ve been professionally making database since 1997 and “natural” primary keys was an antipattern even back then (along with the int sequence since it only allowed 2 or 4 billion).
Socials change. Emails change. Seemingly natural, unchanging things change and mess up all the foreign key relationships.
Socials change. Emails change. Seemingly natural, unchanging things change and mess up all the foreign key relationships.