documentation:cdm:relationship
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:relationship [2014/12/02 01:50] jduke |
documentation:cdm:relationship [2017/08/17 15:20] clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== RELATIONSHIP table ===== | ===== RELATIONSHIP table ===== | ||
| + | **The CDM documentation is now being housed on [[https://github.com/OHDSI/CommonDataModel/wiki|github]]. The most recent release is [[https://github.com/OHDSI/CommonDataModel/releases/tag/v5.2.-bugfix.1|v5.2]]** | ||
| - | 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.txt · Last modified: 2017/09/25 14:58 by clairblacketer
Page Tools
