Skip to content

Highlight composite foreign keys #89

@Gaia-Florian

Description

@Gaia-Florian

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions