[Gnumed-devel] drugref mappings to clin_medication

[scaredycat]

Looking at the drugref data, there are only a few drug_units used, and 
they are
for package content description , rather than quantitating dosage.
not sure how day is converted   -  ? to each.
12 converts to each, 2 to g  ,  to satisfy the clin_medication 
constraints. Ok?


> drugref=# select count(*), id_packing_unit from product group by 
> id_packing_unit;
>  count | id_packing_unit
> -------+-----------------
>    259 |               1
>      3 |               2
>   1201 |               7
>     23 |              11
>     43 |              12
>     71 |              13
>      5 |
> (7 rows)
>
> drugref=# select * from dru
> drug_class               drug_element             
> drug_formulations        drug_routes              drug_warning
> drug_dosage              drug_flags               
> drug_information         drug_units               drug_warning_categories
> drugref=# select * from drug_units ;
>  id |  unit
> ----+--------
>   1 | ml
>   2 | mg
>   3 | mg/ml
>   4 | mg/g
>   5 | U
>   6 | IU
>   7 | each
>   8 | mcg
>   9 | mcg/ml
>  10 | IU/ml
>  11 | day
>  12 | dose
>  13 | g
> (13 rows)