Table postgres.omop.cohort
[DERIVED] The COHORT table contains records of subjects that satisfy a given set of criteria for a duration of time. The definition of the cohort is contained within the COHORT_DEFINITION table. Cohorts can be constructed of patients (Persons), Providers or Visits.

 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_definition.cohort_definition_id fpk_cohort_definition R
A foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort Definition information.
subject_id int4 10 A foreign key to the subject in the cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table.
cohort_start_date date 13 The date when the Cohort Definition criteria for the Person, Provider or Visit first match.
cohort_end_date date 13 The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated.

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

Indexes:
Column(s) Type Sort Constraint Name
cohort_definition_id + subject_id + cohort_start_date + cohort_end_date Primary key Asc/Asc/Asc/Asc xpk_cohort
cohort_definition_id Performance Asc idx_cohort_c_definition_id
subject_id Performance Asc idx_cohort_subject_id

Close relationships  within of separation: