How to Ensure Foreign Key Column Names Persist From Logical To Relational

(Doc ID 2407708.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle SQL Developer Data Modeler - Version 17.3 and later
Information in this document applies to any platform.

Goal

You are forward engineering a new design. When establishing Foreign Key constraints, you are renaming the column that gets auto-generated in the child table because there are occurrences that have two references. These names do not seem to persist when generating a Relational model.

For Example:

Table T1:
    id
    code

Table T2:
    id
    T1_code_a
    T1_code_b  


When generating the Relational model, table T2's columns will revert to:
  

    id
    T1_code
    T1_code2

 
How can the custom names in the Logical model be preserved in the Relational model?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms