I have the following situation for a Supertype/Subtype entity, as seen in the attached screenshot. It is translated as Table per Child.
As a result, I get for the constraint names for the "based on" relationship names as expected "profile_probation_promotion_based_on_fk", and "profile_period_promotion_based_on_fk"
For the 3 remaining relationships, bound to the Supertype, I get
"profile_promotion_defined_by_fk", "profile_promotion_lined_up_on_by_fk", and "profile_promotion_bount_to_fk".
As it is a Table per Child implementation, where there is not table profile_promotions, I would like to get the 3 foreign keys to be named starting with
"profile_probation_promotion_defined_by_fk", ...
and "profile_period_promotion_defined_by_fk", ...
With this, because these leds to 2 constraints having the same name, it is avoided that one of these constraints gets the _fkv1 ending.
Is this possible?
Thanks a lot, Robert
