Table postgres.omop.condition_era
[DERIVED] A Condition Era is defined as a span of time when the Person is assumed to have a given condition.

 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
condition_era_id int4 10 A unique identifier for each Condition Era.
person_id int4 10
person.person_id fpk_condition_era_person R
A foreign key identifier to the Person who is experiencing the Condition during the Condition Era. The demographic details of that Person are stored in the PERSON table.
condition_concept_id int4 10
concept.concept_id fpk_condition_era_concept R
A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies.
condition_era_start_date date 13 The start date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the start date of the very first chronologically recorded instance of the condition.
condition_era_end_date date 13 The end date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the end date of the final continuously recorded instance of the Condition.
condition_occurrence_count int4 10  √  null The number of individual Condition Occurrences used to construct the condition era.

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

Indexes:
Column(s) Type Sort Constraint Name
condition_era_id Primary key Asc xpk_condition_era
condition_concept_id Performance Asc idx_condition_era_concept_id
person_id Performance Asc idx_condition_era_person_id

Close relationships  within of separation: