Table postgres.omop.observation_period
[CLINICAL] The OBSERVATION_PERIOD table contains records which uniquely define the spans of time for which a Person is at-risk to have clinical events recorded within the source systems, even if no events in fact are recorded (healthy patient with no healthcare interactions).

 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
observation_period_id int4 10 A unique identifier for each observation period.
person_id int4 10
person.person_id fpk_observation_period_person R
A foreign key identifier to the person for whom the observation period is defined. The demographic details of that person are stored in the person table.
observation_period_start_date date 13 The start date of the observation period for which data are available from the data source.
observation_period_start_datetime timestamp 29,6
observation_period_end_date date 13 The end date of the observation period for which data are available from the data source.
observation_period_end_datetime timestamp 29,6
period_type_concept_id int4 10
concept.concept_id fpk_observation_period_concept R
A foreign key identifier to the predefined concept in the Standardized Vocabularies reflecting the source of the observation period information

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

Indexes:
Column(s) Type Sort Constraint Name
observation_period_id Primary key Asc xpk_observation_period
person_id Performance Asc idx_observation_period_id

Close relationships  within of separation: