MySQL Forums
Forum List  »  MySQL Workbench

Re: How can I set relationship with two table comuns that are different names
Posted by: Mike Lischke
Date: August 09, 2013 02:24AM

Antony,

the actual names of the columns don't matter for FK creation. Open your Address table in the model and switch to the "Foreign Keys" page. Click in the left list on the empty line to create a new FK. Select the referenced (target) table there (which would be Persion in your case). Make sure your FK is selected once this is done.

Then on the right hand side you have a list of colums from your Address table along with checkboxes. Check the one in front of personid and select the target column in that entry (via that drop down control). If needed adjust other parameters.

That's it.

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: How can I set relationship with two table comuns that are different names
485
August 09, 2013 02:24AM


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.