• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

mysql workbench reverse engr diagram - line connection point to table

How can i make the foreign key dependency line to intersect the table aligned with that key's reference?

tblProducts                         tblColors
Prod.ID                                Color.ID
...
...              >-------------------o
...
...
ColorID

Workbench places it at an arbitrary point, unrelated to where "ColorID" is displayed.

 i'd like the line to align with ColorID
 instead of a graphically arbitrary point in the edge of the table tblProducts

is there an option somewhere to accomplish this?
Are there other tools that do this better?
I used to use  FlashMyPhpAdmin, but it no longer works with versions 5 of PHP/MySQL

thanks
0
willsherwood
Asked:
willsherwood
  • 3
1 Solution
 
Loganathan NatarajanLAMP DeveloperCommented:
I use this software to do the ER diagram way. http://www.fabforce.net/dbdesigner4/screenshots.php
0
 
willsherwoodAuthor Commented:
i'm confused?  DBdesigner was replaced by workbench, and is no longer supported (the forums seem even to have been deleted)
are you saying that this older tool provides better schema diagrams?
0
 
FishMongerCommented:
While viewing the EER diagram:

Click on the Model menu tab.
Select Relationship Notation -> Connect to Columns
0
 
willsherwoodAuthor Commented:
oh oh oh    this is it!
thank you!
so this is a major improvement.

i'm assuming from looking around on the web again recently, that there's still no
replacement tool that has drag and drop (from foreign key to primary target table)
in the graphical layout display of the schema to make all this simple?

phpFlashMyAdmin stopped working with PHP5.  i'm looking for a host that still offers PHP4
in order to get an account, this tool is such a time saver for db with large # of tables
0
 
willsherwoodAuthor Commented:
thanks!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now