For example, we have users of 3 types: internal users (employees of our company), clients, and contractors, and they are all in the same table, with a "type" field to differentiate them. We also have different domains for each: internal.domain.com, clients.domain.com, and contractors.domain.com. With each domain mapping to a user type. In order to log in to these portals, you need to have the correct user/pw obviously, and have the user type match the domain as well. Should these users be split from 1 table into 3?
One solution that has been mentioned is that the types of users would be classified as "roles", and therefore I would have an ACL to check this role for access to the domain.
Any thoughts or input would be greatly appreciated!