This shows you the differences between two versions of the page.
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~~ |