Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Separate tables based on role

    My system has multiple user types e.g. customers, administrators, service users. Customers and service users have similar attributes but administrative users have a variation.

    My current design has the users with common attributes (customers + service users) in a users table with a role attribute to identify the user type and a separate table for administrator users.

    I'm wondering, would it be better/cleaner to create a separate table for each user type and forget the role attribute..that way there won't be this business of some user types being in the user table and another separate table for admins even though symantically an admin is a user etc...

    In summary: is it better to have a separate table for each user type? what are the pros and cons..

    Thanks for any help!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    In my experience, it is better to have a single table of "Persons", and then a subtable listing their roles (allowing them to have multiple roles).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •