Table postgres.omop.drug_era
[DERIVED] A Drug Era is defined as a span of time when the Person is assumed to be exposed to a particular active ingredient. A Drug Era is not the same as a Drug Exposure: Exposures are individual records corresponding to the source when Drug was delivered to the Person, while successive periods of Drug Exposures are combined under certain rules to produce continuous Drug Eras.

 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
drug_era_id int4 10 A unique identifier for each Drug Era.
person_id int4 10
person.person_id fpk_drug_era_person R
A foreign key identifier to the Person who is subjected to the Drug during the fDrug Era. The demographic details of that Person are stored in the PERSON table.
drug_concept_id int4 10
concept.concept_id fpk_drug_era_concept R
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept.
drug_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 conutilization of a Drug.
drug_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.
drug_exposure_count int4 10  √  null The number of individual Drug Exposure occurrences used to construct the Drug Era.
gap_days int4 10  √  null The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record.

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

Indexes:
Column(s) Type Sort Constraint Name
drug_era_id Primary key Asc xpk_drug_era
drug_concept_id Performance Asc idx_drug_era_concept_id
person_id Performance Asc idx_drug_era_person_id

Close relationships  within of separation: