Table postgres.omop.cohort_attribute
[DERIVED] The COHORT_ATTRIBUTE table contains attributes associated with each subject within a cohort, as defined by a given set of criteria for a duration of time. The definition of the Cohort Attribute is contained in the ATTRIBUTE_DEFINITION table.

 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_ca_cohort_definition R
A foreign key to a record in the [COHORT_DEFINITION](https://github.com/OHDSI/CommonDataModel/wiki/COHORT_DEFINITION) table containing relevant Cohort Definition information.
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.
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.
attribute_definition_id int4 10
attribute_definition.attribute_definition_id fpk_ca_attribute_definition R
A foreign key to a record in the [ATTRIBUTE_DEFINITION](https://github.com/OHDSI/CommonDataModel/wiki/ATTRIBUTE_DEFINITION) table containing relevant Attribute Definition information.
value_as_number numeric 131089  √  null The attribute result stored as a number. This is applicable to attributes where the result is expressed as a numeric value.
value_as_concept_id int4 10  √  null
concept.concept_id fpk_ca_value R
The attribute result stored as a Concept ID. This is applicable to attributes where the result is expressed as a categorical value.

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 + attribute_definition_id Primary key Asc/Asc/Asc/Asc/Asc xpk_cohort_attribute
cohort_definition_id Performance Asc idx_ca_definition_id
subject_id Performance Asc idx_ca_subject_id

Close relationships  within of separation: