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 -> foreign key references two different table?

foreign key references two different table?

From: Susan Lam <susana73_at_hotmail.com>
Date: 30 May 2003 15:13:48 -0700
Message-ID: <7186ed56.0305301413.50ce90f7@posting.google.com>


I have 3 tables.

parent1 (id, ...)
parent2 (id, ...)
child (id, memberid, type)

child.memberid came from parent1.id and parent2.id. child.type distinguishs where the memberid are from parent1 or parent2 table.

I would like to have a fk relationship between child.memberid -> parent1.id and parent2.id. However, I can't create two separate fks because parent1.id and parent2.id together are not unique.

Is there a way to create one fk to two different tables?

Thanks.
Susan Received on Fri May 30 2003 - 17:13:48 CDT

Original text of this message

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