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

Home -> Community -> Usenet -> c.d.o.server -> Table design question

Table design question

From: PeterS <member_at_dbfoums.com>
Date: Wed, 21 Aug 2002 23:45:26 +0000
Message-ID: <1724237.1029973526@dbforums.com>

Hello everybody.
I have a table where foreign key references the same table's primary key. Primary key is just one column as well as foreign key. Is it good design?
Would it be better to create a separate lookup table? Foreign key column contains parents of a primary key column.

Thanks in advance!
Peter S.

--
Posted via http://dbforums.com
Received on Wed Aug 21 2002 - 18:45:26 CDT

Original text of this message

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