search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.41k stars 632 forks source link

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

Open dpage opened 2 years ago

dpage commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 1 year ago

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.