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