Entity Relationship Diagrams only support single relationships to a primary key.

[Mills-2]

Bug Description

If you add explicit mappings from a primary key to multiple tables the Entity Relationship Diagram will only show one of the relationships.

Repro steps

Create a DB with 3 tables.

product, product_bundles, product_reviews

product has columns id and itemid, product_bundles has id and hero_itemid and then product_reviews has id, rating, review_text, itemid.

If you draw explicit mapping between product.itemid -> product_bundles.hero_itemid, product.itemid -> product_reviews.itemid then it will only show one of the relationships in the diagram.

Expected Behavior

Multiple relationships should be able to be drawn between a primary key and that should show on the ERD.

Actual Behavior

Only one relationship is shown.

Environment

Version: 3.2.21 (Universal)
VSCode Version: 1.105.1
Commit: 806df57ed3b6f1ee0175140d38039a38574ec720
Date: 2026-05-03T01:46:14.413Z
Layout: editor
Build Type: Stable
Release Track: Default
Electron: 39.8.1
Chromium: 142.0.7444.265
Node.js: 22.22.1
V8: 14.2.231.22-electron.0
OS: Darwin arm64 25.4.0

• DBCode version: 1.31.1
• VS Code (or fork) version: 1.105.1 (using Cursor)
• OS: MacOS
• Database: Postgres
• Connection: (direct/SSH/SSL): SSH

Error Mesages (if applicable)

No Error associated

Screenshots

If applicable, add screenshots to help explain your problem.

Logs

If available, paste relevant logs from the Output panel (View > Output > DBCode).

[Mills-2]

After some more time playing with this. I discovered that I was setting the relationship directionality wrong in the explicit mappings. However I also noticed that once a relationship has been drawn, it appears it cannot be undrawn.

[mikeburgh]

I just released 1.31.2 which should fix the issue with not rendering the same column to multiples.

On the "cannot be undrawn" part, I tried to reproduce it and the X icon at the end of each mapping row in the Explicit Mappings section removes the relationship for me, both in the live preview and after saving. Can you confirm whether that's where you were trying to remove it, or were you trying to remove a line directly from the diagram itself?

[Mills-2]

I've removed all mappings in both the Explicit Mappings and custom patterns. I can see that reflected in the Detected Relationships but the ERD is still drawing relationships between items. My theory at the moment is that these entities its drawing relationships for are the ones that I tried to relate the same column to multiples of.