OHDSI / CommonDataModel

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

Foreign key `fpk_concept_synonym_concept` is used multiple times #305

Closed mseal-cherokeehealth closed 3 years ago

mseal-cherokeehealth commented 4 years ago

In OMOP CDM sql server constraints.txt the foreign key fpk_concept_synonym_concept is used multiple times. ` 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); ` One, or both, of these foreign keys should be renamed. This breaks inserting foreign keys onto the standardized vocabulary.

clairblacketer commented 4 years ago

Thank you! This will go in the milestones for the next release