Thanks, @DTorok. Looks like the right thing. Round numbers of ml or mg for the solutions and multiples of 30 (= 1 oz.) for the creams. Disconcerting that the majority has no quantity information, but that’s the data.
Yes, that’s what I meant.
Very nice idea. That totally nails it. We would add records to DRUG_STRENGTH for all compunds (drug_concept_id=ingredient_concept_id) with the mg concept in the denominator_unit_concept_id for all “dry” compounds and mL for the “wet” ones. We could steal the knowledge what is what from RxNorm.
Well, there is the use case where you want to specify a, say, chemotherapeutic drug product (certian NDC) but also the actual dose administered. But I guess you are right, you could do that through the quantity mechanism.
Yes, please please.