Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Tabe Relationship

Tabe Relationship

From: john <nospam_at_nospam.com>
Date: Mon, 10 Mar 2003 09:29:48 -0000
Message-ID: <eVYaa.11795$Lq.941540@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 - 03:29:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US