Beskrivning

A foreign key to the concept in the concept table associated with the relationship. Relationships are directional, and this field represents the source concept designation.

Datatyp

integer

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C1300638

Beskrivning

A foreign key to a Concept in the CONCEPT table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.

Datatyp

integer

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C1300638

Beskrivning

A unique identifier to the type or nature of the Relationship as defined in the RELATIONSHIP table. There is one record for each Concept Relationship connecting the same Concepts with the same RELATIONSHIP_ID. (Type varchar(20))

Datatyp

text

Alias

UMLS CUI [1,1]

C0439849

UMLS CUI [1,2]

C1300638

Beskrivning

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

Datatyp

date

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0439849

UMLS CUI [1,3]

C0808070

Beskrivning

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.

Datatyp

date

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0439849

UMLS CUI [1,3]

C0806020

Beskrivning

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

Datatyp

text

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0439849

UMLS CUI [1,3]

C3245471

UMLS CUI [1,4]

C0566251