 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
[Editor/ERD] FK creation |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|