Solved

mysql workbench reverse engr diagram - line connection point to table

Posted on 2014-02-16
5
375 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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