Beskrivning

The type of relationship captured by the relationship record. The RELATIONSHIP_ID field contains an alphanumerical identifier, that can also be used as the abbreviation of the Relationship. (Type varchar(20))

Datatyp

text

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C1300638

Beskrivning

The text that describes the relationship type. The RELATIONSHIP_NAME field contains the unabbreviated names of the Relationship. (Type varchar(255))

Datatyp

text

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C0027365

Beskrivning

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

Datatyp

integer

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C0699032

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. (Type varchar(1))

Datatyp

text

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C0870134

Beskrivning

The identifier for the relationship used to define the reverse relationship between two concepts. Relationships all exist symmetrically, i.e. in both direction. The RELATIONSHIP_ID of the opposite Relationship is provided in the REVERSE_RELATIONSHIP_ID field. (Type varchar(20))

Datatyp

text

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C1555029

UMLS CUI [1,3]

C1300638

Beskrivning

A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept. Each Relationship also has an equivalent entry in the Concept table, which is recorded in the RELATIONSHIP_CONCEPT_ID field. This is for purposes of creating a closed Information Model, where all entities in the OMOP CDM are covered by unique Concepts.

Datatyp

integer

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638