Table postgres.omop.drug_exposure
[CLINICAL] The drug exposure domain captures records about the utilization of a Drug when ingested or otherwise introduced into the body. A Drug is a biochemical substance formulated in such a way that when administered to a Person it will exert a certain physiological effect. Drugs include prescription and over-the-counter medicines, vaccines, and large-molecule biologic therapies. Radiological devices ingested or applied locally do not count as Drugs.

 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_exposure_id int4 10 A system-generated unique identifier for each Drug utilization event.
person_id int4 10
person.person_id fpk_drug_person R
A foreign key identifier to the person who is subjected to the Drug. The demographic details of that person are stored in the person table.
drug_concept_id int4 10
concept.concept_id fpk_drug_concept R
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept.
drug_exposure_start_date date 13 The start date for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded.
drug_exposure_start_datetime timestamp 29,6 The start date and time for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded.
drug_exposure_end_date date 13 The end date for the current instance of Drug utilization. It is not available from all sources.
drug_exposure_end_datetime timestamp 29,6  √  null The end date and time for the current instance of Drug utilization. It is not available from all sources.
verbatim_end_date date 13  √  null The known end date of a drug_exposure as provided by the source
drug_type_concept_id int4 10
concept.concept_id fpk_drug_type_concept R
A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Drug Exposure recorded. It indicates how the Drug Exposure was represented in the source data.
stop_reason varchar 20  √  null The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc.
refills int4 10  √  null The number of refills after the initial prescription. The initial prescription is not counted, values start with 0.
quantity numeric 131089  √  null The quantity of drug as recorded in the original prescription or dispensing record.
days_supply int4 10  √  null The number of days of supply of the medication as recorded in the original prescription or dispensing record.
sig text 2147483647  √  null The directions ("signetur") on the Drug prescription as recorded in the original prescription (and printed on the container) or dispensing record.
route_concept_id int4 10  √  null
concept.concept_id fpk_drug_route_concept R
A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration.
lot_number varchar 50  √  null An identifier assigned to a particular quantity or lot of Drug product from the manufacturer.
provider_id int4 10  √  null
provider.provider_id fpk_drug_provider R
A foreign key to the provider in the provider table who initiated (prescribed or administered) the Drug Exposure.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_drug_visit R
A foreign key to the visit in the visit table during which the Drug Exposure was initiated.
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_drug_visit_detail R
A foreign key to the visit in the VISIT_DETAIL table during which the Drug Exposure was initiated.
drug_source_value varchar 50  √  null The source code for the Drug as it appears in the source data. This code is mapped to a Standard Drug concept in the Standardized Vocabularies and the original code is, stored here for reference.
drug_source_concept_id int4 10  √  null
concept.concept_id fpk_drug_concept_s R
A foreign key to a Drug Concept that refers to the code used in the source.
route_source_value varchar 50  √  null The information about the route of administration as detailed in the source.
dose_unit_source_value varchar 50  √  null The information about the dose unit as detailed in the source.

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

Indexes:
Column(s) Type Sort Constraint Name
drug_exposure_id Primary key Asc xpk_drug_exposure
drug_concept_id Performance Asc idx_drug_concept_id
person_id Performance Asc idx_drug_person_id
visit_detail_id Performance Asc idx_drug_visit_detail_id
visit_occurrence_id Performance Asc idx_drug_visit_id

Close relationships  within of separation: