User Tools

Site Tools


documentation:cdm:relationship

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
documentation:cdm:relationship [2014/12/02 01:50] – jdukedocumentation: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.
documentation/cdm/relationship.1417485047.txt.gz · Last modified: by jduke

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki