ID

35283

Description

OMOP Common Data Model (CDM) Concept Relationship The CONCEPT_RELATIONSHIP table contains records that define direct relationships between any two Concepts and the nature or type of the relationship. Each type of a relationship is defined in the RELATIONSHIP table. Relationships can generally be classified as hierarchical (parent-child) or non-hierarchical (lateral). All Relationships are directional, and each Concept Relationship is represented twice symmetrically within the CONCEPT_RELATIONSHIP table. For example, the two SNOMED concepts of 'Acute myocardial infarction of the anterior wall' and 'Acute myocardial infarction' have two Concept Relationships: 1- 'Acute myocardial infarction of the anterior wall' 'Is a' 'Acute myocardial infarction', and 2- 'Acute myocardial infarction' 'Subsumes' 'Acute myocardial infarction of the anterior wall'. Concept Relationships define direct relationships between Concepts. Indirect relationships through 3rd Concepts are not captured in this table. However, the CONCEPT_ANCESTOR table does this for hierachical relationships over several "generations" of direct relationships. OMOP Common Data Model Version 6.0 Specifications 11October2018 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/CONCEPT_RELATIONSHIP

Lien

http://omop.fnih.org/publiclicense

Mots-clés

Versions (3)
  1. 04/01/2017 04/01/2017 -
  2. 26/02/2019 26/02/2019 -
  3. 26/02/2019 26/02/2019 -
Détendeur de droits

Observational Medical Outcomes Partnership (OMOP)

Téléchargé le

26 février 2019

DOI

Pour une demande vous connecter.

Licence

Creative Commons BY-NC 3.0
Modèle Commentaires :

Ici, vous pouvez faire des commentaires sur le modèle. À partir des bulles de texte, vous pouvez laisser des commentaires spécifiques sur les groupes Item et les Item.

Retour au modèle Commentaires
Groupe Item commentaires pour :

Item commentaires pour :

Vous devez être connecté pour pouvoir télécharger des formulaires. Veuillez vous connecter ou s’inscrire gratuitement.

OMOP Common Data Model (CDM) Concept Relationship

Anglais

OMOP Common Data Model (CDM) Concept Relationship

1 Formulaires  
Concept Relationship
Description

Concept Relationship

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

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.

Type de données

integer

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

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.

Type de données

integer

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

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

Type de données

text

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

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

Type de données

date

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

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.

Type de données

date

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

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

Type de données

text

Alias
UMLS CUI [1,1]
C0178566
UMLS CUI [1,2]
C0439849
UMLS CUI [1,3]
C3245471
UMLS CUI [1,4]
C0566251
Retour au début de la page

Similar models

OMOP Common Data Model (CDM) Concept Relationship

1 Formulaires
Name
Type
Description | Question | Decode (Coded Value)
Type de données
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])
Retour au début de la page 

Contact

Utilisez ce formulaire pour les retours, les questions et les améliorations suggérées.

Les champs marqués d’un * sont obligatoires.

Aide

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