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!

one-off naming of FK column

Mike KutzOct 28 2020

new to SDDM v20.2
For the most part, when I create a relation in the Logical Model, the generated column name (for the FK value in the child table in the Relational Model) is suffice.
In rare circumstances, I need the column name in the child table to have a very specific name.
Is this possible to define that within the Logical Model? if so, how?

Thanks,
MK

Comments

use preferred abbreviation - here are two pictures
Attribute_pref_abbreviation.png
engineering_pref_abbrev.png
Philip

Mike Kutz

@philip-stoyanov-oracle
The PK Attribute on the Parent Entity comes from "Create Surrogate key" on the parent Entity (image 1)
The Attribute I want to modify isn't listed on the Child Entity (image 2).
Beyond that, it looks like this trick should work.
MK
Image 1 - PK on Parent is auto-created
image.png
Image 2 - no Attribute to modify.
image.png

is there a rule for that name?
Philip

Mike Kutz

Where to check?
I'm just starting to use SDDM. I don't think I defined any naming rules.
I've modified the Naming Templates (image). But that should be it. maybe a few check boxes for Engineering.
MK
image.png

HansJK

You can also just type the name you want while editing that attribute in the attribute list.
It will get overridden if you should re-run naming conventions. So I paste my chosen name into the comments of that attribute (not RDBMS comments, just tool comments). then at least I can copy paste it back or I make sure to re-run naming conventions opton without foreign key columns applied.

well, if you want the name to not change then you can use "Tools>Object names administration" utility to make that name unchangeable

Philip

HansJK

Thank you @Philip Stoyanov-Oracle. That is cool.
If I may, it would have been nice if a direct "link" to that feature would be that I could on the relevant object/attribute indicate/tick that it must be fixed and not have to go to another screen to achieve this. Also having this "central" place/way of being able to see all things flagged as fixed.
Just my two cents...

1 - 7

Post Details

Added on Oct 28 2020
7 comments
126 views