IMPOSSIBLE TO CREATE MySQL 1:1 RELATION

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

IMPOSSIBLE TO CREATE MySQL 1:1 RELATION

Author

Topic

Giacomo1983
Starting Member

5 Posts

Posted - 2012-03-08 : 16:32:14

Hi all,

I use MySqlWorkbench on MySql 5.1. I'm using the EER schema design tool and I need to create a 1:1 relationship between two table. With that tool I mangage to do that but when I do "forward engineer SQL create script" and run the script the relation become many to one!! I realize that because if I do "create EER model from existing DB" and I chose the DB I have created, the two table has a many to one relation!

I use InnoDB engine.. I try many time to create a diagram with only two table connected with 1:1 relation and than create and run the script but that relation change automatically!

Can you help me??

thanks a lot

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-08 : 16:35:44

SQLTeam.com is for Microsoft SQL Server. You should consider posting your question on a MySql site as you may not get an answer here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog