ID

35284

Beschreibung

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. There is one record for each Relationship. 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. Relationships, also hierarchical, can be between Concepts within the same Vocabulary or those adopted from different Vocabulary sources. OMOP Common Data Model Specifications Version 6.0 Specifications 11Ocotober2018 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. Version updated on 26.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/RELATIONSHIP

Link

http://omop.fnih.org/publiclicense

Stichworte

Versionen (3)
  1. 04.01.17 04.01.17 -
  2. 26.02.19 26.02.19 -
  3. 26.02.19 26.02.19 -
Rechteinhaber

Observational Medical Outcomes Partnership (OMOP)

Hochgeladen am

26. Februar 2019

DOI

Für eine Beantragung loggen Sie sich ein.

Lizenz

Creative Commons BY-NC 3.0
Modell Kommentare :

Hier können Sie das Modell kommentieren. Über die Sprechblasen an den Itemgruppen und Items können Sie diese spezifisch kommentieren.

Zurück zu Modell Kommentaren
Itemgroup Kommentare für :

Item Kommentare für :

Um Formulare herunterzuladen müssen Sie angemeldet sein. Bitte loggen Sie sich ein oder registrieren Sie sich kostenlos.

OMOP Common Data Model (CDM) Relationship

Englisch

OMOP Common Data Model (CDM) Relationship

1 Formulare  
Relationship
Beschreibung

Relationship

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

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

Datentyp

text

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

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

Datentyp

text

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

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

Datentyp

integer

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

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

Datentyp

text

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

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

Datentyp

text

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

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.

Datentyp

integer

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

Ähnliche Modelle

OMOP Common Data Model (CDM) Relationship

1 Formulare
Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
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])
Item
is the relationship hierarchical
integer
C0439849 (UMLS CUI [1,1])
C0699032 (UMLS CUI [1,2])
is hierarchical
Code List
is the relationship hierarchical
CL Item
hierarchial relationship (1)
CL Item
no hierarchial relationship (3)
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])
Zum Seitenanfang zurückkehren 

Kontakt

Benutzen Sie dieses Formular für Rückmeldungen, Fragen und Verbesserungsvorschläge.

Mit * gekennzeichnete Felder sind notwendig.

Hilfe

Benötigen Sie Hilfe bei der Suche? Um mehr Details zu erfahren und die Suche effektiver nutzen zu können schauen Sie sich doch das entsprechende Video auf unserer Tutorial Seite an.

Zum Video