So if we imagine you're tasked with setting up a Database.
There'll be a table called
USER:
And within that there's:
Id
Name
Username
Password
Telephone (Phone verification)
Email (Email Verification)
Interests.
The Email/Username and Password are login parameters.
Should one store them in the same Table as User? I'm looking at using Azure to store the Database (using MySQL, never used this before)
How would you store the Email/Username and Password in a secure manner?
ALSO: Would SSO need its own table structure? I'm looking into that as well but in the future.