I have 3 types of users:

  • Admins
  • Suppliers
  • Employees

Each user type will have different user interface and access different types of data. Their only similarity is they are using one web application but they access totally different things. Is it better to put them all in one user table like tbl_users or is it better to create tbl_admins, tbl_suppliers, tbl_employees?

mysql database database-design user-interface relational-database
Edit
Report