Observational Health Data Sciences and Informatics

This is an old revision of the document!

---

All the drug concepts have only relationship_id = 'Maps to' relates to RxNorm Extended or RxNorm concepts

RxNorm and RxNorm extended concept then have all usual relationships and drug_strenght tables (between Ingredient and Drug, Brand Name and Branded Drug and other)

bla-bla 1.standard / non-standard ingredients 2.Brand Names rules 3.Forms 4.Only DIN_7 as a concept_code 5. concept_synonym table with original names / concept table with translations …

61546829 solution 2487 TARTRATE DE NORADRÉNALINE 2 mg 1 ml de solution à diluer pour perfusion SA 1 61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1

keep only those ingredients that are standard, so in drug_strength we'll have only

61546829 solution 9745 NORADRÉNALINE 1 mg 1 ml de solution à diluer pour perfusion FT 1