Solved

mysql workbench reverse engr diagram - line connection point to table

Posted on 2014-02-16
5
373 Views
Last Modified: 2014-02-17
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
Comment
Question by:willsherwood
  • 3
5 Comments
 
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 39863974
I use this software to do the ER diagram way. http://www.fabforce.net/dbdesigner4/screenshots.php
0
 

Author Comment

by:willsherwood
ID: 39864899
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
 
LVL 28

Accepted Solution

by:
FishMonger earned 500 total points
ID: 39865239
While viewing the EER diagram:

Click on the Model menu tab.
Select Relationship Notation -> Connect to Columns
0
 

Author Comment

by:willsherwood
ID: 39865543
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
 

Author Closing Comment

by:willsherwood
ID: 39865547
thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now