Re: Multiple Foreign Keys in the Same Table
Posted by: Peter Brawley
Date: June 03, 2015 10:32AM

From your description, I'm unclear where dx1, dx2, dx3 and dx4 are (eg are they in master icd tables then referenced by patient table columns?) and what problem your reflexive foreign keys are meant to solve. Please show the result of Show Create Table for this & any related tables, and say a bit more about the relationship you're trying to model.

Options: ReplyQuote


Subject
Written By
Posted
Re: Multiple Foreign Keys in the Same Table
June 03, 2015 10:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.