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