is there any way to have multiple seperate user tables ?
multiple user tables
-
- User
- Posts: 642
As long as any of those users can log into the system. It does not make sense if you can pick users from more than one table, coz its kind of hard to handle repetitions etc.
Rather for whatever differences they have you can add field to help you differentiate them eg add a user_branch, user_company user_department_1 user_section etc etc for whatever difference you may have between the users.
After that you can then create editable views out of the main user table to help you see a list of particular users.
foe example.
CREATE VIEW vw_male_users as select * from user_account where gender = 'MALE';
this can still be used like a normal table for adding edit deleting etc.
If that does not work for you, then what did you want to achieve in the first place, why do you want to separate them, explain in more details