SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[Editor/ERD] FK creation

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[Editor/ERD] FK creation
Author Message
michalk



Joined: 29 Aug 2014
Posts: 211

Post [Editor/ERD] FK creation Reply with quote
hello
By random clicking I discovered ERD editor. Out of curiosity I give'm a try.
I noticed 2 issues:
1. Undo of adding FK relation removed whole parent table instead of just created FK. How to replicate:
a) create table
b) add primary key
c) Press OK
d) select 1:n relationship
e) click on table twice (for source and destination of relation)
f) try to undo the operation (ctrl+z)
expectation: removing the FK
result: whole table is being removed

2. Adding foreign relation doesn't automatically adds new column for FK. How to reproduce
a) create table A with PK column named my_id
b) create table B
c) select 1:n relationship
d) click on table A then click on table B
e) relationship is added
expectation: new column (named my_id) is added to B table
result: relationship is added by there is no FK field in B table as well as no field-to-field assignment information

At the end it seems that ERD editor is in early stage of development. I'm looking forward to see it fully functional. I would really appreciate a lightweight tool dedicated for database ERD
Fri Jan 06, 2017 8:30 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you very much for reporting the issues. I have logged both of them.
Yes, this is just a first initial version, it will be enhanced over time.
Fri Jan 06, 2017 3:50 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Sorry forgot to describe the solutions for both issues.

To remove a FK, double-click the link or right-click and choose Edit. In the Edit dialog, delete the FK you don't need.
To edit the column assignment, double-click the link or right-click and choose Edit. In the Edit dialog, select source and Reference columns. Click OK to save.
Fri Jan 06, 2017 4:01 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.