This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
documentation:cdm:concept_class [2014/11/15 02:37] cgreich created |
documentation:cdm:concept_class [2017/09/25 14:58] (current) clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== CONCEPT_CLASS table ===== | ===== CONCEPT_CLASS 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_CLASS table is a reference table, which includes a list of the classifications used to differentiate Concepts within a given Vocabulary. This reference table is populated with a single record for each Concept Class: | The CONCEPT_CLASS table is a reference table, which includes a list of the classifications used to differentiate Concepts within a given Vocabulary. This reference table is populated with a single record for each Concept Class: | ||
| Line 6: | Line 7: | ||
| |concept_class_id|Yes|varchar(20)|A unique key for each class.| | |concept_class_id|Yes|varchar(20)|A unique key for each class.| | ||
| |concept_class_name|Yes|varchar(255)|The name describing the Concept Class, e.g. "Clinical Finding", "Ingredient", etc.| | |concept_class_name|Yes|varchar(255)|The name describing the Concept Class, e.g. "Clinical Finding", "Ingredient", etc.| | ||
| - | |concept_class_concept_id|Yes|integer|A foreign key that refers to an identifier in the CONCEPT table for the unique Concept Class the record belongs to.| | + | |concept_class_concept_id|Yes|integer|A foreign key that refers to an identifier in the [[documentation:cdm:concept|CONCEPT]] table for the unique Concept Class the record belongs to.| |
| ==== Conventions ==== | ==== Conventions ==== | ||
| Line 125: | Line 126: | ||
| |Visit Type|Visit Type| | |Visit Type|Visit Type| | ||
| - | ~~DISQUS~~ | ||