title: combining tables role based access control and user information in sql
body: <p>I am looking to find a solution to structure information about users for a web based application and their personal information. users have certain capabilities or restrictions based on their role(role based access control) I am using MySQL and PHP.</p>
  
  <p>I want to set up a database with the following tables:
  User (ID, username, password, Role, Admin/employee/client/customer)
  Roles(ID, role_name)</p>
  
  <p>Roles can be: admin, employee, client, customer</p>
  
  <p>Admin(ID, name, surname, more usefull information)
  Employee(ID, name, surname, more usefull information)
  client(ID, name, surname, more usefull information)
  customer(ID, name, surname, more usefull information)</p>
  
  <p>what I would like is to get all the information about a user, whether he is an admin, amployee, client or customer.</p>
  
  <p>What would be an advisable method to do this in SQL.</p>