Table postgres.omop.dose_era
[DERIVED] A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient.

 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
dose_era_id int4 10 A unique identifier for each Dose Era.
person_id int4 10
person.person_id fpk_dose_era_person R
A foreign key identifier to the Person who is subjected to the drug during the drug era. The demographic details of that Person are stored in the PERSON table.
drug_concept_id int4 10
concept.concept_id fpk_dose_era_concept R
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept.
unit_concept_id int4 10
concept.concept_id fpk_dose_era_unit_concept R
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the unit concept.
dose_value numeric 131089 The numeric value of the dose.
dose_era_start_date date 13 The start date for the drug era constructed from the individual instances of drug exposures. It is the start date of the very first chronologically recorded instance of utilization of a drug.
dose_era_end_date date 13 The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.

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

Indexes:
Column(s) Type Sort Constraint Name
dose_era_id Primary key Asc xpk_dose_era
drug_concept_id Performance Asc idx_dose_era_concept_id
person_id Performance Asc idx_dose_era_person_id

Close relationships  within of separation: