SchemaSpy - Table postgres.omop.concept

[VOCABULARY] The CONCEPT_RELATIONSHIP table contains records that define direct relationships between any two Concepts and the nature or type of the relationship. Each type of a relationship is defined in the [RELATIONSHIP](https://github.com/OHDSI/CommonDataModel/wiki/RELATIONSHIP) table.

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

concept_id_1

int4

concept.concept_id

fpk_concept_relationship_c_1 R

A foreign key to a Concept in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table associated with the relationship. Relationships are directional, and this field represents the source concept designation.

concept_id_2

int4

concept.concept_id

fpk_concept_relationship_c_2 R

relationship_id

varchar

relationship.relationship_id

fpk_concept_relationship_id R

A unique identifier to the type or nature of the Relationship as defined in the [RELATIONSHIP](https://github.com/OHDSI/CommonDataModel/wiki/RELATIONSHIP) table.

valid_start_date

date

The date when the instance of the Concept Relationship is first recorded.

valid_end_date

date

The date when the Concept Relationship became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.

invalid_reason

varchar

√

null

Reason the relationship was invalidated. Possible values are 'D'(deleted), 'U'(replaced with an update) or NULL when valid_end_date has the default value.

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

Indexes:

Column(s)	Type	Sort	Constraint Name
concept_id_1 + concept_id_2 + relationship_id	Primary key	Asc/Asc/Asc	xpk_concept_relationship
concept_id_1	Performance	Asc	idx_concept_relationship_id_1
concept_id_2	Performance	Asc	idx_concept_relationship_id_2
relationship_id	Performance	Asc	idx_concept_relationship_id_3