Table postgres.omop.cohort_definition
[VOCABULARY] The COHORT_DEFINITION table contains records defining a Cohort derived from the data through the associated description and syntax and upon instantiation (execution of the algorithm) placed into the COHORT table. Cohorts are a set of subjects that satisfy a given combination of inclusion criteria for a duration of time. The COHORT_DEFINITION table provides a standardized structure for maintaining the rules governing the inclusion of a subject into a cohort, and can store operational programming code to instantiate the cohort within the OMOP Common Data Model.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
cohort_definition_id int4 10
cohort.cohort_definition_id fpk_cohort_definition R
cohort_attribute.cohort_definition_id fpk_ca_cohort_definition R
A unique identifier for each Cohort.
cohort_definition_name varchar 255 A short description of the Cohort.
cohort_definition_description text 2147483647  √  null A complete description of the Cohort definition
definition_type_concept_id int4 10
concept.concept_id fpk_cohort_definition_concept R
Type defining what kind of Cohort Definition the record represents and how the syntax may be executed
cohort_definition_syntax text 2147483647  √  null Syntax or code to operationalize the Cohort definition
subject_concept_id int4 10 A foreign key to the Concept to which defines the domain of subjects that are members of the cohort (e.g., Person, Provider, Visit).
cohort_initiation_date date 13  √  null A date to indicate when the Cohort was initiated in the COHORT table

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
cohort_definition_id Primary key Asc xpk_cohort_definition
cohort_definition_id Performance Asc idx_cohort_definition_id

Close relationships  within of separation: