drug_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_drug_strength_concept_1 R |
|
ingredient_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_drug_strength_concept_2 R |
|
amount_value |
numeric |
131089 |
√ |
|
null |
|
|
amount_unit_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_drug_strength_unit_1 R |
|
numerator_value |
numeric |
131089 |
√ |
|
null |
|
|
numerator_unit_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_drug_strength_unit_2 R |
|
denominator_value |
numeric |
131089 |
√ |
|
null |
|
|
denominator_unit_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_drug_strength_unit_3 R |
|
box_size |
int4 |
10 |
√ |
|
null |
|
|
valid_start_date |
date |
13 |
|
|
|
|
|
valid_end_date |
date |
13 |
|
|
|
|
|
invalid_reason |
varchar |
1 |
√ |
|
null |
|
|