drug_exposure_id |
int4 |
10 |
|
|
|
|
|
person_id |
int4 |
10 |
|
|
|
|
person.person_id
|
fpk_drug_person R |
|
drug_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_drug_concept R |
|
drug_exposure_start_date |
date |
13 |
|
|
|
|
|
drug_exposure_start_datetime |
timestamp |
29,6 |
|
|
|
|
|
drug_exposure_end_date |
date |
13 |
|
|
|
|
|
drug_exposure_end_datetime |
timestamp |
29,6 |
√ |
|
null |
|
|
verbatim_end_date |
date |
13 |
√ |
|
null |
|
|
drug_type_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_drug_type_concept R |
|
stop_reason |
varchar |
20 |
√ |
|
null |
|
|
refills |
int4 |
10 |
√ |
|
null |
|
|
quantity |
numeric |
131089 |
√ |
|
null |
|
|
days_supply |
int4 |
10 |
√ |
|
null |
|
|
sig |
text |
2147483647 |
√ |
|
null |
|
|
route_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_drug_route_concept R |
|
lot_number |
varchar |
50 |
√ |
|
null |
|
|
provider_id |
int4 |
10 |
√ |
|
null |
|
provider.provider_id
|
fpk_drug_provider R |
|
visit_occurrence_id |
int4 |
10 |
√ |
|
null |
|
|
visit_detail_id |
int4 |
10 |
√ |
|
null |
|
|
drug_source_value |
varchar |
50 |
√ |
|
null |
|
|
drug_source_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_drug_concept_s R |
|
route_source_value |
varchar |
50 |
√ |
|
null |
|
|
dose_unit_source_value |
varchar |
50 |
√ |
|
null |
|
|