| These rules and the underlying drugdb data may only be used for experimental, non-commercial purposes | | Please send questions and comments to internet.business.logic@gmail.com the drug brand some-ID1 some-name1 has an active ingredient some-IngredientID1 some-IDescr1 the drug brand some-ID2 some-name2 has an active ingredient some-IngredientID2 some-IDescr2 that-ID1 is not equal that-ID2 that-IngredientID1 interacts with that-IngredientID2 as described by some-IIText the drugs with IDs that-ID1 and that-ID2 have an interaction with severity some-severity ----------------------------------------------------------------------------------------------------------------------------- the drugs that-name1 and that-name2 with resp ingredients that-IDescr1 and that-IDescr2 interact with severity that-severity the drug brand some-BrandID1 some-name1 has an active ingredient some-IngredientID1 some-IDescr1 the drug brand some-BrandID2 some-name2 has an active ingredient some-IngredientID2 some-IDescr2 that-BrandID1 is not equal that-BrandID2 that-IngredientID1 is not equal that-IngredientID2 that-IngredientID1 interacts with that-IngredientID2 as described by some-IIText -------------------------------------------------------------------------------------------------- the drugs that-name1 and that-name2 have active ingredients that interact Ingredient Interactions table has some-IID some-IngredientID1 some-IngredientID2 some-IIText some-IRowGuid ----------------------------------------------------------------------------------------------------------- that-IngredientID1 interacts with that-IngredientID2 as described by that-IIText Ingredient Interactions table has some-IID some-IngredientID2 some-IngredientID1 some-IIText some-IRowGuid ----------------------------------------------------------------------------------------------------------- that-IngredientID1 interacts with that-IngredientID2 as described by that-IIText drug brand some-BrandID some-name has an ingredient with ID some-IngID the ingredient that-IngID some-IDescr is active ------------------------------------------------------------------------------------------ the drug brand that-BrandID that-name has an active ingredient that-IngID that-IDescr Drug Brand table has some-BrandID some-name some-RecState some-GenericFlag some-BrandCode some-IngID some-BrandRowGuid some-last-update-time --------------------------------------------------------------------------------------- drug brand that-BrandID that-name has an ingredient with ID that-IngID Ingredient table has some-IngID some-IUsedAs some-IDescr 1 some-IRecordSt some-IntCatagoryID some-DrugStatusID some-AllergyCodeID some-AllergyCodeID2 some-IRowGuid some-last-update-time2 --------------------------------------------------------------------------------- the ingredient that-IngID that-IDescr is active url:www.reengineeringllc.com dbms:mysql dbname:TopsDataDrug tablename:dbo_DRUG_TherapeuticClass port:3306 id:mysql password:mysql ---------------------------------------------------------------------------------------------------------------------------------- TherapeuticClass table has this-TCID this-TCParentID this-TCDescr this-TCRecordState this-TCRowGuid this-last-update-time TherapeuticClass table has some-ID some-ParentID some-class some-TCRecordState some-TCRowGuid some-last-update-time ------------------------------------------------------------------------------------------------------------------------- the therapeutic class that-class has ID that-ID TherapeuticClass table has some-ID some-ParentID some-class some-TCRecordState some-TCRowGuid some-last-update-time that-ID is not equal that-ParentID ------------------------------------------------------------------------------------------------------------------------- the therapeutic class with ID that-ParentID has a direct subclass with ID that-ID at level some-level some-ID1 has a subclass some-ID2 the therapeutic class some-name1 has ID that-ID1 that-name1 is not equal the therapeutic class some-name2 has ID that-ID2 ----------------------------------------------------------------------- at level that-level the drug class that-name1 has a subclass that-name2 the therapeutic class with ID some-ID0 has a direct subclass with ID some-ID1 ----------------------------------------------------------------------------- at level 1 that-ID0 has a subclass that-ID1 the therapeutic class with ID some-ID0 has a direct subclass with ID some-ID1 the therapeutic class with ID that-ID1 has a direct subclass with ID some-ID2 ----------------------------------------------------------------------------- at level 2 that-ID0 has a subclass that-ID2 the therapeutic class with ID some-ID0 has a direct subclass with ID some-ID1 the therapeutic class with ID that-ID1 has a direct subclass with ID some-ID2 the therapeutic class with ID that-ID2 has a direct subclass with ID some-ID3 ----------------------------------------------------------------------------- at level 3 that-ID0 has a subclass that-ID3 the therapeutic class with ID some-ID0 has a direct subclass with ID some-ID1 the therapeutic class with ID that-ID1 has a direct subclass with ID some-ID2 the therapeutic class with ID that-ID2 has a direct subclass with ID some-ID3 the therapeutic class with ID that-ID3 has a direct subclass with ID some-ID4 ----------------------------------------------------------------------------- at level 4 that-ID0 has a subclass that-ID4 the therapeutic class with ID some-ID0 has a direct subclass with ID some-ID1 the therapeutic class with ID that-ID1 has a direct subclass with ID some-ID2 the therapeutic class with ID that-ID2 has a direct subclass with ID some-ID3 the therapeutic class with ID that-ID3 has a direct subclass with ID some-ID4 the therapeutic class with ID that-ID4 has a direct subclass with ID some-ID5 ----------------------------------------------------------------------------- at level 5 that-ID0 has a subclass that-ID5 the drugs with IDs some-ID1 and some-ID2 have an interaction with severity some-severity the drug brand some-name1 has the ID that-ID1 the drug brand some-name2 has the ID that-ID2 ----------------------------------------------------------------------------------- the drugs that-name1 and that-name2 have an interaction with severity that-severity Drug Brand table has some-ID some-name some-RecState some-GenericFlag some-BrandCode some-IngID some-BrandRowGuid some-last-update-time ------------------------------------------------------------------------------------------ the drug brand that-name has the ID that-ID Interaction table has some-IID some-ID1 some-ID2 some-OAType some-OBType some-IReccoms some-IEtext some-severity some-IrecordState some-IRowGuid some-last-update-time --------------------------------------------------------------------------------------------------------------------------------- the drugs with IDs that-ID1 and that-ID2 have an interaction with severity that-severity url:www.reengineeringllc.com dbms:mysql dbname:TopsDataDrug tablename:dbo_DRUG_Ingredient port:3306 id:mysql password:mysql ---------------------------------------------------------------------------------------------------------------------------------- Ingredient table has this-IID this-IUsedAs this-IDescr this-IActive this-IRecordSt this-IntCatagoryID this-DrugStatusID this-AllergyCodeID this-AllergyCodeID2 this-IRowGuid this-last-update-time url:www.reengineeringllc.com dbms:mysql dbname:TopsDataDrug tablename:dbo_DRUG_Interaction port:3306 id:mysql password:mysql ---------------------------------------------------------------------------------------------------------------------------------- Interaction table has this-IID this-OAID this-OBID this-OAType this-OBType this-IReccoms this-IEtext this-ISeverity this-IrecordState this-IRowGuid this-last-update-time url:www.reengineeringllc.com dbms:mysql dbname:TopsDataDrug tablename:dbo_DNRM_IngredientInteractions port:3306 id:mysql password:mysql ---------------------------------------------------------------------------------------------------------------------------------- Ingredient Interactions table has this-IID this-IngredientID1 this-IngredientID2 this-IIText this-IRowGuid url:www.reengineeringllc.com dbms:mysql dbname:TopsDataDrug tablename:dbo_DRUG_Brand port:3306 id:mysql password:mysql ---------------------------------------------------------------------------------------------------------------------------------- Drug Brand table has this-BrandID this-name this-RecState this-GenericFlag this-BrandCode this-IngID this-BrandRowGuid this-last-update-time