MySQL Forums
Forum List  »  MySQL Workbench

Re: Foreign Key Relationship creates new column using EER Diagram and INNODB
Posted by: Mike Lischke
Date: April 14, 2015 01:01AM

Jay,

the generated column has nothing to do with the table engine. It's simply the way WB normally creates a releationship. However, the last tool (the one with the picker symbol, 1:n) allows to select existing columns instead. Use this to create your relationships and if you need different cardinalities or other changes double click on the new relationship to open its editor where you can change that.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Foreign Key Relationship creates new column using EER Diagram and INNODB
756
April 14, 2015 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.