User Tools

Site Tools


documentation:cdm:relationship

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
documentation:cdm:relationship [2014/11/15 02:40]
cgreich created
documentation:cdm:relationship [2017/09/25 14:58] (current)
clairblacketer
Line 1: Line 1:
 ===== RELATIONSHIP table ===== ===== RELATIONSHIP table =====
 +**THIS IS OUTDATED. All documentation is now on the [[https://​github.com/​OHDSI/​CommonDataModel/​wiki|github wiki]]. Please refer there or to the [[projects:​workgroups:​cdm-wg|CDM working group]] for more information**
  
-The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two concepts in the CONCEPT_RELATIONSHP ​table. Relationships are classified as hierarchical (parent-child) or non-hierarchical (lateral), and are used to determine which concept relationship records should be included in the computation of the CONCEPT_ANCESTOR ​table.+The RELATIONSHIP table provides a reference list of all types of relationships that can be used to associate any two concepts in the CONCEPT_RELATIONSHP table. ​
  
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
Line 14: Line 15:
  
   * There is one record for each Relationship.   * There is one record for each Relationship.
-    ​The relationship_id field contains an alphanumerical identifier, that can also be used as the abbreviation of the Relationship.+  * Relationships are classified as hierarchical (parent-child) or non-hierarchical (lateral) 
 +  * They are used to determine which concept relationship records should be included in the computation of the CONCEPT_ANCESTOR table. 
 +  * The relationship_id field contains an alphanumerical identifier, that can also be used as the abbreviation of the Relationship.
   * The relationship_name field contains the unabbreviated names of the Relationship.   * The relationship_name field contains the unabbreviated names of the Relationship.
   * Relationships all exist symmetrically,​ i.e. in both direction. The relationship_id of the opposite Relationship is provided in the reverse_relationship_id field.   * Relationships all exist symmetrically,​ i.e. in both direction. The relationship_id of the opposite Relationship is provided in the reverse_relationship_id field.
Line 290: Line 293:
 |360|Is domain| |360|Is domain|
  
-~~DISQUS~~ 
documentation/cdm/relationship.1416019245.txt.gz · Last modified: 2014/11/15 02:40 by cgreich