Concept Synonym
The CONCEPT_SYNONYM table is used to store alternate names and descriptions for Concepts.
| Field | Required | Type | FK Table | Description |
|---|---|---|---|---|
| concept_id | Yes | bigint | CONCEPT | A foreign key to the target Concept. |
| concept_synonym_name | Yes | varchar(1000) | The alternative name for the Concept. | |
| language_concept_id | Yes | bigint | CONCEPT | A foreign key to a Concept representing the language. |
Conventions
- The
concept_synonym_namefield contains a valid Synonym of a Concept, including the description in theconcept_nameitself. I.e. each Concept has at least one Synonym in the CONCEPT_SYNONYM table. As an example, for a SNOMED-CT Concept, if the fully specified name is stored as theconcept_nameof the CONCEPT table, then the Preferred Term and Synonyms associated with the Concept are stored in the CONCEPT_SYNONYM table. - Only Synonyms that are active and current are stored in the CONCEPT_SYNONYM table. Tracking synonym/description history and mapping of obsolete synonyms to current Concepts/Synonyms is out of scope for the Standard Vocabularies.
- Currently, only English Synonyms are included.