SSDM Alters The Name Of The"Foreign Key" Attribute In The Child Entity
Last updated on OCTOBER 27, 2016
Applies to:Oracle SQL Developer Data Modeler - Version All to All
Information in this document applies to any platform.
In case of two entities with one-to-many relation and the parent has an UID-attribute (XXX.AA) with the same name as an attribute in the child (YYY.AA),
the name of the corresponding "FK-"attribute (XXX.AA in YYY) will change whenever an attribute in the parent will change. (An suffix 1 or 2 will be added to XXX.AA in YYY).
- open the edit dialog for the child and observe the name of the FK-attribute (e.g. AA1, in fact XXX.AA)
- select an attribute in the parent in the edit dialog (and click ok)
- now open the edit dialog for the child again and observe the name of the FK-attribute
- the name has changed from AA1 to AA2 (or vice versa).
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