ERD Tool - How can I document a 1:1 relationship? (RM #7454)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7454
Originally created by Christina Baker at 2022-06-07 22:37:21 UTC.

The ERD tool has a 1M and MM button, but there does not seem to be way to document a one-to-one relationship. Is there a way to document this?

Thank you,
Christina

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7454#note-1
Originally created by Aditya Toshniwal at 2022-06-13 04:15:56 UTC.

Hi Christina,

Do you mean adding notes/comments to relationships ?
You can try adding comments to the foreign key.

Thanks.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Christina Baker

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7454#note-2
Originally created by Nikhil Mohite at 2022-06-24 11:47:58 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed	Christina Baker	Aditya Toshniwal

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7454#note-3
Originally created by Nikhil Mohite at 2022-06-24 11:48:07 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[pedroska777]

Is there any development to show 1-1 relationship in ERD? (I mean 1-1 visualization in ERD) . I know that 1-1 is a subset of 1-M relationship with applying Unique to the FK, but it is not reflected in the diagram.