Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v axiuss40_africa_patient_program_bk age_groups
* Id : int(11)
* From : int(11)
* IsRemoved : tinyint(4)
* Name : varchar(128)
* Till : int(11)
v axiuss40_africa_patient_program_bk backup_log
* Id : int(11)
* Path : int(11)
* DBName : int(11)
* UserName : int(11)
* CreateDT : datetime
* IsSentMessage : tinyint(4)
v axiuss40_africa_patient_program_bk board_association_stat_pages
* Id : int(11)
* Code : varchar(12)
* Name : text
* TreatmentsIdsStr : text
* IllnessIdsStr : text
* ShortName : varchar(12)
* UserId : int(11)
* SortIndex : int(11)
* DateTimeRecordUser : datetime
* IsEnabled : tinyint(4)
* IsEnabledIllnesses : tinyint(4)
* IsEnabledTreatments : tinyint(4)
* isRemoved : tinyint(4)
* UseAgeSettings : tinyint(4)
* IsAgeFromOver : tinyint(4)
* AgeFromOver : int(11)
* IsAgeFromTill : tinyint(4)
* FromAgeYears : int(11)
* TillAgeYears : int(11)
* IsUnderAndOver : tinyint(4)
* UnderYears : int(11)
* OverYears : int(11)
* PatientTypeForStat : int(11)
v axiuss40_africa_patient_program_bk buy_drugs
* Id : int(11)
* Date : datetime
* DrugstoreId : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk buy_drug_items
* Id : int(11)
* TreatmentId : int(11)
* PharmacyId : int(11)
* PurchaseDrugId : int(11)
* TreatmentCount : decimal(10,2)
* PriceForOne : decimal(10,2)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk calendar_items
* Id : int(11)
* CDate : date
* CType : int(11)
* Name : varchar(100)
v axiuss40_africa_patient_program_bk data_sent_from_projects
* Id : int(11)
* Date : date
* OutPatients : int(11)
* PatientsIn : int(11)
* PatientsOut : int(11)
* TransferToBansang : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk drugstores
* id : int(11)
* Name : text
* SortIndex : int(11)
* MonthlyConsumption : int(11)
* isRemoved : tinyint(4)
* isDispensePharmacy : tinyint(4)
* isOutsideStore : tinyint(4)
v axiuss40_africa_patient_program_bk employees
* Id : int(11)
* Name : text
* EmployeeSurname : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk family_planning_services
* Id : int(11)
* Name : text
* AgeYears : int(11)
* Date : date
* PhoneNumber : int(11)
* TownId : int(11)
* TribeId : int(11)
* Nationality : int(11)
* NewAcceptor : int(11)
* TotalNewAcceptors : int(11)
* Revisit : int(11)
* TotalCurrentUsers : int(11)
* TotalWomenSeen : int(11)
* TotalMenSeen : int(11)
* CounselledOnly : int(11)
* MidwifeNurseSignature : text
* UserId : int(11)
* DateTimeRecordUser : datetime
* isRemoved : tinyint(4)
* EmployeeId : tinyint(4)
* IsNewAcceptorDepo : tinyint(4)
* IsNewAcceptorEmergencyContraceptives : tinyint(4)
* IsNewAcceptorFemaleCondom : tinyint(4)
* IsNewAcceptorImplanon : tinyint(4)
* IsNewAcceptorIucd : tinyint(4)
* IsNewAcceptorJadelle : tinyint(4)
* IsNewAcceptorMaleCondom : tinyint(4)
* IsNewAcceptorMarvelon : tinyint(4)
* IsNewAcceptorMicrogynon : tinyint(4)
* IsNewAcceptorMicrolut : tinyint(4)
* IsNewAcceptorNorigynon : tinyint(4)
* IsNewAcceptorNoristat : tinyint(4)
* IsNewAcceptorOtherInjectable : tinyint(4)
* IsNewAcceptorOtherPills : tinyint(4)
* IsRevisitDepo : tinyint(4)
* IsRevisitFemaleCondom : tinyint(4)
* IsRevisitImplanon : tinyint(4)
* IsRevisitIucd : tinyint(4)
* IsRevisitJadelle : tinyint(4)
* IsRevisitMaleCondom : tinyint(4)
* IsRevisitMicrogynon : tinyint(4)
* IsRevisitMorista : tinyint(4)
* IsRevisitNorigynon : tinyint(4)
* IsRevisitNoristat : tinyint(4)
* IsRevisitOtherInjectable : tinyint(4)
* IsRevisitOtherPills : tinyint(4)
* IsRevisitMarvelon : tinyint(4)
* Sex : int(11)
* BadDocStatus : int(11)
* NeedVerification : tinyint(4)
* NeedVerificationText : text
* NeedVerificationUserId : int(11)
* NeedVerificationDate : datetime
* VerificationUserId : int(11)
* VerificationDate : datetime
v axiuss40_africa_patient_program_bk gm_stat_pages
* Id : int(11)
* Name : text
* TreatmentsIdsStr : text
* IllnessIdsStr : text
* ShortName : varchar(10)
* UserId : int(11)
* SortIndex : int(11)
* DateTimeRecordUser : datetime
* IsEnabled : tinyint(4)
* IsEnabledIllnesses : tinyint(4)
* IsEnabledTreatments : tinyint(4)
* isRemoved : tinyint(4)
* UseAgeSettings : tinyint(4)
* IsAgeFromOver : tinyint(4)
* AgeFromOver : int(11)
* IsAgeFromTill : tinyint(4)
* FromAgeYears : int(11)
* TillAgeYears : int(11)
* IsUnderAndOver : tinyint(4)
* UnderYears : int(11)
* OverYears : int(11)
* PatientTypeForStat : int(11)
* UseReasonForDismissal : tinyint(4)
* IsReferral : tinyint(4)
* IsDeath : tinyint(4)
v axiuss40_africa_patient_program_bk illnesses
* id : int(11)
* Name : text
* isRemoved : tinyint(4)
* IsDoubleCheck : tinyint(4)
v axiuss40_africa_patient_program_bk inventorys
* Id : int(11)
* Date : datetime
* DrugstoreId : int(11)
* IsPartial : tinyint(4)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk inventory_items
* Id : int(11)
* InventoryId : int(11)
* TreatmentId : int(11)
* TreatmentCount : decimal(10,2)
* ExpiredCount : decimal(10,2)
* PackSize : decimal(10,2)
* Amount : decimal(10,2)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk labour_delivery
* Id : int(11)
* Name : text
* AgeMotherYears : int(11)
* Date : date
* PhoneNumber : int(11)
* TownId : int(11)
* TribeId : int(11)
* Nationality : int(11)
* AnteNatalCare : int(11)
* NumberChildMother : int(11)
* Gender : int(11)
* LengthInCM : int(11)
* WeightInGram : int(11)
* TypeOfDelivery : int(11)
* ConditionOfNewborn : int(11)
* PostNatalCare : int(11)
* MidwifeNurseSignature : text
* UserId : int(11)
* DateTimeRecordUser : datetime
* isRemoved : tinyint(4)
* EmployeeId : tinyint(4)
* IsAnteNatalCareAbortion : tinyint(4)
* IsAnteNatalCareAnaemiaInPregnancy : tinyint(4)
* IsAnteNatalCareDelayedLabour : tinyint(4)
* IsAnteNatalCareEclampsia : tinyint(4)
* IsAnteNatalCareEctopicPregnancy : tinyint(4)
* IsAnteNatalCareHaemorrhageAntepartum : tinyint(4)
* IsAnteNatalCareHaemorrhagePostPartum : tinyint(4)
* IsAnteNatalCareHypertension : tinyint(4)
* IsAnteNatalCareHypertensionInducedPregnancy : tinyint(4)
* IsAnteNatalCareObstructedLabour : tinyint(4)
* IsAnteNatalCarePreEclampsia : tinyint(4)
* IsAnteNatalCareGotIronInPregnancy : tinyint(4)
* IsPostNatalCareAnaemia : tinyint(4)
* IsPostNatalCareRetainedPlacenta : tinyint(4)
* IsPostNatalCareRupturedUterus : tinyint(4)
* IsPostNatalCareFgmComplication : tinyint(4)
* IsPostNatalCareHypertensionPostpartum : tinyint(4)
* IsPostNatalCareLowerAbdominalPainSevere : tinyint(4)
* IsPostNatalCareMalariaSevere : tinyint(4)
* IsPostNatalCareMalariaUncomplicated : tinyint(4)
* IsPostNatalCarePerinealTear : tinyint(4)
* IsPostNatalCarePuerperalInfection : tinyint(4)
* IsPostNatalCarePuerperalMentalDisorder : tinyint(4)
* IsPostNatalCareSepticEpisiotomy : tinyint(4)
* IsPostNatalCareWellWomen : tinyint(4)
* BadDocStatus : int(11)
* NeedVerification : tinyint(4)
* NeedVerificationText : text
* NeedVerificationUserId : int(11)
* NeedVerificationDate : datetime
* VerificationUserId : int(11)
* VerificationDate : datetime
* IsMultipleBirths : tinyint(4)
* MultipleBirths : int(11)
v axiuss40_africa_patient_program_bk minimum_stick_drugs
* Id : int(11)
* DrugstoreId : int(11)
* TreatmentId : int(11)
* TreatmentCount : decimal(10,2)
* UserEditedId : int(11)
* DateTimeEditRecord : datetime
* IsRemoved : tinyint(4)
* MonthlyFactor : int(11)
v axiuss40_africa_patient_program_bk options
* Id : int(11)
* UserId : int(11)
* Name : varchar(128)
* Value : varchar(128)
v axiuss40_africa_patient_program_bk patient_numbers_per_days
* Id : int(11)
* Date : datetime
* Number1_1 : int(11)
* Number1_2 : int(11)
* Number2_1 : int(11)
* Number2_2 : int(11)
* Number3_1 : int(11)
* Number3_2 : int(11)
* Number4_1 : int(11)
* Number4_2 : int(11)
* Number5_1 : int(11)
* Number5_2 : int(11)
* Number6_1 : int(11)
* Number6_2 : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk patient_properties_items
* id : int(11)
* Name : text
* isRemoved : tinyint(4)
* PhoneNumber : int(11)
* TownId : int(11)
* BPTop : int(11)
* BPBottom : int(11)
* Temperature : decimal(10,2)
* Pulse : int(11)
* PatientStatus : int(11)
* PatientType : int(11)
* PatientStatusForInpatient : int(11)
* DateOfDischarge : datetime
* HBResult : text
* BFResult : text
* WBCResult : text
* UrineResult : text
* BMResult : text
* VDRLResult : text
* HCGResult : text
* SickleCellsResult : text
* AFBResult : text
* CustomResultName : text
* CustomResult : text
* HeadOfCompound : text
* BadDocStatus : int(11)
* NeedVerification : tinyint(4)
* NeedVerificationText : text
* NeedVerificationUserId : int(11)
* NeedVerificationDate : datetime
* VerificationUserId : int(11)
* VerificationDate : datetime
* Nationality : int(11)
v axiuss40_africa_patient_program_bk pharmacies
* id : int(11)
* Name : text
* isRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk plan_inventorys
* Id : int(11)
* Date : date
* DrugstoreId : int(11)
* IsPartial : tinyint(4)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk plan_inventory_items
* Id : int(11)
* PlanInventoryId : int(11)
* TreatmentId : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk prices
* Id : int(11)
* Name : text
* Date : date
* isRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk price_items
* Id : int(11)
* Name : text
* PriceItemType : int(11)
* LabTestType : int(11)
* NoAgeRestriction : tinyint(4)
* AgeFrom : int(11)
* AgeTill : int(11)
* ForGambiansSum : decimal(10,2)
* ForNotGambiansSum : decimal(10,2)
* PriceId : int(11)
* isRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk purchasing_pharmacies
* Id : int(11)
* Name : varchar(128)
* isRemoved : tinyint(4)
* Address : varchar(255)
* Phone : varchar(25)
* Email : varchar(125)
* ContactPerson : varchar(255)
* PhoneOfContactPerson : varchar(25)
* EmailOfContactPerson : varchar(125)
v axiuss40_africa_patient_program_bk state_items
* Id : int(11)
* Years : int(11)
* Sex : char(50)
* Date : datetime
* PatientId : text
* IllnessId : int(11)
* TreatmentId : int(11)
* EmployeeId : int(11)
* IsRemoved : tinyint(4)
* AgeGroupId : int(11)
* UserId : int(11)
* PatientNumber : int(11)
* AgeMonths : int(11)
* DateTimeRecordUser : datetime
* TreatmentPerDay : decimal(10,2)
* TreatmentHowManyDays : decimal(10,2)
* TreatmentCount : decimal(10,2)
* PatientPropertiesItemId : int(11)
v axiuss40_africa_patient_program_bk towns
* id : int(11)
* Name : text
* isRemoved : tinyint(4)
* Distance : int(11)
v axiuss40_africa_patient_program_bk transfer_drugs
* Id : int(11)
* Date : datetime
* DrugstoreToId : int(11)
* DrugstoreFromId : int(11)
* DateOfReceipt : datetime
* DocumentFileName : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk transfer_drug_items
* Id : int(11)
* TransferDrugId : int(11)
* TreatmentId : int(11)
* TreatmentCount : decimal(10,2)
* TreatmentReceivedCount : decimal(10,2)
* ReasonOfDifference : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatments
* Id : int(11)
* Name : text
* isRemoved : tinyint(4)
* TreatmentTypeId : int(11)
* PackingSize : int(11)
v axiuss40_africa_patient_program_bk treatment_applications
* Id : int(11)
* TreatmentId : int(11)
* TreatmentFormId : int(11)
* TreatmentFormValueId : int(11)
* TreatmentClassificationId : int(11)
* Strength : decimal(10,2)
* IsForbiddenForMen : tinyint(4)
* IsForbiddenForWomen : tinyint(4)
* IsForbiddenForBreastfeedingWomen : tinyint(4)
* IsPregnancy : tinyint(4)
* PregnancyMonthsFrom : int(11)
* PregnancyMonthsTill : int(11)
* IsOnlyKids : tinyint(4)
* KidAgeYearFrom : int(11)
* KidAgeYearTill : int(11)
* KidAgeMonthFrom : int(11)
* KidAgeMonthTill : int(11)
* Adults : int(11)
* AdultsTreatmentsPerDay : int(11)
* AdultsTreatmentManyDays : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_application_aliases
* Id : int(11)
* Name : text
* TreatmentApplicationId : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_application_dosages
* Id : int(11)
* TreatmentApplicationDosageGroupId : int(11)
* PatientAgeType : int(11)
* AgeFrom : int(11)
* AgeTill : int(11)
* AgeMonthsFrom : int(11)
* AgeMonthsTill : int(11)
* DurationInDays : int(11)
* DosagePerDay : decimal(10,2)
* DurationInDaysMin : int(11)
* DosagePerDayMin : decimal(10,2)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_application_dosage_groups
* Id : int(11)
* TreatmentApplicationId : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_application_illnesses
* Id : int(11)
* TreatmentApplicationDosageGroupId : int(11)
* IllnessId : int(11)
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_classifications
* Id : int(11)
* Name : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_forms
* Id : int(11)
* Name : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_form_values
* Id : int(11)
* Name : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk treatment_types
* Id : int(11)
* Name : text
* IsRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk tribes
* id : int(11)
* Name : text
* isRemoved : tinyint(4)
v axiuss40_africa_patient_program_bk urine_lab_test_results
* Id : int(11)
* IsRemoved : tinyint(4)
* UrineLabTestType : int(11)
* Result : text
* PatientPropertiesItemId : int(11)
v axiuss40_africa_patient_program_bk users
* Id : int(11)
* Name : text
* Password : text
* isRemoved : tinyint(4)
* isAdmin : tinyint(4)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship