pgadmin-org / pgadmin-org/pgadmin4
ERD tool: Allow/show foreign keys linking to a another schema
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
From the Manual:
The ERD for schema will fetch all the tables from a schema and plot them with foreign key links. If any table refers to
a table in another schema, then that link/foreign key will be removed.
It would be very useful if the ERD tool would allow creation and display of links to tables in another schema. Perhaps by drawing it as e.g. a diamond with a number in it + a list with a reference to the tables in other schemas? This is similar to how it is done in some larger electrical diagrams. You could also display the name of the other table when hovering the mouse over the referece (diamond) symbol.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the ERD tool behavior described in the linked manual section and determine how schema-scoped tables and foreign-key links are currently handled. Define how links to tables in other schemas should be represented, including the proposed reference marker and hover information. Done means cross-schema foreign keys can be displayed and created without being removed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100