Multi user types in one portal with it's own cabinet and unique tech?

[orion_rus]

I simply have a common user, tourfirm, and touroperator and admin. How is the best way to organize their information?
Try to describe. I have a one table to auth user. in the user field i have usertypeid - user type, like admin, common user and so on...
after it system make user variable calling equal to usertype class.
I need a tables with it's unique information aboout each user. Am i need to create a tables like
userfirmtable with userfirmid, or i need to user unique userid?
May be anybody can suggest me better organization way)
Thanks in advance!

[coopster]

There are a number of different ways to accommodate users and groups. I guess it really comes down to the "how many" question. How many users, how many groups?

One layout might be as simple as a users table, a groups table, and a user-to-group cross reference table. The user-to-group cross reference table would contain the uniques user identifier and the group they belong to, or groups they belong to if they are in more than one group in which case they would have more than one row in that table.

Another option is to use binary representation, but that limits your group structure to 32 or 64, depending on the OS or database being used to store the number.