MySQL Forums
Forum List  »  MySQL Workbench

Re: forward engineering
Posted by: Mike Lischke
Date: November 14, 2014 02:03AM

Ken, for 1:1 and 1:n relationships you don't need a separate table. You can model that directly with the 2 related tables. Only for n:m is an intermediate table necessary (which MySQL Workbench automatically creates for you).

But regardless of the relationship cardinalities, the forward engineering process just handles the entities as they are in the model. It doesn't generate additionaly tables or other objects. There's a direct and 1:1 mapping between the objects in your model (e.g. tables and relationships) and your server (tables + 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
1430
November 12, 2014 05:52PM
819
November 13, 2014 02:00AM
874
November 13, 2014 07:24AM
Re: forward engineering
718
November 14, 2014 02:03AM


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.