search

OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
896 stars 451 forks source link

Duplicated constraints on the concept_synonym table #360

Closed xj2193 closed 3 years ago

xj2193 commented 4 years ago

These two constraint names are the same:

ALTER TABLE concept_synonym ADD CONSTRAINT fpk_concept_synonym_concept FOREIGN KEY (concept_id)  REFERENCES concept (concept_id);

ALTER TABLE concept_synonym ADD CONSTRAINT fpk_concept_synonym_concept FOREIGN KEY (language_concept_id)  REFERENCES concept (concept_id);
clairblacketer commented 3 years ago

Thanks! I fixed this in the repository I use to develop the CDM https://github.com/OHDSI/CdmDdlBase/blob/master/output/sql%20server/OMOP%20CDM%20sql%20server%20v5_3_1%20constraints.sql#L289