db-schema-visualizer icon indicating copy to clipboard operation
db-schema-visualizer copied to clipboard

Highlight composite foreign keys

Open Gaia-Florian opened this issue 2 months ago • 0 comments

Hi,

Your extension is awesone !

I have a request regarding highlight keys. Would it be possible to highlight composite foreign keys?

In my case, I have a constraint between 'TARIF' and 'HISTORIQUE_TARIF' on two fields: ARTICLE_ID and FOURNISSEUR_ID.

// DBML TABLE ARTICLE { ID INTEGER REFERENCE VARCHAR(20) DESIGNATION VARCHAR(64) indexes { (ID) [pk] } } TABLE FOURNISSEUR { ID INTEGER NOM VARCHAR(50) ADRESSE VARCHAR(128) indexes { (ID) [pk] } } TABLE TARIF { ARTICLE_ID INTEGER FOURNISSEUR_ID INTEGER DATE_DEBUT DATE DATE_FIN DATE TARIF_HT DECIMAL(15,4) TARIF_TTC DECIMAL(15,4) indexes { (ARTICLE_ID,FOURNISSEUR_ID) [pk] } } Ref: TARIF.(ARTICLE_ID) > ARTICLE.(ID) Ref: TARIF.(FOURNISSEUR_ID) > FOURNISSEUR.(ID) TABLE TARIF_HISTORIQUE { ID INTEGER DATETIME_HISTORIQUE CHAR(1) ARTICLE_ID INTEGER FOURNISSEUR_ID INTEGER TARIF_HT DECIMAL(15,4) TARIF_TTC DECIMAL(15,4) indexes { (ID) [pk] } } Ref: TARIF_HISTORIQUE.(ARTICLE_ID,FOURNISSEUR_ID) > TARIF.(ARTICLE_ID,FOURNISSEUR_ID)

In the screenshot below, on the TARIF_HISTORIQUE table, only ARTICLE_ID is highlighted.

Image

Gaia-Florian avatar Sep 15 '25 08:09 Gaia-Florian