OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - concept_relationship link

Properties
Name Value
Description

 

CONCEPT_RELATIONSHIP

Table Description

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

CDM Field User Guide ETL Conventions Datatype Required Primary Key Foreign Key FK Table FK Domain
concept_id_1 integer Yes No Yes CONCEPT
concept_id_2 integer Yes No Yes CONCEPT
relationship_id The relationship between CONCEPT_ID_1 and CONCEPT_ID_2. Please see the Vocabulary Conventions. for more information. varchar(20) Yes No Yes RELATIONSHIP
valid_start_date The date when the relationship is first recorded. date Yes No No
valid_end_date The date when the relationship is invalidated. date Yes No No
invalid_reason Reason the relationship was invalidated. Possible values are ‘D’ (deleted), ‘U’ (updated) or NULL. varchar(1) No No No

Data Model Physical
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
concept_id_1 int4 PK / FK No
concept_id_2 int4 PK / FK No
relationship_id varchar(20) PK / FK No
valid_start_date date No
valid_end_date date No
invalid_reason varchar(1) Yes

Relationships Summary
Name Begin End
 fpk_concept_relationship_concept_id_1 : Relationship
 concept : Entity
 concept_relationship : Entity
 fpk_concept_relationship_concept_id_2 : Relationship
 concept : Entity
 concept_relationship : Entity
 fpk_concept_relationship_relationship_id : Relationship
 relationship : Entity
 concept_relationship : Entity

Columns Detail
Name Value
Name concept_id_1
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

Name Value
Name concept_id_2
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

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

Name Value
Name valid_start_date
Type date
Nullable false
Unique false
Primary Key false
Index false
Type Name date
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name valid_end_date
Type date
Nullable false
Unique false
Primary Key false
Index false
Type Name date
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Relationships Detail
Name Value
Name fpk_concept_relationship_concept_id_1
Foreign Key
concept_relationship
 concept_id_1 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_relationship_concept_id_2
Foreign Key
concept_relationship
 concept_id_2 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_relationship_relationship_id
Foreign Key
concept_relationship
 relationship_id : Column
Primary Key
relationship
 relationship_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Appears In
Diagram
 Vocabulary_With_Standard : Entity Relationship Diagram
 Vocabulary_Tables : Entity Relationship Diagram
OMOP_5.4_ER_ALL