Solved

mysql workbench reverse engr diagram - line connection point to table

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

18 Experts available now in Live!

Get 1:1 Help Now