This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:domain [2014/12/13 18:46] cgreich |
documentation:cdm:domain [2017/09/25 14:57] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== DOMAIN table ====== | ===== DOMAIN table ====== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
The DOMAIN table includes a list of OMOP-defined Domains the Concepts of the Standardized Vocabularies can belong to. A Domain defines the set of allowable Concepts for the standardized fields in the CDM tables. For example, the "Condition" Domain contains Concepts that describe a condition of a patient, and these Concepts can only be stored in the condition_concept_id field of the [[documentation:cdm:condition_occurrence|CONDITION_OCCURRENCE]] and [[documentation:cdm:condition_era|CONDITION_ERA]] tables. This reference table is populated with a single record for each Domain and includes a descriptive name for the Domain. | The DOMAIN table includes a list of OMOP-defined Domains the Concepts of the Standardized Vocabularies can belong to. A Domain defines the set of allowable Concepts for the standardized fields in the CDM tables. For example, the "Condition" Domain contains Concepts that describe a condition of a patient, and these Concepts can only be stored in the condition_concept_id field of the [[documentation:cdm:condition_occurrence|CONDITION_OCCURRENCE]] and [[documentation:cdm:condition_era|CONDITION_ERA]] tables. This reference table is populated with a single record for each Domain and includes a descriptive name for the Domain. | ||
Line 6: | Line 7: | ||
|domain_id|Yes|varchar(20)|A unique key for each domain.| | |domain_id|Yes|varchar(20)|A unique key for each domain.| | ||
|domain_name|Yes|varchar(255)|The name describing the Domain, e.g. "Condition", "Procedure", "Measurement" etc.| | |domain_name|Yes|varchar(255)|The name describing the Domain, e.g. "Condition", "Procedure", "Measurement" etc.| | ||
- | |domain_concept_id|Yes|integer|A foreign key that refers to an identifier in the CONCEPT table for the unique Domain Concept the Domain record belongs to.| | + | |domain_concept_id|Yes|integer|A foreign key that refers to an identifier in the [[documentation:cdm:concept|CONCEPT]] table for the unique Domain Concept the Domain record belongs to.| |
==== Conventions ==== | ==== Conventions ==== |