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_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

Reply via email to