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!

Supertype/Subtype relationships to Relational Model

Robert HuberDec 6 2016 — edited Dec 28 2016

Hi

I have a Supertype/Subtype Entity with the relationships as shown in the attached Logical Model screenshot. When I run Engineer to Relational Model with Subtree generation set to: Table per child, I get correctly 2 tables. Unfortunately, the foreign key names of the Supertype get in one of the child tables (in this example in profile_period_promotions) a suffix _fkv1. This is not the expected/desired result. It shouldn't have the v1 attached. I can rename it, but the fk name keeps the v1. Is there a way to achieve that? Otherwise it would be nice if Data Modeler could handle that.

Regards,

Robert

logical model.png

relational model.png

This post has been answered by Philip Stoyanov-Oracle on Dec 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2017
Added on Dec 6 2016
12 comments
1,866 views