Re: Tabe Relationship

From: Jason W. Paul <nobody_at_nowhere.com>
Date: Mon, 10 Mar 2003 06:49:52 -0500
Message-ID: <3e6c7be0$0$47454$a04e5680_at_nnrp.fuse.net>


I wouldn't consider it bad practice to do as outlined below. I would, however, add an indication in the USER table as to what Type of user it is -- an Administrator, a Client, or Staff. Without such a Type field,
you're gonna have to check all 3 tables to see which it's in. The Type
will point it at a specific table.

"john" <nospam_at_nospam.com> wrote in message news: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 - 12:49:52 CET

Original text of this message