MySQL Forums
Forum List  »  Newbie

Why Aren’t My Foreign Keys Updating in MySQL Workbench After Forward Engineering an ER Diagram?
Posted by: William Martinez
Date: September 26, 2024 01:19AM

In MySQL Workbench, should forward engineering an ER diagram's foreign keys update the foreign keys in the schema?

I created an ER diagram using the foreign keys GUI (shown here) and then performed forward engineering using the default settings. However, after forward engineering, my schema’s tables did not have the foreign keys I assigned in the ER diagram. Is this expected behavior? You can see the result here.

If this is normal, how do I ensure the foreign keys I defined in the ER diagram are correctly applied to the schema tables?

Here’s what I’ve tried so far:

Created tables without relationships.
Reverse-engineered the database and added foreign key relationships.
Forward engineered the database multiple times, but foreign keys were not added to the tables in the schema.
Is there something I'm missing in this process?

Options: ReplyQuote


Subject
Written By
Posted
Why Aren’t My Foreign Keys Updating in MySQL Workbench After Forward Engineering an ER Diagram?
September 26, 2024 01:19AM


Sorry, only registered users may post in this forum.

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.