Description

DOMAIN

Table Description

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 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.

CDM Field	User Guide	Datatype	Required	Primary Key	Foreign Key	FK Table
domain_id	A unique key for each domain.	varchar(20)	Yes	Yes	No
domain_name	The name describing the Domain, e.g. Condition, Procedure, Measurement etc.	varchar(255)	Yes	No	No
domain_concept_id	A Concept representing the Domain Concept the DOMAIN record belongs to.	integer	Yes	No	Yes	CONCEPT

Primary Key Constraint Name

xpk_domain

Unlogged

false



Name	Begin	End

fpk_concept_domain_id : Relationship	domain : Entity	concept : Entity
fpk_cost_cost_domain_id : Relationship	domain : Entity	cost : Entity
fpk_domain_domain_concept_id : Relationship	concept : Entity	domain : Entity



	Name		Value

	Name		domain_id
	Type		varchar
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Type Name		varchar
	Length		20
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		domain_concept_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



Column Name	Data Type	PK / FK	Nullable	Description

domain_id	varchar(20)	PK	No
domain_concept_id	int4	PK / FK	No
domain_name	varchar(255)		No



	Diagram

	Vocabulary_With_Standard : Entity Relationship Diagram
	Vocabulary_Tables : Entity Relationship Diagram