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!

How to rename a relationship attribute in SQL Developer Data Modeler?

4133895Nov 14 2019 — edited Nov 21 2019

Hello Forum Users

I am a newbie to this forum.  So please bear with me.

I am a seasoned data management person.  And have had a lot of experience in data modelling, predominantly using ERwin.

My question is about SQLDeveloper Data Modeller (abbr SDDM). I have recently started using SDDM (Version 19.2 0.182).  I am a long time ERwin user.  I am developing a "Logical Model".

I need to define a "Node" entity to represent a hierarchy (recursively).  The Node entity has just 3 attributes, viz., node_id, node_name, sw_apex, with node_id being the PK.

I added the 1-to-M (non-identifying relationship, of course) to from Node to Node.

That resulted in the Node entity getting the attribute of node_id1 (link a Node to its immediate parent).

The new attribute was named as node_id1 because the primary key is node_id, and to obey the rule of uniqueness of attribute names within an entity a suffix of 1 was applied.  One would expect something like this from any tool.

However I did not get any opportunity to name the attribute that links an instance to its immediate parent.

And worse, there seems to be no way of changing the name "node_id1".  I would like name it as "parent_node_id". How do I achieve this?

The Release 18.2 User Guide did not help. I will appreciate help from people with greater experience with SDDM.

Thanks for your help. - Madani

Message was edited by: Madani Basha I found the means of doing of what I needed to do myself .. only moments after I posted the query. Normally the name change would be done within the Entity Properties dialog box. However relationship attributes are greyed out. One needs to select the newly added attribute, and click the "Properties" icon (left of the green Add + icon), which opens up the "Attribute Properties" dialog box, wherin the name could be changed. Phew. Seems an long winded and obscure way of getting the work done. But then I am new to the SDDM. Cheers. - Madani

Comments
Post Details
Added on Nov 14 2019
5 comments
1,557 views