MySQL Forums
Forum List  »  MySQL Workbench

Re: Simple entity relationship and foreign key question
Posted by: David McMurray
Date: July 06, 2009 05:16PM

What an idiot I am! The "games.map_id" column was defined as INT(10) and the "maps.map_id" column was just defined as INT!

I've changed the latter to INT(10) and I can now tick the right column and placing the mouse over the relationship now highlights the map_id columns in both tables as I would expect it to.

Although I did get an error when unticking the auto-created foreign key column which said "Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. External component has thrown an exception." This also then occurs when ticking the column I do want to use as the foreign key.

Options: ReplyQuote

Written By
Re: Simple entity relationship and foreign key question
July 06, 2009 05:16PM

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.