User Tools

Site Tools


documentation:cdm:cdm:domain

This is an old revision of the document!


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.

FieldRequiredTypeDescription
domain_idYesvarchar(20)A unique key for each domain.
domain_nameYesvarchar(255)The name describing the Domain, e.g. “Condition”, “Procedure”, “Measurement” etc.
domain_concept_idYesintegerA 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.1415981269.txt.gz · Last modified: 2014/11/14 16:07 by cgreich