I have downloaded the vocabulary files a few times in the past couple weeks. Each time, there has been a duplicate record on the concept_synonym table that prevents me from adding the unique constraint as defined in the DDL:
ALTER TABLE cdm.concept_synonym ADD CONSTRAINT uq_concept_synonym UNIQUE (concept_id, concept_synonym_name, language_concept_id);
The offending records are:
I’m relatively new to the OMOP data model (just starting to code some ETL using Epic-Caboodle as a source). Am I missing something, or is this an error?