[PHP-DB] table relationship

[shaun]

Hi,

I am creating a web site which will have different types of users:
Administrators, clients and staff. Is it possible/good practice to have 3
tables related to one table i.e.


                             USER
                             user_id (PK)
                                  |
          ____________|____________
          |                       |                        |
          |                       |                        |
Administrator        Client                  Staff
admin_id(PK)       client_id(PK)       staff_id(PK)
user_id(FK)          user_id(FK)        user_id(FK)


Thanks in advance for any advice offered.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php