| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Tabe Relationship
: 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)?
Regards,
Damjan S. Vujnovic
University of Belgrade
School of Electrical Engineering
Department of Computer Engineering & Informatics
Belgrade, Serbia
http://galeb.etf.bg.ac.yu/~damjan/ Received on Mon Mar 10 2003 - 07:59:40 CST
![]() |
![]() |