OMOP Common Data Model (CDM) Relationship

Relationship
Beskrivning

Relationship

Alias
UMLS CUI-1
C0439849
UMLS CUI-2
C2708733
UMLS CUI-3
C1955348
Relationship ID
Beskrivning

The type of relationship captured by the relationship record.

Datatyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C1300638
Relationship name
Beskrivning

The text that describes the relationship type.

Datatyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C0027365
is the relationship hierarchical
Beskrivning

Defines whether a relationship defines concepts into classes or hierarchies. Values are 1 for hierarchical relationship or 0 if not.

Datatyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C0699032
defines ancestry
Beskrivning

Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are 1 or 0.

Datatyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C0870134
Reverse relationship ID
Beskrivning

The identifier for the relationship used to define the reverse relationship between two concepts.

Datatyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C1555029
UMLS CUI [1,3]
C1300638
Relationship concept ID
Beskrivning

A foreign key that refers to a standard concept identifier in the Standardized Vocabularies for the relationship concept.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638

Similar models

OMOP Common Data Model (CDM) Relationship

Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
Alias
Item Group
Relationship
C0439849 (UMLS CUI-1)
C2708733 (UMLS CUI-2)
C1955348 (UMLS CUI-3)
Relationship ID
Item
Relationship ID
text
C0439849 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Relationship name
Item
Relationship name
text
C0439849 (UMLS CUI [1,1])
C0027365 (UMLS CUI [1,2])
is hierarchical
Item
is the relationship hierarchical
text
C0439849 (UMLS CUI [1,1])
C0699032 (UMLS CUI [1,2])
defines ancestry
Item
defines ancestry
text
C0439849 (UMLS CUI [1,1])
C0870134 (UMLS CUI [1,2])
Reverse relationship ID
Item
Reverse relationship ID
text
C0439849 (UMLS CUI [1,1])
C1555029 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Relationship concept ID
Item
Relationship concept ID
integer
C0439849 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])