OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - relationship link

Properties
Name Value
Description

RELATIONSHIP

Table Description

The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two concepts in the CONCEPT_RELATIONSHP table.

CDM Field User Guide ETL Conventions Datatype Required Primary Key Foreign Key FK Table FK Domain
relationship_id The type of relationship captured by the relationship record. varchar(20) Yes Yes No
relationship_name varchar(255) Yes No No
is_hierarchical Defines whether a relationship defines concepts into classes or hierarchies. Values are 1 for hierarchical relationship or 0 if not. varchar(1) Yes No No
defines_ancestry Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are 1 or 0. varchar(1) Yes No No
reverse_relationship_id The identifier for the relationship used to define the reverse relationship between two concepts. varchar(20) Yes No No
relationship_concept_id A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept. integer Yes No Yes CONCEPT

Data Model Physical
Primary Key Constraint Name xpk_relationship
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
relationship_id varchar(20) PK No
relationship_name varchar(255) No
is_hierarchical varchar(1) No
defines_ancestry varchar(1) No
reverse_relationship_id varchar(20) No
relationship_concept_id int4 PK / FK No

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

Columns Detail
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 false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name is_hierarchical
Type varchar
Nullable false
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

Name Value
Name defines_ancestry
Type varchar
Nullable false
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

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

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

Relationships Detail
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

Name Value
Name fpk_relationship_relationship_concept_id
Foreign Key
relationship
 relationship_concept_id : Column
Primary Key
concept
 concept_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