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

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

Re: Tabe Relationship

From: karl wettin <wettin_at_users.sourceforge.net>
Date: Tue, 11 Mar 2003 11:53:03 +0100
Message-ID: <20030311115303.7a5e62e8.wettin@users.sourceforge.net>


On Mon, 10 Mar 2003 18:00:49 +0100
"Damjan S. Vujnović" <damjan_at_galeb.etf.bg.ac.yu> wrote:

> : 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.
>
> What if USER can be both Administrator and Staff (or any other combination)?

In that case I would consider a composite pattern.

karl Received on Tue Mar 11 2003 - 04:53:03 CST

Original text of this message

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