ID

19475

Description

OMOP Common Data Model (CDM) Relationship The RELATIONSHIP table provides a reference list of all allowable types of relationships that can be used to associate any two concepts in the concept relationship table. Relationships are classified as hierarchical (parent-child) or non-hierarchical, and are used to determine which concept relationship records should be included in the computation of the concept ancestor table. OMOP Common Data Model Specifications Version 5.0 The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense.

Link

http://omop.fnih.org/publiclicense

Keywords

Versions (3)
  1. 1/4/17 1/4/17 -
  2. 2/26/19 2/26/19 -
  3. 2/26/19 2/26/19 -
Uploaded on

January 4, 2017

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0
Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Back to model comments
Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

OMOP Common Data Model (CDM) Relationship

English

OMOP Common Data Model (CDM) Relationship

1 forms  
Relationship
Description

Relationship

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

The type of relationship captured by the relationship record.

Data type

text

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

The text that describes the relationship type.

Data type

text

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

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

Data type

text

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

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

Data type

text

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

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

Data type

text

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

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

Data type

integer

Alias
UMLS CUI [1,1]
C0439849
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Back to the top of the page

Similar models

OMOP Common Data Model (CDM) Relationship

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
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])
Back to the top of the page 

Contact

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial