table relationship
| From: | shaun | Date: | Mon, 10 Mar 2003 09:35:05 +0000 |
| Subject: | table relationship | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26224@lists.php.net to get a copy of this message | ||
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.