Im building this website for a small store and I was told that its better not to keep the login and the rest of the users information on the same table.
Now im wondering, what is the best way to implement this website's database?
Some of the database tables are:
I need to have different users, after someone is logged in the site, depending on their rights they can do a series of things:
- If they are a customer they can order stuff
- If they are employees they can order stuff, manage stock, add customers, etc
- If they are the owner or administrator they can add employees and everything else.
Should I keep the login and the rest of the information of the user in the same table?