MySQL Workbench - drawing 1:n relationships on model diagram
Posted on 2015-02-14
In the graphical display of tables and fields,
When i add a 1-to-many relationship, it does draw the line between the two tables,
but (in Connect to Columns mode) it adds a new field instead of using the foreign key already there which i had defined.
How can i connect from a specific EXISTING field (foreign index) (on the "many" end of the arrow) (which my naming convention uses, ColorID) instead of having it add a new field in the table
I'm also open to learn of tools other than WorkBench that can display/manipulate schema graphical diagrams.
I had used FlashMySQLAdmin for years (albeit a few bugs, but workable and great looking results), which had a very nice graphical table interface and relationship editing interface, but alas it is no longer supported (PHP4, etc.). (Someone should take it on and update it and sell it, quite a useful tool)
my example from above....