Tabe Relationship

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. Received on Mon Mar 10 2003 - 03:29:48 CST