Entity Relationship diagram to highlight foreign/primary key pair


I wonder if it is possible to configure ‘Entity Relationship’ diagram to highlight foreign/primary key pair while hovering over the association between two tables. This could work similarly as in MySQL Wworkbench as shown on the screenshot below

where both film.film_id and film_actor.film_id are clearly marked.

At the moment only association changes colour without indicating foreign/primary key pair. It can be an issue if the ER diagram is complex. Any solution to that problem?

Kind regards
Daniel Stefaniuk

Hi Daniel,

Thank you for your post and sorry for my late reply.

Thank you for your suggestion. We do not support highlighting columns when selecting relationship but the following function may be of helpful to you:

  1. Right click on the background of ERD
  2. Select Presentation Options > Foreign Key Display Options > Point Foreign Key End to Associated Column.

With this the end of relationships will point directly to the columns. You can easily know the columns related.

Best regards,
Jick Yeung