Re: How to Reverse Engineer Relationships?

[Mike Lischke]

Hi,

indeed, the generated model will show you the relationships in the script/schema. However, WB currently works only with a physical model, which maps features of the MySQL server 1:1 (except for some additional functionality like user data types etc.). This means, though, that only for InnoDB tables you will get the relationships shown, as InnoDB is the only engine with foreign keys currently.

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/