Recent
`axiuss40_africa_patient_program`.`prices`
`axiuss40_africa_personal_program_school`.`modules`
`axiuss40_africa_personal_program_school`.`sectors`
`axiuss40_africa_patient_program`.`treatment_forms`
`axiuss40_africa_patient_program`.`location_cities`
`axiuss40_africa_charity_program`.`send_email_logs`
`axiuss40_africa_charity_program`.`folder_files`
`axiuss40_africa_patient_program`.`users`
`axiuss40_africa_personal_program_school`.`worker_group_members`
`axiuss40_africa_personal_program_bk`.`pm_duties`
Favorites
There are no favorite tables.
New
axiuss40_africa
charity_program
axiuss40_africa_charity_program
axiuss40_africa_charity_program_staging
money_program
axiuss40_africa_money_program
axiuss40_africa_money_program_bk
axiuss40_africa_money_program_private
axiuss40_africa_money_program_private_german
axiuss40_africa_money_program_rdi
axiuss40_africa_money_program_staging
patient_program
axiuss40_africa_patient_program
axiuss40_africa_patient_program_bk
axiuss40_africa_patient_program_staging
axiuss40_africa_patient_program_staging_old
personal_program
axiuss40_africa_personal_program
axiuss40_africa_personal_program_bk
axiuss40_africa_personal_program_school
axiuss40_africa_personal_program_staging
information_schema
mysql
performance_schema
task_manager
task_manager
task_manager_staging
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: axiuss40_africa_patient_program_bk
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
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
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`age_groups`.*
`age_groups`.`Id`
`age_groups`.`From`
`age_groups`.`IsRemoved`
`age_groups`.`Name`
`age_groups`.`Till`
`backup_log`.*
`backup_log`.`Id`
`backup_log`.`Path`
`backup_log`.`DBName`
`backup_log`.`UserName`
`backup_log`.`CreateDT`
`backup_log`.`IsSentMessage`
`board_association_stat_pages`.*
`board_association_stat_pages`.`Id`
`board_association_stat_pages`.`Code`
`board_association_stat_pages`.`Name`
`board_association_stat_pages`.`TreatmentsIdsStr`
`board_association_stat_pages`.`IllnessIdsStr`
`board_association_stat_pages`.`ShortName`
`board_association_stat_pages`.`UserId`
`board_association_stat_pages`.`SortIndex`
`board_association_stat_pages`.`DateTimeRecordUser`
`board_association_stat_pages`.`IsEnabled`
`board_association_stat_pages`.`IsEnabledIllnesses`
`board_association_stat_pages`.`IsEnabledTreatments`
`board_association_stat_pages`.`isRemoved`
`board_association_stat_pages`.`UseAgeSettings`
`board_association_stat_pages`.`IsAgeFromOver`
`board_association_stat_pages`.`AgeFromOver`
`board_association_stat_pages`.`IsAgeFromTill`
`board_association_stat_pages`.`FromAgeYears`
`board_association_stat_pages`.`TillAgeYears`
`board_association_stat_pages`.`IsUnderAndOver`
`board_association_stat_pages`.`UnderYears`
`board_association_stat_pages`.`OverYears`
`board_association_stat_pages`.`PatientTypeForStat`
`buy_drug_items`.*
`buy_drug_items`.`Id`
`buy_drug_items`.`TreatmentId`
`buy_drug_items`.`PharmacyId`
`buy_drug_items`.`PurchaseDrugId`
`buy_drug_items`.`TreatmentCount`
`buy_drug_items`.`PriceForOne`
`buy_drug_items`.`IsRemoved`
`buy_drugs`.*
`buy_drugs`.`Id`
`buy_drugs`.`Date`
`buy_drugs`.`DrugstoreId`
`buy_drugs`.`IsRemoved`
`calendar_items`.*
`calendar_items`.`Id`
`calendar_items`.`CDate`
`calendar_items`.`CType`
`calendar_items`.`Name`
`data_sent_from_projects`.*
`data_sent_from_projects`.`Id`
`data_sent_from_projects`.`Date`
`data_sent_from_projects`.`OutPatients`
`data_sent_from_projects`.`PatientsIn`
`data_sent_from_projects`.`PatientsOut`
`data_sent_from_projects`.`TransferToBansang`
`data_sent_from_projects`.`IsRemoved`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`Name`
`drugstores`.`SortIndex`
`drugstores`.`MonthlyConsumption`
`drugstores`.`isRemoved`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`employees`.*
`employees`.`Id`
`employees`.`Name`
`employees`.`EmployeeSurname`
`employees`.`IsRemoved`
`family_planning_services`.*
`family_planning_services`.`Id`
`family_planning_services`.`Name`
`family_planning_services`.`AgeYears`
`family_planning_services`.`Date`
`family_planning_services`.`PhoneNumber`
`family_planning_services`.`TownId`
`family_planning_services`.`TribeId`
`family_planning_services`.`Nationality`
`family_planning_services`.`NewAcceptor`
`family_planning_services`.`TotalNewAcceptors`
`family_planning_services`.`Revisit`
`family_planning_services`.`TotalCurrentUsers`
`family_planning_services`.`TotalWomenSeen`
`family_planning_services`.`TotalMenSeen`
`family_planning_services`.`CounselledOnly`
`family_planning_services`.`MidwifeNurseSignature`
`family_planning_services`.`UserId`
`family_planning_services`.`DateTimeRecordUser`
`family_planning_services`.`isRemoved`
`family_planning_services`.`EmployeeId`
`family_planning_services`.`IsNewAcceptorDepo`
`family_planning_services`.`IsNewAcceptorEmergencyContraceptives`
`family_planning_services`.`IsNewAcceptorFemaleCondom`
`family_planning_services`.`IsNewAcceptorImplanon`
`family_planning_services`.`IsNewAcceptorIucd`
`family_planning_services`.`IsNewAcceptorJadelle`
`family_planning_services`.`IsNewAcceptorMaleCondom`
`family_planning_services`.`IsNewAcceptorMarvelon`
`family_planning_services`.`IsNewAcceptorMicrogynon`
`family_planning_services`.`IsNewAcceptorMicrolut`
`family_planning_services`.`IsNewAcceptorNorigynon`
`family_planning_services`.`IsNewAcceptorNoristat`
`family_planning_services`.`IsNewAcceptorOtherInjectable`
`family_planning_services`.`IsNewAcceptorOtherPills`
`family_planning_services`.`IsRevisitDepo`
`family_planning_services`.`IsRevisitFemaleCondom`
`family_planning_services`.`IsRevisitImplanon`
`family_planning_services`.`IsRevisitIucd`
`family_planning_services`.`IsRevisitJadelle`
`family_planning_services`.`IsRevisitMaleCondom`
`family_planning_services`.`IsRevisitMicrogynon`
`family_planning_services`.`IsRevisitMorista`
`family_planning_services`.`IsRevisitNorigynon`
`family_planning_services`.`IsRevisitNoristat`
`family_planning_services`.`IsRevisitOtherInjectable`
`family_planning_services`.`IsRevisitOtherPills`
`family_planning_services`.`IsRevisitMarvelon`
`family_planning_services`.`Sex`
`family_planning_services`.`BadDocStatus`
`family_planning_services`.`NeedVerification`
`family_planning_services`.`NeedVerificationText`
`family_planning_services`.`NeedVerificationUserId`
`family_planning_services`.`NeedVerificationDate`
`family_planning_services`.`VerificationUserId`
`family_planning_services`.`VerificationDate`
`gm_stat_pages`.*
`gm_stat_pages`.`Id`
`gm_stat_pages`.`Name`
`gm_stat_pages`.`TreatmentsIdsStr`
`gm_stat_pages`.`IllnessIdsStr`
`gm_stat_pages`.`ShortName`
`gm_stat_pages`.`UserId`
`gm_stat_pages`.`SortIndex`
`gm_stat_pages`.`DateTimeRecordUser`
`gm_stat_pages`.`IsEnabled`
`gm_stat_pages`.`IsEnabledIllnesses`
`gm_stat_pages`.`IsEnabledTreatments`
`gm_stat_pages`.`isRemoved`
`gm_stat_pages`.`UseAgeSettings`
`gm_stat_pages`.`IsAgeFromOver`
`gm_stat_pages`.`AgeFromOver`
`gm_stat_pages`.`IsAgeFromTill`
`gm_stat_pages`.`FromAgeYears`
`gm_stat_pages`.`TillAgeYears`
`gm_stat_pages`.`IsUnderAndOver`
`gm_stat_pages`.`UnderYears`
`gm_stat_pages`.`OverYears`
`gm_stat_pages`.`PatientTypeForStat`
`gm_stat_pages`.`UseReasonForDismissal`
`gm_stat_pages`.`IsReferral`
`gm_stat_pages`.`IsDeath`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`Name`
`illnesses`.`isRemoved`
`illnesses`.`IsDoubleCheck`
`inventory_items`.*
`inventory_items`.`Id`
`inventory_items`.`InventoryId`
`inventory_items`.`TreatmentId`
`inventory_items`.`TreatmentCount`
`inventory_items`.`ExpiredCount`
`inventory_items`.`PackSize`
`inventory_items`.`Amount`
`inventory_items`.`IsRemoved`
`inventorys`.*
`inventorys`.`Id`
`inventorys`.`Date`
`inventorys`.`DrugstoreId`
`inventorys`.`IsPartial`
`inventorys`.`IsRemoved`
`labour_delivery`.*
`labour_delivery`.`Id`
`labour_delivery`.`Name`
`labour_delivery`.`AgeMotherYears`
`labour_delivery`.`Date`
`labour_delivery`.`PhoneNumber`
`labour_delivery`.`TownId`
`labour_delivery`.`TribeId`
`labour_delivery`.`Nationality`
`labour_delivery`.`AnteNatalCare`
`labour_delivery`.`NumberChildMother`
`labour_delivery`.`Gender`
`labour_delivery`.`LengthInCM`
`labour_delivery`.`WeightInGram`
`labour_delivery`.`TypeOfDelivery`
`labour_delivery`.`ConditionOfNewborn`
`labour_delivery`.`PostNatalCare`
`labour_delivery`.`MidwifeNurseSignature`
`labour_delivery`.`UserId`
`labour_delivery`.`DateTimeRecordUser`
`labour_delivery`.`isRemoved`
`labour_delivery`.`EmployeeId`
`labour_delivery`.`IsAnteNatalCareAbortion`
`labour_delivery`.`IsAnteNatalCareAnaemiaInPregnancy`
`labour_delivery`.`IsAnteNatalCareDelayedLabour`
`labour_delivery`.`IsAnteNatalCareEclampsia`
`labour_delivery`.`IsAnteNatalCareEctopicPregnancy`
`labour_delivery`.`IsAnteNatalCareHaemorrhageAntepartum`
`labour_delivery`.`IsAnteNatalCareHaemorrhagePostPartum`
`labour_delivery`.`IsAnteNatalCareHypertension`
`labour_delivery`.`IsAnteNatalCareHypertensionInducedPregnancy`
`labour_delivery`.`IsAnteNatalCareObstructedLabour`
`labour_delivery`.`IsAnteNatalCarePreEclampsia`
`labour_delivery`.`IsAnteNatalCareGotIronInPregnancy`
`labour_delivery`.`IsPostNatalCareAnaemia`
`labour_delivery`.`IsPostNatalCareRetainedPlacenta`
`labour_delivery`.`IsPostNatalCareRupturedUterus`
`labour_delivery`.`IsPostNatalCareFgmComplication`
`labour_delivery`.`IsPostNatalCareHypertensionPostpartum`
`labour_delivery`.`IsPostNatalCareLowerAbdominalPainSevere`
`labour_delivery`.`IsPostNatalCareMalariaSevere`
`labour_delivery`.`IsPostNatalCareMalariaUncomplicated`
`labour_delivery`.`IsPostNatalCarePerinealTear`
`labour_delivery`.`IsPostNatalCarePuerperalInfection`
`labour_delivery`.`IsPostNatalCarePuerperalMentalDisorder`
`labour_delivery`.`IsPostNatalCareSepticEpisiotomy`
`labour_delivery`.`IsPostNatalCareWellWomen`
`labour_delivery`.`BadDocStatus`
`labour_delivery`.`NeedVerification`
`labour_delivery`.`NeedVerificationText`
`labour_delivery`.`NeedVerificationUserId`
`labour_delivery`.`NeedVerificationDate`
`labour_delivery`.`VerificationUserId`
`labour_delivery`.`VerificationDate`
`labour_delivery`.`IsMultipleBirths`
`labour_delivery`.`MultipleBirths`
`minimum_stick_drugs`.*
`minimum_stick_drugs`.`Id`
`minimum_stick_drugs`.`DrugstoreId`
`minimum_stick_drugs`.`TreatmentId`
`minimum_stick_drugs`.`TreatmentCount`
`minimum_stick_drugs`.`UserEditedId`
`minimum_stick_drugs`.`DateTimeEditRecord`
`minimum_stick_drugs`.`IsRemoved`
`minimum_stick_drugs`.`MonthlyFactor`
`options`.*
`options`.`Id`
`options`.`UserId`
`options`.`Name`
`options`.`Value`
`patient_numbers_per_days`.*
`patient_numbers_per_days`.`Id`
`patient_numbers_per_days`.`Date`
`patient_numbers_per_days`.`Number1_1`
`patient_numbers_per_days`.`Number1_2`
`patient_numbers_per_days`.`Number2_1`
`patient_numbers_per_days`.`Number2_2`
`patient_numbers_per_days`.`Number3_1`
`patient_numbers_per_days`.`Number3_2`
`patient_numbers_per_days`.`Number4_1`
`patient_numbers_per_days`.`Number4_2`
`patient_numbers_per_days`.`Number5_1`
`patient_numbers_per_days`.`Number5_2`
`patient_numbers_per_days`.`Number6_1`
`patient_numbers_per_days`.`Number6_2`
`patient_numbers_per_days`.`IsRemoved`
`patient_properties_items`.*
`patient_properties_items`.`id`
`patient_properties_items`.`Name`
`patient_properties_items`.`isRemoved`
`patient_properties_items`.`PhoneNumber`
`patient_properties_items`.`TownId`
`patient_properties_items`.`BPTop`
`patient_properties_items`.`BPBottom`
`patient_properties_items`.`Temperature`
`patient_properties_items`.`Pulse`
`patient_properties_items`.`PatientStatus`
`patient_properties_items`.`PatientType`
`patient_properties_items`.`PatientStatusForInpatient`
`patient_properties_items`.`DateOfDischarge`
`patient_properties_items`.`HBResult`
`patient_properties_items`.`BFResult`
`patient_properties_items`.`WBCResult`
`patient_properties_items`.`UrineResult`
`patient_properties_items`.`BMResult`
`patient_properties_items`.`VDRLResult`
`patient_properties_items`.`HCGResult`
`patient_properties_items`.`SickleCellsResult`
`patient_properties_items`.`AFBResult`
`patient_properties_items`.`CustomResultName`
`patient_properties_items`.`CustomResult`
`patient_properties_items`.`HeadOfCompound`
`patient_properties_items`.`BadDocStatus`
`patient_properties_items`.`NeedVerification`
`patient_properties_items`.`NeedVerificationText`
`patient_properties_items`.`NeedVerificationUserId`
`patient_properties_items`.`NeedVerificationDate`
`patient_properties_items`.`VerificationUserId`
`patient_properties_items`.`VerificationDate`
`patient_properties_items`.`Nationality`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`Name`
`pharmacies`.`isRemoved`
`plan_inventory_items`.*
`plan_inventory_items`.`Id`
`plan_inventory_items`.`PlanInventoryId`
`plan_inventory_items`.`TreatmentId`
`plan_inventory_items`.`IsRemoved`
`plan_inventorys`.*
`plan_inventorys`.`Id`
`plan_inventorys`.`Date`
`plan_inventorys`.`DrugstoreId`
`plan_inventorys`.`IsPartial`
`plan_inventorys`.`IsRemoved`
`price_items`.*
`price_items`.`Id`
`price_items`.`Name`
`price_items`.`PriceItemType`
`price_items`.`LabTestType`
`price_items`.`NoAgeRestriction`
`price_items`.`AgeFrom`
`price_items`.`AgeTill`
`price_items`.`ForGambiansSum`
`price_items`.`ForNotGambiansSum`
`price_items`.`PriceId`
`price_items`.`isRemoved`
`prices`.*
`prices`.`Id`
`prices`.`Name`
`prices`.`Date`
`prices`.`isRemoved`
`purchasing_pharmacies`.*
`purchasing_pharmacies`.`Id`
`purchasing_pharmacies`.`Name`
`purchasing_pharmacies`.`isRemoved`
`purchasing_pharmacies`.`Address`
`purchasing_pharmacies`.`Phone`
`purchasing_pharmacies`.`Email`
`purchasing_pharmacies`.`ContactPerson`
`purchasing_pharmacies`.`PhoneOfContactPerson`
`purchasing_pharmacies`.`EmailOfContactPerson`
`state_items`.*
`state_items`.`Id`
`state_items`.`Years`
`state_items`.`Sex`
`state_items`.`Date`
`state_items`.`PatientId`
`state_items`.`IllnessId`
`state_items`.`TreatmentId`
`state_items`.`EmployeeId`
`state_items`.`IsRemoved`
`state_items`.`AgeGroupId`
`state_items`.`UserId`
`state_items`.`PatientNumber`
`state_items`.`AgeMonths`
`state_items`.`DateTimeRecordUser`
`state_items`.`TreatmentPerDay`
`state_items`.`TreatmentHowManyDays`
`state_items`.`TreatmentCount`
`state_items`.`PatientPropertiesItemId`
`towns`.*
`towns`.`id`
`towns`.`Name`
`towns`.`isRemoved`
`towns`.`Distance`
`transfer_drug_items`.*
`transfer_drug_items`.`Id`
`transfer_drug_items`.`TransferDrugId`
`transfer_drug_items`.`TreatmentId`
`transfer_drug_items`.`TreatmentCount`
`transfer_drug_items`.`TreatmentReceivedCount`
`transfer_drug_items`.`ReasonOfDifference`
`transfer_drug_items`.`IsRemoved`
`transfer_drugs`.*
`transfer_drugs`.`Id`
`transfer_drugs`.`Date`
`transfer_drugs`.`DrugstoreToId`
`transfer_drugs`.`DrugstoreFromId`
`transfer_drugs`.`DateOfReceipt`
`transfer_drugs`.`DocumentFileName`
`transfer_drugs`.`IsRemoved`
`treatment_application_aliases`.*
`treatment_application_aliases`.`Id`
`treatment_application_aliases`.`Name`
`treatment_application_aliases`.`TreatmentApplicationId`
`treatment_application_aliases`.`IsRemoved`
`treatment_application_dosage_groups`.*
`treatment_application_dosage_groups`.`Id`
`treatment_application_dosage_groups`.`TreatmentApplicationId`
`treatment_application_dosage_groups`.`IsRemoved`
`treatment_application_dosages`.*
`treatment_application_dosages`.`Id`
`treatment_application_dosages`.`TreatmentApplicationDosageGroupId`
`treatment_application_dosages`.`PatientAgeType`
`treatment_application_dosages`.`AgeFrom`
`treatment_application_dosages`.`AgeTill`
`treatment_application_dosages`.`AgeMonthsFrom`
`treatment_application_dosages`.`AgeMonthsTill`
`treatment_application_dosages`.`DurationInDays`
`treatment_application_dosages`.`DosagePerDay`
`treatment_application_dosages`.`DurationInDaysMin`
`treatment_application_dosages`.`DosagePerDayMin`
`treatment_application_dosages`.`IsRemoved`
`treatment_application_illnesses`.*
`treatment_application_illnesses`.`Id`
`treatment_application_illnesses`.`TreatmentApplicationDosageGroupId`
`treatment_application_illnesses`.`IllnessId`
`treatment_application_illnesses`.`IsRemoved`
`treatment_applications`.*
`treatment_applications`.`Id`
`treatment_applications`.`TreatmentId`
`treatment_applications`.`TreatmentFormId`
`treatment_applications`.`TreatmentFormValueId`
`treatment_applications`.`TreatmentClassificationId`
`treatment_applications`.`Strength`
`treatment_applications`.`IsForbiddenForMen`
`treatment_applications`.`IsForbiddenForWomen`
`treatment_applications`.`IsForbiddenForBreastfeedingWomen`
`treatment_applications`.`IsPregnancy`
`treatment_applications`.`PregnancyMonthsFrom`
`treatment_applications`.`PregnancyMonthsTill`
`treatment_applications`.`IsOnlyKids`
`treatment_applications`.`KidAgeYearFrom`
`treatment_applications`.`KidAgeYearTill`
`treatment_applications`.`KidAgeMonthFrom`
`treatment_applications`.`KidAgeMonthTill`
`treatment_applications`.`Adults`
`treatment_applications`.`AdultsTreatmentsPerDay`
`treatment_applications`.`AdultsTreatmentManyDays`
`treatment_applications`.`IsRemoved`
`treatment_classifications`.*
`treatment_classifications`.`Id`
`treatment_classifications`.`Name`
`treatment_classifications`.`IsRemoved`
`treatment_form_values`.*
`treatment_form_values`.`Id`
`treatment_form_values`.`Name`
`treatment_form_values`.`IsRemoved`
`treatment_forms`.*
`treatment_forms`.`Id`
`treatment_forms`.`Name`
`treatment_forms`.`IsRemoved`
`treatment_types`.*
`treatment_types`.`Id`
`treatment_types`.`Name`
`treatment_types`.`IsRemoved`
`treatments`.*
`treatments`.`Id`
`treatments`.`Name`
`treatments`.`isRemoved`
`treatments`.`TreatmentTypeId`
`treatments`.`PackingSize`
`tribes`.*
`tribes`.`id`
`tribes`.`Name`
`tribes`.`isRemoved`
`urine_lab_test_results`.*
`urine_lab_test_results`.`Id`
`urine_lab_test_results`.`IsRemoved`
`urine_lab_test_results`.`UrineLabTestType`
`urine_lab_test_results`.`Result`
`urine_lab_test_results`.`PatientPropertiesItemId`
`users`.*
`users`.`Id`
`users`.`Name`
`users`.`Password`
`users`.`isRemoved`
`users`.`isAdmin`
`age_groups`.*
`age_groups`.`Id`
`age_groups`.`From`
`age_groups`.`IsRemoved`
`age_groups`.`Name`
`age_groups`.`Till`
`backup_log`.*
`backup_log`.`Id`
`backup_log`.`Path`
`backup_log`.`DBName`
`backup_log`.`UserName`
`backup_log`.`CreateDT`
`backup_log`.`IsSentMessage`
`board_association_stat_pages`.*
`board_association_stat_pages`.`Id`
`board_association_stat_pages`.`Code`
`board_association_stat_pages`.`Name`
`board_association_stat_pages`.`TreatmentsIdsStr`
`board_association_stat_pages`.`IllnessIdsStr`
`board_association_stat_pages`.`ShortName`
`board_association_stat_pages`.`UserId`
`board_association_stat_pages`.`SortIndex`
`board_association_stat_pages`.`DateTimeRecordUser`
`board_association_stat_pages`.`IsEnabled`
`board_association_stat_pages`.`IsEnabledIllnesses`
`board_association_stat_pages`.`IsEnabledTreatments`
`board_association_stat_pages`.`isRemoved`
`board_association_stat_pages`.`UseAgeSettings`
`board_association_stat_pages`.`IsAgeFromOver`
`board_association_stat_pages`.`AgeFromOver`
`board_association_stat_pages`.`IsAgeFromTill`
`board_association_stat_pages`.`FromAgeYears`
`board_association_stat_pages`.`TillAgeYears`
`board_association_stat_pages`.`IsUnderAndOver`
`board_association_stat_pages`.`UnderYears`
`board_association_stat_pages`.`OverYears`
`board_association_stat_pages`.`PatientTypeForStat`
`buy_drug_items`.*
`buy_drug_items`.`Id`
`buy_drug_items`.`TreatmentId`
`buy_drug_items`.`PharmacyId`
`buy_drug_items`.`PurchaseDrugId`
`buy_drug_items`.`TreatmentCount`
`buy_drug_items`.`PriceForOne`
`buy_drug_items`.`IsRemoved`
`buy_drugs`.*
`buy_drugs`.`Id`
`buy_drugs`.`Date`
`buy_drugs`.`DrugstoreId`
`buy_drugs`.`IsRemoved`
`calendar_items`.*
`calendar_items`.`Id`
`calendar_items`.`CDate`
`calendar_items`.`CType`
`calendar_items`.`Name`
`data_sent_from_projects`.*
`data_sent_from_projects`.`Id`
`data_sent_from_projects`.`Date`
`data_sent_from_projects`.`OutPatients`
`data_sent_from_projects`.`PatientsIn`
`data_sent_from_projects`.`PatientsOut`
`data_sent_from_projects`.`TransferToBansang`
`data_sent_from_projects`.`IsRemoved`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`Name`
`drugstores`.`SortIndex`
`drugstores`.`MonthlyConsumption`
`drugstores`.`isRemoved`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`employees`.*
`employees`.`Id`
`employees`.`Name`
`employees`.`EmployeeSurname`
`employees`.`IsRemoved`
`family_planning_services`.*
`family_planning_services`.`Id`
`family_planning_services`.`Name`
`family_planning_services`.`AgeYears`
`family_planning_services`.`Date`
`family_planning_services`.`PhoneNumber`
`family_planning_services`.`TownId`
`family_planning_services`.`TribeId`
`family_planning_services`.`Nationality`
`family_planning_services`.`NewAcceptor`
`family_planning_services`.`TotalNewAcceptors`
`family_planning_services`.`Revisit`
`family_planning_services`.`TotalCurrentUsers`
`family_planning_services`.`TotalWomenSeen`
`family_planning_services`.`TotalMenSeen`
`family_planning_services`.`CounselledOnly`
`family_planning_services`.`MidwifeNurseSignature`
`family_planning_services`.`UserId`
`family_planning_services`.`DateTimeRecordUser`
`family_planning_services`.`isRemoved`
`family_planning_services`.`EmployeeId`
`family_planning_services`.`IsNewAcceptorDepo`
`family_planning_services`.`IsNewAcceptorEmergencyContraceptives`
`family_planning_services`.`IsNewAcceptorFemaleCondom`
`family_planning_services`.`IsNewAcceptorImplanon`
`family_planning_services`.`IsNewAcceptorIucd`
`family_planning_services`.`IsNewAcceptorJadelle`
`family_planning_services`.`IsNewAcceptorMaleCondom`
`family_planning_services`.`IsNewAcceptorMarvelon`
`family_planning_services`.`IsNewAcceptorMicrogynon`
`family_planning_services`.`IsNewAcceptorMicrolut`
`family_planning_services`.`IsNewAcceptorNorigynon`
`family_planning_services`.`IsNewAcceptorNoristat`
`family_planning_services`.`IsNewAcceptorOtherInjectable`
`family_planning_services`.`IsNewAcceptorOtherPills`
`family_planning_services`.`IsRevisitDepo`
`family_planning_services`.`IsRevisitFemaleCondom`
`family_planning_services`.`IsRevisitImplanon`
`family_planning_services`.`IsRevisitIucd`
`family_planning_services`.`IsRevisitJadelle`
`family_planning_services`.`IsRevisitMaleCondom`
`family_planning_services`.`IsRevisitMicrogynon`
`family_planning_services`.`IsRevisitMorista`
`family_planning_services`.`IsRevisitNorigynon`
`family_planning_services`.`IsRevisitNoristat`
`family_planning_services`.`IsRevisitOtherInjectable`
`family_planning_services`.`IsRevisitOtherPills`
`family_planning_services`.`IsRevisitMarvelon`
`family_planning_services`.`Sex`
`family_planning_services`.`BadDocStatus`
`family_planning_services`.`NeedVerification`
`family_planning_services`.`NeedVerificationText`
`family_planning_services`.`NeedVerificationUserId`
`family_planning_services`.`NeedVerificationDate`
`family_planning_services`.`VerificationUserId`
`family_planning_services`.`VerificationDate`
`gm_stat_pages`.*
`gm_stat_pages`.`Id`
`gm_stat_pages`.`Name`
`gm_stat_pages`.`TreatmentsIdsStr`
`gm_stat_pages`.`IllnessIdsStr`
`gm_stat_pages`.`ShortName`
`gm_stat_pages`.`UserId`
`gm_stat_pages`.`SortIndex`
`gm_stat_pages`.`DateTimeRecordUser`
`gm_stat_pages`.`IsEnabled`
`gm_stat_pages`.`IsEnabledIllnesses`
`gm_stat_pages`.`IsEnabledTreatments`
`gm_stat_pages`.`isRemoved`
`gm_stat_pages`.`UseAgeSettings`
`gm_stat_pages`.`IsAgeFromOver`
`gm_stat_pages`.`AgeFromOver`
`gm_stat_pages`.`IsAgeFromTill`
`gm_stat_pages`.`FromAgeYears`
`gm_stat_pages`.`TillAgeYears`
`gm_stat_pages`.`IsUnderAndOver`
`gm_stat_pages`.`UnderYears`
`gm_stat_pages`.`OverYears`
`gm_stat_pages`.`PatientTypeForStat`
`gm_stat_pages`.`UseReasonForDismissal`
`gm_stat_pages`.`IsReferral`
`gm_stat_pages`.`IsDeath`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`Name`
`illnesses`.`isRemoved`
`illnesses`.`IsDoubleCheck`
`inventory_items`.*
`inventory_items`.`Id`
`inventory_items`.`InventoryId`
`inventory_items`.`TreatmentId`
`inventory_items`.`TreatmentCount`
`inventory_items`.`ExpiredCount`
`inventory_items`.`PackSize`
`inventory_items`.`Amount`
`inventory_items`.`IsRemoved`
`inventorys`.*
`inventorys`.`Id`
`inventorys`.`Date`
`inventorys`.`DrugstoreId`
`inventorys`.`IsPartial`
`inventorys`.`IsRemoved`
`labour_delivery`.*
`labour_delivery`.`Id`
`labour_delivery`.`Name`
`labour_delivery`.`AgeMotherYears`
`labour_delivery`.`Date`
`labour_delivery`.`PhoneNumber`
`labour_delivery`.`TownId`
`labour_delivery`.`TribeId`
`labour_delivery`.`Nationality`
`labour_delivery`.`AnteNatalCare`
`labour_delivery`.`NumberChildMother`
`labour_delivery`.`Gender`
`labour_delivery`.`LengthInCM`
`labour_delivery`.`WeightInGram`
`labour_delivery`.`TypeOfDelivery`
`labour_delivery`.`ConditionOfNewborn`
`labour_delivery`.`PostNatalCare`
`labour_delivery`.`MidwifeNurseSignature`
`labour_delivery`.`UserId`
`labour_delivery`.`DateTimeRecordUser`
`labour_delivery`.`isRemoved`
`labour_delivery`.`EmployeeId`
`labour_delivery`.`IsAnteNatalCareAbortion`
`labour_delivery`.`IsAnteNatalCareAnaemiaInPregnancy`
`labour_delivery`.`IsAnteNatalCareDelayedLabour`
`labour_delivery`.`IsAnteNatalCareEclampsia`
`labour_delivery`.`IsAnteNatalCareEctopicPregnancy`
`labour_delivery`.`IsAnteNatalCareHaemorrhageAntepartum`
`labour_delivery`.`IsAnteNatalCareHaemorrhagePostPartum`
`labour_delivery`.`IsAnteNatalCareHypertension`
`labour_delivery`.`IsAnteNatalCareHypertensionInducedPregnancy`
`labour_delivery`.`IsAnteNatalCareObstructedLabour`
`labour_delivery`.`IsAnteNatalCarePreEclampsia`
`labour_delivery`.`IsAnteNatalCareGotIronInPregnancy`
`labour_delivery`.`IsPostNatalCareAnaemia`
`labour_delivery`.`IsPostNatalCareRetainedPlacenta`
`labour_delivery`.`IsPostNatalCareRupturedUterus`
`labour_delivery`.`IsPostNatalCareFgmComplication`
`labour_delivery`.`IsPostNatalCareHypertensionPostpartum`
`labour_delivery`.`IsPostNatalCareLowerAbdominalPainSevere`
`labour_delivery`.`IsPostNatalCareMalariaSevere`
`labour_delivery`.`IsPostNatalCareMalariaUncomplicated`
`labour_delivery`.`IsPostNatalCarePerinealTear`
`labour_delivery`.`IsPostNatalCarePuerperalInfection`
`labour_delivery`.`IsPostNatalCarePuerperalMentalDisorder`
`labour_delivery`.`IsPostNatalCareSepticEpisiotomy`
`labour_delivery`.`IsPostNatalCareWellWomen`
`labour_delivery`.`BadDocStatus`
`labour_delivery`.`NeedVerification`
`labour_delivery`.`NeedVerificationText`
`labour_delivery`.`NeedVerificationUserId`
`labour_delivery`.`NeedVerificationDate`
`labour_delivery`.`VerificationUserId`
`labour_delivery`.`VerificationDate`
`labour_delivery`.`IsMultipleBirths`
`labour_delivery`.`MultipleBirths`
`minimum_stick_drugs`.*
`minimum_stick_drugs`.`Id`
`minimum_stick_drugs`.`DrugstoreId`
`minimum_stick_drugs`.`TreatmentId`
`minimum_stick_drugs`.`TreatmentCount`
`minimum_stick_drugs`.`UserEditedId`
`minimum_stick_drugs`.`DateTimeEditRecord`
`minimum_stick_drugs`.`IsRemoved`
`minimum_stick_drugs`.`MonthlyFactor`
`options`.*
`options`.`Id`
`options`.`UserId`
`options`.`Name`
`options`.`Value`
`patient_numbers_per_days`.*
`patient_numbers_per_days`.`Id`
`patient_numbers_per_days`.`Date`
`patient_numbers_per_days`.`Number1_1`
`patient_numbers_per_days`.`Number1_2`
`patient_numbers_per_days`.`Number2_1`
`patient_numbers_per_days`.`Number2_2`
`patient_numbers_per_days`.`Number3_1`
`patient_numbers_per_days`.`Number3_2`
`patient_numbers_per_days`.`Number4_1`
`patient_numbers_per_days`.`Number4_2`
`patient_numbers_per_days`.`Number5_1`
`patient_numbers_per_days`.`Number5_2`
`patient_numbers_per_days`.`Number6_1`
`patient_numbers_per_days`.`Number6_2`
`patient_numbers_per_days`.`IsRemoved`
`patient_properties_items`.*
`patient_properties_items`.`id`
`patient_properties_items`.`Name`
`patient_properties_items`.`isRemoved`
`patient_properties_items`.`PhoneNumber`
`patient_properties_items`.`TownId`
`patient_properties_items`.`BPTop`
`patient_properties_items`.`BPBottom`
`patient_properties_items`.`Temperature`
`patient_properties_items`.`Pulse`
`patient_properties_items`.`PatientStatus`
`patient_properties_items`.`PatientType`
`patient_properties_items`.`PatientStatusForInpatient`
`patient_properties_items`.`DateOfDischarge`
`patient_properties_items`.`HBResult`
`patient_properties_items`.`BFResult`
`patient_properties_items`.`WBCResult`
`patient_properties_items`.`UrineResult`
`patient_properties_items`.`BMResult`
`patient_properties_items`.`VDRLResult`
`patient_properties_items`.`HCGResult`
`patient_properties_items`.`SickleCellsResult`
`patient_properties_items`.`AFBResult`
`patient_properties_items`.`CustomResultName`
`patient_properties_items`.`CustomResult`
`patient_properties_items`.`HeadOfCompound`
`patient_properties_items`.`BadDocStatus`
`patient_properties_items`.`NeedVerification`
`patient_properties_items`.`NeedVerificationText`
`patient_properties_items`.`NeedVerificationUserId`
`patient_properties_items`.`NeedVerificationDate`
`patient_properties_items`.`VerificationUserId`
`patient_properties_items`.`VerificationDate`
`patient_properties_items`.`Nationality`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`Name`
`pharmacies`.`isRemoved`
`plan_inventory_items`.*
`plan_inventory_items`.`Id`
`plan_inventory_items`.`PlanInventoryId`
`plan_inventory_items`.`TreatmentId`
`plan_inventory_items`.`IsRemoved`
`plan_inventorys`.*
`plan_inventorys`.`Id`
`plan_inventorys`.`Date`
`plan_inventorys`.`DrugstoreId`
`plan_inventorys`.`IsPartial`
`plan_inventorys`.`IsRemoved`
`price_items`.*
`price_items`.`Id`
`price_items`.`Name`
`price_items`.`PriceItemType`
`price_items`.`LabTestType`
`price_items`.`NoAgeRestriction`
`price_items`.`AgeFrom`
`price_items`.`AgeTill`
`price_items`.`ForGambiansSum`
`price_items`.`ForNotGambiansSum`
`price_items`.`PriceId`
`price_items`.`isRemoved`
`prices`.*
`prices`.`Id`
`prices`.`Name`
`prices`.`Date`
`prices`.`isRemoved`
`purchasing_pharmacies`.*
`purchasing_pharmacies`.`Id`
`purchasing_pharmacies`.`Name`
`purchasing_pharmacies`.`isRemoved`
`purchasing_pharmacies`.`Address`
`purchasing_pharmacies`.`Phone`
`purchasing_pharmacies`.`Email`
`purchasing_pharmacies`.`ContactPerson`
`purchasing_pharmacies`.`PhoneOfContactPerson`
`purchasing_pharmacies`.`EmailOfContactPerson`
`state_items`.*
`state_items`.`Id`
`state_items`.`Years`
`state_items`.`Sex`
`state_items`.`Date`
`state_items`.`PatientId`
`state_items`.`IllnessId`
`state_items`.`TreatmentId`
`state_items`.`EmployeeId`
`state_items`.`IsRemoved`
`state_items`.`AgeGroupId`
`state_items`.`UserId`
`state_items`.`PatientNumber`
`state_items`.`AgeMonths`
`state_items`.`DateTimeRecordUser`
`state_items`.`TreatmentPerDay`
`state_items`.`TreatmentHowManyDays`
`state_items`.`TreatmentCount`
`state_items`.`PatientPropertiesItemId`
`towns`.*
`towns`.`id`
`towns`.`Name`
`towns`.`isRemoved`
`towns`.`Distance`
`transfer_drug_items`.*
`transfer_drug_items`.`Id`
`transfer_drug_items`.`TransferDrugId`
`transfer_drug_items`.`TreatmentId`
`transfer_drug_items`.`TreatmentCount`
`transfer_drug_items`.`TreatmentReceivedCount`
`transfer_drug_items`.`ReasonOfDifference`
`transfer_drug_items`.`IsRemoved`
`transfer_drugs`.*
`transfer_drugs`.`Id`
`transfer_drugs`.`Date`
`transfer_drugs`.`DrugstoreToId`
`transfer_drugs`.`DrugstoreFromId`
`transfer_drugs`.`DateOfReceipt`
`transfer_drugs`.`DocumentFileName`
`transfer_drugs`.`IsRemoved`
`treatment_application_aliases`.*
`treatment_application_aliases`.`Id`
`treatment_application_aliases`.`Name`
`treatment_application_aliases`.`TreatmentApplicationId`
`treatment_application_aliases`.`IsRemoved`
`treatment_application_dosage_groups`.*
`treatment_application_dosage_groups`.`Id`
`treatment_application_dosage_groups`.`TreatmentApplicationId`
`treatment_application_dosage_groups`.`IsRemoved`
`treatment_application_dosages`.*
`treatment_application_dosages`.`Id`
`treatment_application_dosages`.`TreatmentApplicationDosageGroupId`
`treatment_application_dosages`.`PatientAgeType`
`treatment_application_dosages`.`AgeFrom`
`treatment_application_dosages`.`AgeTill`
`treatment_application_dosages`.`AgeMonthsFrom`
`treatment_application_dosages`.`AgeMonthsTill`
`treatment_application_dosages`.`DurationInDays`
`treatment_application_dosages`.`DosagePerDay`
`treatment_application_dosages`.`DurationInDaysMin`
`treatment_application_dosages`.`DosagePerDayMin`
`treatment_application_dosages`.`IsRemoved`
`treatment_application_illnesses`.*
`treatment_application_illnesses`.`Id`
`treatment_application_illnesses`.`TreatmentApplicationDosageGroupId`
`treatment_application_illnesses`.`IllnessId`
`treatment_application_illnesses`.`IsRemoved`
`treatment_applications`.*
`treatment_applications`.`Id`
`treatment_applications`.`TreatmentId`
`treatment_applications`.`TreatmentFormId`
`treatment_applications`.`TreatmentFormValueId`
`treatment_applications`.`TreatmentClassificationId`
`treatment_applications`.`Strength`
`treatment_applications`.`IsForbiddenForMen`
`treatment_applications`.`IsForbiddenForWomen`
`treatment_applications`.`IsForbiddenForBreastfeedingWomen`
`treatment_applications`.`IsPregnancy`
`treatment_applications`.`PregnancyMonthsFrom`
`treatment_applications`.`PregnancyMonthsTill`
`treatment_applications`.`IsOnlyKids`
`treatment_applications`.`KidAgeYearFrom`
`treatment_applications`.`KidAgeYearTill`
`treatment_applications`.`KidAgeMonthFrom`
`treatment_applications`.`KidAgeMonthTill`
`treatment_applications`.`Adults`
`treatment_applications`.`AdultsTreatmentsPerDay`
`treatment_applications`.`AdultsTreatmentManyDays`
`treatment_applications`.`IsRemoved`
`treatment_classifications`.*
`treatment_classifications`.`Id`
`treatment_classifications`.`Name`
`treatment_classifications`.`IsRemoved`
`treatment_form_values`.*
`treatment_form_values`.`Id`
`treatment_form_values`.`Name`
`treatment_form_values`.`IsRemoved`
`treatment_forms`.*
`treatment_forms`.`Id`
`treatment_forms`.`Name`
`treatment_forms`.`IsRemoved`
`treatment_types`.*
`treatment_types`.`Id`
`treatment_types`.`Name`
`treatment_types`.`IsRemoved`
`treatments`.*
`treatments`.`Id`
`treatments`.`Name`
`treatments`.`isRemoved`
`treatments`.`TreatmentTypeId`
`treatments`.`PackingSize`
`tribes`.*
`tribes`.`id`
`tribes`.`Name`
`tribes`.`isRemoved`
`urine_lab_test_results`.*
`urine_lab_test_results`.`Id`
`urine_lab_test_results`.`IsRemoved`
`urine_lab_test_results`.`UrineLabTestType`
`urine_lab_test_results`.`Result`
`urine_lab_test_results`.`PatientPropertiesItemId`
`users`.*
`users`.`Id`
`users`.`Name`
`users`.`Password`
`users`.`isRemoved`
`users`.`isAdmin`
`age_groups`.*
`age_groups`.`Id`
`age_groups`.`From`
`age_groups`.`IsRemoved`
`age_groups`.`Name`
`age_groups`.`Till`
`backup_log`.*
`backup_log`.`Id`
`backup_log`.`Path`
`backup_log`.`DBName`
`backup_log`.`UserName`
`backup_log`.`CreateDT`
`backup_log`.`IsSentMessage`
`board_association_stat_pages`.*
`board_association_stat_pages`.`Id`
`board_association_stat_pages`.`Code`
`board_association_stat_pages`.`Name`
`board_association_stat_pages`.`TreatmentsIdsStr`
`board_association_stat_pages`.`IllnessIdsStr`
`board_association_stat_pages`.`ShortName`
`board_association_stat_pages`.`UserId`
`board_association_stat_pages`.`SortIndex`
`board_association_stat_pages`.`DateTimeRecordUser`
`board_association_stat_pages`.`IsEnabled`
`board_association_stat_pages`.`IsEnabledIllnesses`
`board_association_stat_pages`.`IsEnabledTreatments`
`board_association_stat_pages`.`isRemoved`
`board_association_stat_pages`.`UseAgeSettings`
`board_association_stat_pages`.`IsAgeFromOver`
`board_association_stat_pages`.`AgeFromOver`
`board_association_stat_pages`.`IsAgeFromTill`
`board_association_stat_pages`.`FromAgeYears`
`board_association_stat_pages`.`TillAgeYears`
`board_association_stat_pages`.`IsUnderAndOver`
`board_association_stat_pages`.`UnderYears`
`board_association_stat_pages`.`OverYears`
`board_association_stat_pages`.`PatientTypeForStat`
`buy_drug_items`.*
`buy_drug_items`.`Id`
`buy_drug_items`.`TreatmentId`
`buy_drug_items`.`PharmacyId`
`buy_drug_items`.`PurchaseDrugId`
`buy_drug_items`.`TreatmentCount`
`buy_drug_items`.`PriceForOne`
`buy_drug_items`.`IsRemoved`
`buy_drugs`.*
`buy_drugs`.`Id`
`buy_drugs`.`Date`
`buy_drugs`.`DrugstoreId`
`buy_drugs`.`IsRemoved`
`calendar_items`.*
`calendar_items`.`Id`
`calendar_items`.`CDate`
`calendar_items`.`CType`
`calendar_items`.`Name`
`data_sent_from_projects`.*
`data_sent_from_projects`.`Id`
`data_sent_from_projects`.`Date`
`data_sent_from_projects`.`OutPatients`
`data_sent_from_projects`.`PatientsIn`
`data_sent_from_projects`.`PatientsOut`
`data_sent_from_projects`.`TransferToBansang`
`data_sent_from_projects`.`IsRemoved`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`Name`
`drugstores`.`SortIndex`
`drugstores`.`MonthlyConsumption`
`drugstores`.`isRemoved`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`employees`.*
`employees`.`Id`
`employees`.`Name`
`employees`.`EmployeeSurname`
`employees`.`IsRemoved`
`family_planning_services`.*
`family_planning_services`.`Id`
`family_planning_services`.`Name`
`family_planning_services`.`AgeYears`
`family_planning_services`.`Date`
`family_planning_services`.`PhoneNumber`
`family_planning_services`.`TownId`
`family_planning_services`.`TribeId`
`family_planning_services`.`Nationality`
`family_planning_services`.`NewAcceptor`
`family_planning_services`.`TotalNewAcceptors`
`family_planning_services`.`Revisit`
`family_planning_services`.`TotalCurrentUsers`
`family_planning_services`.`TotalWomenSeen`
`family_planning_services`.`TotalMenSeen`
`family_planning_services`.`CounselledOnly`
`family_planning_services`.`MidwifeNurseSignature`
`family_planning_services`.`UserId`
`family_planning_services`.`DateTimeRecordUser`
`family_planning_services`.`isRemoved`
`family_planning_services`.`EmployeeId`
`family_planning_services`.`IsNewAcceptorDepo`
`family_planning_services`.`IsNewAcceptorEmergencyContraceptives`
`family_planning_services`.`IsNewAcceptorFemaleCondom`
`family_planning_services`.`IsNewAcceptorImplanon`
`family_planning_services`.`IsNewAcceptorIucd`
`family_planning_services`.`IsNewAcceptorJadelle`
`family_planning_services`.`IsNewAcceptorMaleCondom`
`family_planning_services`.`IsNewAcceptorMarvelon`
`family_planning_services`.`IsNewAcceptorMicrogynon`
`family_planning_services`.`IsNewAcceptorMicrolut`
`family_planning_services`.`IsNewAcceptorNorigynon`
`family_planning_services`.`IsNewAcceptorNoristat`
`family_planning_services`.`IsNewAcceptorOtherInjectable`
`family_planning_services`.`IsNewAcceptorOtherPills`
`family_planning_services`.`IsRevisitDepo`
`family_planning_services`.`IsRevisitFemaleCondom`
`family_planning_services`.`IsRevisitImplanon`
`family_planning_services`.`IsRevisitIucd`
`family_planning_services`.`IsRevisitJadelle`
`family_planning_services`.`IsRevisitMaleCondom`
`family_planning_services`.`IsRevisitMicrogynon`
`family_planning_services`.`IsRevisitMorista`
`family_planning_services`.`IsRevisitNorigynon`
`family_planning_services`.`IsRevisitNoristat`
`family_planning_services`.`IsRevisitOtherInjectable`
`family_planning_services`.`IsRevisitOtherPills`
`family_planning_services`.`IsRevisitMarvelon`
`family_planning_services`.`Sex`
`family_planning_services`.`BadDocStatus`
`family_planning_services`.`NeedVerification`
`family_planning_services`.`NeedVerificationText`
`family_planning_services`.`NeedVerificationUserId`
`family_planning_services`.`NeedVerificationDate`
`family_planning_services`.`VerificationUserId`
`family_planning_services`.`VerificationDate`
`gm_stat_pages`.*
`gm_stat_pages`.`Id`
`gm_stat_pages`.`Name`
`gm_stat_pages`.`TreatmentsIdsStr`
`gm_stat_pages`.`IllnessIdsStr`
`gm_stat_pages`.`ShortName`
`gm_stat_pages`.`UserId`
`gm_stat_pages`.`SortIndex`
`gm_stat_pages`.`DateTimeRecordUser`
`gm_stat_pages`.`IsEnabled`
`gm_stat_pages`.`IsEnabledIllnesses`
`gm_stat_pages`.`IsEnabledTreatments`
`gm_stat_pages`.`isRemoved`
`gm_stat_pages`.`UseAgeSettings`
`gm_stat_pages`.`IsAgeFromOver`
`gm_stat_pages`.`AgeFromOver`
`gm_stat_pages`.`IsAgeFromTill`
`gm_stat_pages`.`FromAgeYears`
`gm_stat_pages`.`TillAgeYears`
`gm_stat_pages`.`IsUnderAndOver`
`gm_stat_pages`.`UnderYears`
`gm_stat_pages`.`OverYears`
`gm_stat_pages`.`PatientTypeForStat`
`gm_stat_pages`.`UseReasonForDismissal`
`gm_stat_pages`.`IsReferral`
`gm_stat_pages`.`IsDeath`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`Name`
`illnesses`.`isRemoved`
`illnesses`.`IsDoubleCheck`
`inventory_items`.*
`inventory_items`.`Id`
`inventory_items`.`InventoryId`
`inventory_items`.`TreatmentId`
`inventory_items`.`TreatmentCount`
`inventory_items`.`ExpiredCount`
`inventory_items`.`PackSize`
`inventory_items`.`Amount`
`inventory_items`.`IsRemoved`
`inventorys`.*
`inventorys`.`Id`
`inventorys`.`Date`
`inventorys`.`DrugstoreId`
`inventorys`.`IsPartial`
`inventorys`.`IsRemoved`
`labour_delivery`.*
`labour_delivery`.`Id`
`labour_delivery`.`Name`
`labour_delivery`.`AgeMotherYears`
`labour_delivery`.`Date`
`labour_delivery`.`PhoneNumber`
`labour_delivery`.`TownId`
`labour_delivery`.`TribeId`
`labour_delivery`.`Nationality`
`labour_delivery`.`AnteNatalCare`
`labour_delivery`.`NumberChildMother`
`labour_delivery`.`Gender`
`labour_delivery`.`LengthInCM`
`labour_delivery`.`WeightInGram`
`labour_delivery`.`TypeOfDelivery`
`labour_delivery`.`ConditionOfNewborn`
`labour_delivery`.`PostNatalCare`
`labour_delivery`.`MidwifeNurseSignature`
`labour_delivery`.`UserId`
`labour_delivery`.`DateTimeRecordUser`
`labour_delivery`.`isRemoved`
`labour_delivery`.`EmployeeId`
`labour_delivery`.`IsAnteNatalCareAbortion`
`labour_delivery`.`IsAnteNatalCareAnaemiaInPregnancy`
`labour_delivery`.`IsAnteNatalCareDelayedLabour`
`labour_delivery`.`IsAnteNatalCareEclampsia`
`labour_delivery`.`IsAnteNatalCareEctopicPregnancy`
`labour_delivery`.`IsAnteNatalCareHaemorrhageAntepartum`
`labour_delivery`.`IsAnteNatalCareHaemorrhagePostPartum`
`labour_delivery`.`IsAnteNatalCareHypertension`
`labour_delivery`.`IsAnteNatalCareHypertensionInducedPregnancy`
`labour_delivery`.`IsAnteNatalCareObstructedLabour`
`labour_delivery`.`IsAnteNatalCarePreEclampsia`
`labour_delivery`.`IsAnteNatalCareGotIronInPregnancy`
`labour_delivery`.`IsPostNatalCareAnaemia`
`labour_delivery`.`IsPostNatalCareRetainedPlacenta`
`labour_delivery`.`IsPostNatalCareRupturedUterus`
`labour_delivery`.`IsPostNatalCareFgmComplication`
`labour_delivery`.`IsPostNatalCareHypertensionPostpartum`
`labour_delivery`.`IsPostNatalCareLowerAbdominalPainSevere`
`labour_delivery`.`IsPostNatalCareMalariaSevere`
`labour_delivery`.`IsPostNatalCareMalariaUncomplicated`
`labour_delivery`.`IsPostNatalCarePerinealTear`
`labour_delivery`.`IsPostNatalCarePuerperalInfection`
`labour_delivery`.`IsPostNatalCarePuerperalMentalDisorder`
`labour_delivery`.`IsPostNatalCareSepticEpisiotomy`
`labour_delivery`.`IsPostNatalCareWellWomen`
`labour_delivery`.`BadDocStatus`
`labour_delivery`.`NeedVerification`
`labour_delivery`.`NeedVerificationText`
`labour_delivery`.`NeedVerificationUserId`
`labour_delivery`.`NeedVerificationDate`
`labour_delivery`.`VerificationUserId`
`labour_delivery`.`VerificationDate`
`labour_delivery`.`IsMultipleBirths`
`labour_delivery`.`MultipleBirths`
`minimum_stick_drugs`.*
`minimum_stick_drugs`.`Id`
`minimum_stick_drugs`.`DrugstoreId`
`minimum_stick_drugs`.`TreatmentId`
`minimum_stick_drugs`.`TreatmentCount`
`minimum_stick_drugs`.`UserEditedId`
`minimum_stick_drugs`.`DateTimeEditRecord`
`minimum_stick_drugs`.`IsRemoved`
`minimum_stick_drugs`.`MonthlyFactor`
`options`.*
`options`.`Id`
`options`.`UserId`
`options`.`Name`
`options`.`Value`
`patient_numbers_per_days`.*
`patient_numbers_per_days`.`Id`
`patient_numbers_per_days`.`Date`
`patient_numbers_per_days`.`Number1_1`
`patient_numbers_per_days`.`Number1_2`
`patient_numbers_per_days`.`Number2_1`
`patient_numbers_per_days`.`Number2_2`
`patient_numbers_per_days`.`Number3_1`
`patient_numbers_per_days`.`Number3_2`
`patient_numbers_per_days`.`Number4_1`
`patient_numbers_per_days`.`Number4_2`
`patient_numbers_per_days`.`Number5_1`
`patient_numbers_per_days`.`Number5_2`
`patient_numbers_per_days`.`Number6_1`
`patient_numbers_per_days`.`Number6_2`
`patient_numbers_per_days`.`IsRemoved`
`patient_properties_items`.*
`patient_properties_items`.`id`
`patient_properties_items`.`Name`
`patient_properties_items`.`isRemoved`
`patient_properties_items`.`PhoneNumber`
`patient_properties_items`.`TownId`
`patient_properties_items`.`BPTop`
`patient_properties_items`.`BPBottom`
`patient_properties_items`.`Temperature`
`patient_properties_items`.`Pulse`
`patient_properties_items`.`PatientStatus`
`patient_properties_items`.`PatientType`
`patient_properties_items`.`PatientStatusForInpatient`
`patient_properties_items`.`DateOfDischarge`
`patient_properties_items`.`HBResult`
`patient_properties_items`.`BFResult`
`patient_properties_items`.`WBCResult`
`patient_properties_items`.`UrineResult`
`patient_properties_items`.`BMResult`
`patient_properties_items`.`VDRLResult`
`patient_properties_items`.`HCGResult`
`patient_properties_items`.`SickleCellsResult`
`patient_properties_items`.`AFBResult`
`patient_properties_items`.`CustomResultName`
`patient_properties_items`.`CustomResult`
`patient_properties_items`.`HeadOfCompound`
`patient_properties_items`.`BadDocStatus`
`patient_properties_items`.`NeedVerification`
`patient_properties_items`.`NeedVerificationText`
`patient_properties_items`.`NeedVerificationUserId`
`patient_properties_items`.`NeedVerificationDate`
`patient_properties_items`.`VerificationUserId`
`patient_properties_items`.`VerificationDate`
`patient_properties_items`.`Nationality`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`Name`
`pharmacies`.`isRemoved`
`plan_inventory_items`.*
`plan_inventory_items`.`Id`
`plan_inventory_items`.`PlanInventoryId`
`plan_inventory_items`.`TreatmentId`
`plan_inventory_items`.`IsRemoved`
`plan_inventorys`.*
`plan_inventorys`.`Id`
`plan_inventorys`.`Date`
`plan_inventorys`.`DrugstoreId`
`plan_inventorys`.`IsPartial`
`plan_inventorys`.`IsRemoved`
`price_items`.*
`price_items`.`Id`
`price_items`.`Name`
`price_items`.`PriceItemType`
`price_items`.`LabTestType`
`price_items`.`NoAgeRestriction`
`price_items`.`AgeFrom`
`price_items`.`AgeTill`
`price_items`.`ForGambiansSum`
`price_items`.`ForNotGambiansSum`
`price_items`.`PriceId`
`price_items`.`isRemoved`
`prices`.*
`prices`.`Id`
`prices`.`Name`
`prices`.`Date`
`prices`.`isRemoved`
`purchasing_pharmacies`.*
`purchasing_pharmacies`.`Id`
`purchasing_pharmacies`.`Name`
`purchasing_pharmacies`.`isRemoved`
`purchasing_pharmacies`.`Address`
`purchasing_pharmacies`.`Phone`
`purchasing_pharmacies`.`Email`
`purchasing_pharmacies`.`ContactPerson`
`purchasing_pharmacies`.`PhoneOfContactPerson`
`purchasing_pharmacies`.`EmailOfContactPerson`
`state_items`.*
`state_items`.`Id`
`state_items`.`Years`
`state_items`.`Sex`
`state_items`.`Date`
`state_items`.`PatientId`
`state_items`.`IllnessId`
`state_items`.`TreatmentId`
`state_items`.`EmployeeId`
`state_items`.`IsRemoved`
`state_items`.`AgeGroupId`
`state_items`.`UserId`
`state_items`.`PatientNumber`
`state_items`.`AgeMonths`
`state_items`.`DateTimeRecordUser`
`state_items`.`TreatmentPerDay`
`state_items`.`TreatmentHowManyDays`
`state_items`.`TreatmentCount`
`state_items`.`PatientPropertiesItemId`
`towns`.*
`towns`.`id`
`towns`.`Name`
`towns`.`isRemoved`
`towns`.`Distance`
`transfer_drug_items`.*
`transfer_drug_items`.`Id`
`transfer_drug_items`.`TransferDrugId`
`transfer_drug_items`.`TreatmentId`
`transfer_drug_items`.`TreatmentCount`
`transfer_drug_items`.`TreatmentReceivedCount`
`transfer_drug_items`.`ReasonOfDifference`
`transfer_drug_items`.`IsRemoved`
`transfer_drugs`.*
`transfer_drugs`.`Id`
`transfer_drugs`.`Date`
`transfer_drugs`.`DrugstoreToId`
`transfer_drugs`.`DrugstoreFromId`
`transfer_drugs`.`DateOfReceipt`
`transfer_drugs`.`DocumentFileName`
`transfer_drugs`.`IsRemoved`
`treatment_application_aliases`.*
`treatment_application_aliases`.`Id`
`treatment_application_aliases`.`Name`
`treatment_application_aliases`.`TreatmentApplicationId`
`treatment_application_aliases`.`IsRemoved`
`treatment_application_dosage_groups`.*
`treatment_application_dosage_groups`.`Id`
`treatment_application_dosage_groups`.`TreatmentApplicationId`
`treatment_application_dosage_groups`.`IsRemoved`
`treatment_application_dosages`.*
`treatment_application_dosages`.`Id`
`treatment_application_dosages`.`TreatmentApplicationDosageGroupId`
`treatment_application_dosages`.`PatientAgeType`
`treatment_application_dosages`.`AgeFrom`
`treatment_application_dosages`.`AgeTill`
`treatment_application_dosages`.`AgeMonthsFrom`
`treatment_application_dosages`.`AgeMonthsTill`
`treatment_application_dosages`.`DurationInDays`
`treatment_application_dosages`.`DosagePerDay`
`treatment_application_dosages`.`DurationInDaysMin`
`treatment_application_dosages`.`DosagePerDayMin`
`treatment_application_dosages`.`IsRemoved`
`treatment_application_illnesses`.*
`treatment_application_illnesses`.`Id`
`treatment_application_illnesses`.`TreatmentApplicationDosageGroupId`
`treatment_application_illnesses`.`IllnessId`
`treatment_application_illnesses`.`IsRemoved`
`treatment_applications`.*
`treatment_applications`.`Id`
`treatment_applications`.`TreatmentId`
`treatment_applications`.`TreatmentFormId`
`treatment_applications`.`TreatmentFormValueId`
`treatment_applications`.`TreatmentClassificationId`
`treatment_applications`.`Strength`
`treatment_applications`.`IsForbiddenForMen`
`treatment_applications`.`IsForbiddenForWomen`
`treatment_applications`.`IsForbiddenForBreastfeedingWomen`
`treatment_applications`.`IsPregnancy`
`treatment_applications`.`PregnancyMonthsFrom`
`treatment_applications`.`PregnancyMonthsTill`
`treatment_applications`.`IsOnlyKids`
`treatment_applications`.`KidAgeYearFrom`
`treatment_applications`.`KidAgeYearTill`
`treatment_applications`.`KidAgeMonthFrom`
`treatment_applications`.`KidAgeMonthTill`
`treatment_applications`.`Adults`
`treatment_applications`.`AdultsTreatmentsPerDay`
`treatment_applications`.`AdultsTreatmentManyDays`
`treatment_applications`.`IsRemoved`
`treatment_classifications`.*
`treatment_classifications`.`Id`
`treatment_classifications`.`Name`
`treatment_classifications`.`IsRemoved`
`treatment_form_values`.*
`treatment_form_values`.`Id`
`treatment_form_values`.`Name`
`treatment_form_values`.`IsRemoved`
`treatment_forms`.*
`treatment_forms`.`Id`
`treatment_forms`.`Name`
`treatment_forms`.`IsRemoved`
`treatment_types`.*
`treatment_types`.`Id`
`treatment_types`.`Name`
`treatment_types`.`IsRemoved`
`treatments`.*
`treatments`.`Id`
`treatments`.`Name`
`treatments`.`isRemoved`
`treatments`.`TreatmentTypeId`
`treatments`.`PackingSize`
`tribes`.*
`tribes`.`id`
`tribes`.`Name`
`tribes`.`isRemoved`
`urine_lab_test_results`.*
`urine_lab_test_results`.`Id`
`urine_lab_test_results`.`IsRemoved`
`urine_lab_test_results`.`UrineLabTestType`
`urine_lab_test_results`.`Result`
`urine_lab_test_results`.`PatientPropertiesItemId`
`users`.*
`users`.`Id`
`users`.`Name`
`users`.`Password`
`users`.`isRemoved`
`users`.`isAdmin`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
age_groups
backup_log
board_association_stat_pages
buy_drug_items
buy_drugs
calendar_items
data_sent_from_projects
drugstores
employees
family_planning_services
gm_stat_pages
illnesses
inventory_items
inventorys
labour_delivery
minimum_stick_drugs
options
patient_numbers_per_days
patient_properties_items
pharmacies
plan_inventory_items
plan_inventorys
price_items
prices
purchasing_pharmacies
state_items
towns
transfer_drug_items
transfer_drugs
treatment_application_aliases
treatment_application_dosage_groups
treatment_application_dosages
treatment_application_illnesses
treatment_applications
treatment_classifications
treatment_form_values
treatment_forms
treatment_types
treatments
tribes
urine_lab_test_results
users
SQL query on database
axiuss40_africa_patient_program_bk
: