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!

FK names when Engineer a Supertype/Subtype entity as table per child

Robert HuberJan 23 2025

For illustration I have a screenshot of the model and the relational model attached.

When I engineer the Supertype/Subtype entity in Subtree generation: Table per child, I get the naming of the foreign keys in such a way, that only the constraint based on the relationship to the subtype gets the subtypes name, in this case starting with profile_period_promotion_ …
The other 3 constraint get the name of the Supertype, i. e. starting with profile_promotion_ …

As it is a table per child implementation, I would like to have for these 3 constraints the name of the subtype, as this is what is engineered to for the relational model.

Is this possible?

TIA, Robert

Comments
Post Details
Added on Jan 23 2025
2 comments
162 views