Re: In MySQL Workbench, should forward engineering an ER Diagram's foreign keys update the foreign keys in the schema?
Posted by:
Lena Oan
Date: December 15, 2022 07:09AM
I have a database with 6 tables, this site
https://pokieslab.net/aristocrat/ - it's online game web site. I tried to view the relationships between the tables by using EER diagram. I observed that all the one-to-one relationships were converted into one-to-many relationships. To be double sure, I started with a new EER diagram, made all the tables and assigned the relationships. Then I forward engineered the model and got the SQL script for the model. The code of this script is shared below. Now again starting from a new model, I went to file->import->reverse engineer create script and checked the option saying 'place imported objects on diagram'. To my great surprise, these two EER diagrams were not the same. The only change being, the one-to-one relationships were replaced by one-to-many relationships. Please tell me if I am wrong at some step, or is it a bug?
Subject
Written By
Posted
December 09, 2022 10:06PM
Re: In MySQL Workbench, should forward engineering an ER Diagram's foreign keys update the foreign keys in the schema?
December 15, 2022 07:09AM
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.