Englisch

OMOP Common Data Model (CDM) Concept Relationship

1 Formulare  
Concept Relationship
Beschreibung

Concept Relationship

Alias
UMLS CUI-1
C0178566
UMLS CUI-2
C0439849
Concept ID 1
Beschreibung

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.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Concept ID 2
Beschreibung

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.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C1300638
Relationship ID
Beschreibung

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))

Datentyp

text

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C1300638
valid start date
Beschreibung

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

Datentyp

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0808070
valid end date
Beschreibung

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.

Datentyp

date

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C0806020
invalid reason
Beschreibung

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))

Datentyp

text

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0566251
Zum Seitenanfang zurückkehren

Ähnliche Modelle

OMOP Common Data Model (CDM) Concept Relationship

1 Formulare
Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
Alias
Item Group
Concept Relationship
C0178566 (UMLS CUI-1)
C0439849 (UMLS CUI-2)
Concept ID 1
Item
Concept ID 1
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Concept ID 2
Item
Concept ID 2
integer
C0178566 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Relationship ID
Item
Relationship ID
text
C0439849 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
valid start date
Item
valid start date
date
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C0808070 (UMLS CUI [1,3])
valid end date
Item
valid end date
date
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C0806020 (UMLS CUI [1,3])
invalid reason
Item
invalid reason
text
C0178566 (UMLS CUI [1,1])
C0439849 (UMLS CUI [1,2])
C3245471 (UMLS CUI [1,3])
C0566251 (UMLS CUI [1,4])
Zum Seitenanfang zurückkehren