Tabe Relationship

From: john <nospam_at_nospam.com>
Date: Mon, 10 Mar 2003 09:29:48 -0000
Message-ID: <eVYaa.11795$Lq.941540_at_stones>



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 - 10:29:48 CET

Original text of this message