I need to design a database that has multiple users, with multiple roles. For instance, a user can be an admin, company, employee, or customer. Each user can have any number of these roles. Right now I have tables that look like this:
Right now, it seems as though when a user logs in, we will have to return from the "What role(s) is/are the user?" query in order to get the information out of the correct table (ex. admins, employees, customers, or companies). I would like to be able to query one time and grab all of a users information. Is this possible, if so how could it be done?
To sum up the problem: Notice that their are two independent sections (not connected by any lines to the other section). I need a way to connect those.