CODEWITHSUNDEEP
mysql-workbench
Slevin
Slevin

Reputation: 4232

How to draw relationship-lines between columns?

Are there any options in MySQL Workbench to draw the relationship-line between the columns and not the tables? If i export my diagram as JPG i can't see, which columns are foreign keys and who they are related to.

On the screenshot, you can't see, that id and user_id are connected.

enter image description here

Upvotes: 17

Views: 12381

Answers (2)

Terje Nesthus
Terje Nesthus

Reputation: 820

In the main menu bar go to: Model -> Relationship Notation -> Connect to columns.

Upvotes: 28

Thiha Maung
Thiha Maung

Reputation: 171

I'm not sure MySQL Workbench can draw relationship lines between columns but you can aware that Primary Key is shown as Key Symbol and Foreign Key is shown as Red Diamond Symbol.

Upvotes: 5

Related Questions