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.54k stars 659 forks source link

Relationship lines in ERDs are difficult to follow (RM #7198) #4915

Open dpage opened 2 years ago

dpage commented 2 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7198 Originally created by David P-C at 2022-02-22 20:33:17 UTC.

The diagrams generated by the ERD Tool in pgAdmin are often confusing because the relationship lines always extend from the right side of tables, and often pass behind other tables. The diagrams could be greatly improved by allowing lines to extend from either side of a table and routing lines around other objects rather than behind them. See the attached image for an example of a diagram with hard to follow lines. Look at DbVisualizer or other applications that generate ERDs to see examples of better handling of relationship lines.

dpage commented 2 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6642 Originally created by David P-C at 2022-02-22 20:30:23 UTC.

erd.png

Filename: erd.png

Description: Confusing ERD

dpage commented 2 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7198#note-2 Originally created by Pradip Parkale at 2022-03-04 11:12:30 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready