Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Table design question
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.comReceived on Wed Aug 21 2002 - 18:45:26 CDT
![]() |
![]() |