Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,745 views