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!

Mandatory columns for optional FK's

user13430807Jan 25 2016 — edited Jan 25 2016

Hello,

I have the following model:

Naamloos.png

column table_3.column_1 is enforced as mandatory by a mandatory fk to table_1.

column table_3.column_1 and table_4_column_2 are enforced optional by an optional fk to table_4.

So there is a conflict for table_3.column_1 and the following window pops-up:

Naamloos2.png

Pressing Yes tries to make column_1 optional but it does not succeed, which is correct.

The pop-up should not occur for columns being enforced as mandotory by other mandatory fk's or other constraints like pk's.

Joop

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2016
Added on Jan 25 2016
0 comments
448 views