CODEWITHSUNDEEP
mysqlmysql-workbenchdiagram
Fan
Fan

Reputation: 1180

How to make one to one relationship EER diagram in MySql Workbench 6.3E

As the title said , how can i make the relationship in following image (connect to column)? enter image description here

Upvotes: 3

Views: 5027

Answers (2)

Bhaumik Thakkar
Bhaumik Thakkar

Reputation: 580

Note: If you don't have primary key in your table it won't work as expected.

Upvotes: 0

Mike Lischke
Mike Lischke

Reputation: 53532

In the vertical toolbar you can see different connection (relation) tools. The last one with the picker symbol lets you select individual columns for a relationship. You can edit the cardinality and other properties at any time in the relationship editor (double click the relationship to open it). By editing the referencing table you can also edit the participating columns (via the created foreign key constraint.

Upvotes: 5

Related Questions