SchemaSpy - Table postgres.omop.domain

[VOCABULARY] 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](https://github.com/OHDSI/CommonDataModel/wiki/CONDITION_OCCURRENCE) and [CONDITION_ERA](https://github.com/OHDSI/CommonDataModel/wiki/CONDITION_ERA) tables. This reference table is populated with a single record for each Domain and includes a descriptive name for the Domain.

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

domain_id

varchar

concept.domain_id

fpk_concept_domain R

A unique key for each domain.

domain_name

varchar

255

The name describing the Domain, e.g. "Condition", "Procedure", "Measurement" etc.

domain_concept_id

int4

concept.concept_id

fpk_domain_concept R

A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Domain Concept the Domain record belongs to.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
domain_id	Primary key	Asc	xpk_domain
domain_id	Must be unique	Asc	idx_domain_domain_id