documentation:cdm:concept_relationship
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:concept_relationship [2014/12/13 18:52] cgreich |
documentation:cdm:concept_relationship [2017/09/25 14:58] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== CONCEPT_RELATIONSHIP table ===== | ===== CONCEPT_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 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 [[documentation:cdm:relationship|RELATIONSHIP]] table. | 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 [[documentation:cdm:relationship|RELATIONSHIP]] table. | ||
| Line 6: | Line 7: | ||
| |concept_id_1|Yes|integer|A foreign key to a Concept in the [[documentation:cdm:concept|CONCEPT]] table associated with the relationship. Relationships are directional, and this field represents the source concept designation.| | |concept_id_1|Yes|integer|A foreign key to a Concept in the [[documentation:cdm:concept|CONCEPT]] table associated with the relationship. Relationships are directional, and this field represents the source concept designation.| | ||
| |concept_id_2|Yes|integer|A foreign key to a Concept in the [[documentation:cdm:concept|CONCEPT]] table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.| | |concept_id_2|Yes|integer|A foreign key to a Concept in the [[documentation:cdm:concept|CONCEPT]] table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.| | ||
| - | |relationship_id|Yes|varchar(20)|A unique identifier to the type or nature of the Relationship as defined in the [[documentation:cdm:relationship|RELATIONSHIP]]table.| | + | |relationship_id|Yes|varchar(20)|A unique identifier to the type or nature of the Relationship as defined in the [[documentation:cdm:relationship|RELATIONSHIP]] table.| |
| |valid_start_date|Yes|date|The date when the instance of the Concept Relationship is first recorded.| | |valid_start_date|Yes|date|The date when the instance of the Concept Relationship is first recorded.| | ||
| |valid_end_date|Yes|date|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.| | |valid_end_date|Yes|date|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.| | ||
documentation/cdm/concept_relationship.1418496726.txt.gz ยท Last modified: 2014/12/13 18:52 by cgreich
Page Tools
