Bug #33803 More control over relationships
Submitted: 10 Jan 2008 17:00 Modified: 30 Jan 2008 18:09
Reporter: Kasia Rachwal Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.11 OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: foreign key relationships
Triage: Triaged: D5 (Feature request) / R3 (Medium) / E3 (Medium)

[10 Jan 2008 17:00] Kasia Rachwal
Description:
I like to create complex diagrams (i) without overlapping relationship lines and (ii) without having the relations cross tables in tight spots. I would also like to have the lines start and end on the columns which they link instead of just anywhere on the tables involved.

How to repeat:
Draw a diagram with two tables which have a foreign key relationship and move one of them around. The relationship line is not adequately flexible when increasing numbers of related tables are added.

Suggested fix:
I can now only move one segment of a maximum of three segments in a relationship line. I believe the ability to have more than three line segments and to manipulate all of the segments in the x or y direction would address my issues.
[30 Jan 2008 18:09] Valeriy Kravchuk
Thank you for a reasonable feature request.
[24 Sep 2008 8:44] Danny Angus
I'd like to add my support for this request, I know its not going to be easy for you but I would like to see more control over the display of relationships.
On key benefit of diagramming is that it is a tool for explaining complex schema, it is frustrating to have to spend a long time fiddling with layout in order to make relationships clear.
This isn't so much of a problem when you are using the tool, but as soon as you export a diagram or print it you loose the interactivity so you need to fine tune the layout first.
[12 Nov 2008 13:23] Will Sheppard
I agree this would be a fantastically useful feature. Half of the reason one uses a tool like this is to display the data visually, therefore more flexibility should exist when editing the display. Have a look at the basic arrow connector feature in Omnigraffle Pro 3 - that implements the idea perfectly.

I also agree that the foreign keys for each relationship should be highlighted, perhaps circled with ellipses so that in an exported static image, it can clearly be seen which columns are connected to which others.
[31 Mar 2009 12:50] Susanne Ebrecht
Bug #34514 is set as duplicate of this bug here.
[3 Aug 2009 23:54] Alfredo Kojima
Bugs #44881 and #35403 marked as duplicates
[4 Aug 2009 0:01] Alfredo Kojima
#43446 marked as duplicate
[1 Feb 2018 10:43] Mike Lischke
Posted by developer:
 
We have no plans to enhance modeling in the foreseeable future, but thanks for the suggestion.