I have a web page with a login functionality. Logging in is based on email addresses. Also, I have to keep basic user profile information like:
- zip code
- mobile phone
- contact name
And the user's email and a hash of their password (of course).
I know storing all of this data in one table is a bad idea, but I cannot come up with a better solution for now. Can you help me with that and suggest a way of dividing this data into different tables?
I would also like to keep track of all changes that user does with his account data (physical address/name/phone number/email/password hash).