I have 3 types of users for my mysql database:
>Admins
>Suppliers
>Employees
Would it be acceptable to have my database organized like this?
>user_type (description of each user type along with number)
>user_info (names/passwords/usernames/etc)
>user_admin
>user_suppliers
>user_employees
The last three tables will have specific info for each type.
>>347569
Maybe?
You're not really giving much detail here about what "specific info for each type" is.
Unless there's some kind of relational mapping between your proposed tables, i.e. one user_info can have more than one user_type, then they should all be the same table.
If every row of user_info can have only one user_type, and every row of user_type can have only one user_info, then they're really the same thing, and by putting them in different tables you're confusing the query planner and making it possible to violate your schema without the database noticing it.
>>347694
I think he is talking about roles but doesn't know that roles exist and thinks that everything is a table.