MySQL Forums
Forum List  »  MySQL Workbench

Re: EER diagram from existing database without relations
Posted by: Mike Lischke
Date: October 28, 2015 02:27AM

Well, it's still that old MyISAM table engine. Change this to InnoDB and add foreign keys. Then MySQL Workbench can create relationships on import.

Alternatively, you can rework your model and change the engines there. Then add relationships manually. On next sync your tables will get foreign keys.

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: EER diagram from existing database without relations
552
October 28, 2015 02:27AM


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.