Comment on It's ~2026 –. ChatGPT still doesn't allow email changeparentComments−esafak9moYou can use a random numerical ID as PK and let people associate as many authn IDs as they want after logging in with one.−Reubachi9moWho in this scenario outlines the key infrastructure, and how is the private key maintained?−esafak9moprimary key. https://en.wikipedia.org/wiki/Primary_key−thiht9moWhy would you allow this complexity for basically nothing?−esafak9moUsing a separate table for authn is a basic pattern for this problem. What would you do?
Comments
You can use a random numerical ID as PK and let people associate as many authn IDs as they want after logging in with one.
Who in this scenario outlines the key infrastructure, and how is the private key maintained?
primary key. https://en.wikipedia.org/wiki/Primary_key
Why would you allow this complexity for basically nothing?
Using a separate table for authn is a basic pattern for this problem. What would you do?