Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I define a foreign key relationship in a Logical Model?

3144059Feb 23 2016 — edited Mar 2 2016

How do I define a foreign key relationship in a Logical Model?


When I create a 1:N relationship in a Logical model, a new foreign key column is added to the child-table; but I want the relationship to use an existing column as foreign key.


In the Relation Model I can do this with the Associated Column part of Foreign Key Properties.


But I can’t see that this is available in the Logical.  I would expect to be able to use the Target Key field but I cant modify it.


Whats wrong ?  Is it not possible in the Logical?


I am using 4.1.3 and have tried 4.1.2

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2016
Added on Feb 23 2016
1 comment
643 views