documentation:cdm:cdm:domain
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:cdm:domain [2014/11/14 16:06] cgreich [DOMAIN Table] |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== DOMAIN Table ====== | ||
| - | |||
| - | The DOMAIN table includes a list of the 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 CONDITION_OCCURRENCE and CONDITION_ERA tables. This reference table is populated with a single record for each Domain and includes a descriptive name for the Domain. | ||
| - | |||
| - | ^Field^Required^Type^Description^ | ||
| - | |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_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.| | ||
| - | |||
| - | ==== Conventions ==== | ||
documentation/cdm/cdm/domain.1415981218.txt.gz ยท Last modified: 2014/11/14 16:06 by cgreich
Page Tools
