Recent
`task_manager`.`board_members`
`task_manager`.`employee_miscellaneous`
`axiuss40_africa_money_program_private_german`.`user_settings`
`performance_schema`.`session_connect_attrs`
`axiuss40_africa_patient_program_bk`.`users`
`task_manager`.`nationalities`
`axiuss40_africa_charity_program`.`settings`
`axiuss40_africa_patient_program`.`report_word`
`axiuss40_africa_patient_program`.`tribes`
`axiuss40_africa_charity_program`.`booking_splits`
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
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:
`alias_names`.*
`alias_names`.`id`
`alias_names`.`medicine_id`
`alias_names`.`treatment_id`
`alias_names`.`title`
`alias_names`.`status`
`alias_names`.`deleted`
`alias_names`.`addedOn`
`alias_names`.`addedBy`
`alias_names`.`modifiedBy`
`alias_names`.`modifiedOn`
`ante_natal_cares`.*
`ante_natal_cares`.`id`
`ante_natal_cares`.`name`
`ante_natal_cares`.`status`
`ante_natal_cares`.`deleted`
`ante_natal_cares`.`addedOn`
`ante_natal_cares`.`addedBy`
`ante_natal_cares`.`modifiedBy`
`ante_natal_cares`.`modifiedOn`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`status`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`date`
`deliveries`.`name_of_mother`
`deliveries`.`age_of_mother`
`deliveries`.`phone_no`
`deliveries`.`nationality`
`deliveries`.`village_id`
`deliveries`.`tribe_id`
`deliveries`.`ante_natal_care_ids`
`deliveries`.`post_natal_care_ids`
`deliveries`.`baby_number`
`deliveries`.`baby_gender`
`deliveries`.`baby_length`
`deliveries`.`baby_weight`
`deliveries`.`delivery_type`
`deliveries`.`is_multiple_birth`
`deliveries`.`multiple_birth_count`
`deliveries`.`newborn_condition`
`deliveries`.`employee_id`
`deliveries`.`is_bad_handwriting`
`deliveries`.`is_scanned_document`
`deliveries`.`is_verification_needed`
`deliveries`.`verification_text`
`deliveries`.`checked`
`deliveries`.`document_file`
`deliveries`.`status`
`deliveries`.`deleted`
`deliveries`.`addedOn`
`deliveries`.`addedBy`
`deliveries`.`modifiedBy`
`deliveries`.`modifiedOn`
`drug_inventory_batches`.*
`drug_inventory_batches`.`id`
`drug_inventory_batches`.`store_id`
`drug_inventory_batches`.`date`
`drug_inventory_batches`.`file_name`
`drug_inventory_batches`.`addedBy`
`drug_inventory_batches`.`addedOn`
`drug_inventory_batches`.`status`
`drug_inventory_batches`.`deleted`
`drug_inventory_batches`.`done_by`
`drug_inventory_batches`.`entered_by`
`drug_inventory_batches`.`is_confirm`
`drug_inventory_batches`.`confirm_file_name`
`drugs_inventories`.*
`drugs_inventories`.`id`
`drugs_inventories`.`batch_id`
`drugs_inventories`.`store_id`
`drugs_inventories`.`medicine_id`
`drugs_inventories`.`date`
`drugs_inventories`.`calculated`
`drugs_inventories`.`counted`
`drugs_inventories`.`expired`
`drugs_inventories`.`available`
`drugs_inventories`.`status`
`drugs_inventories`.`deleted`
`drugs_inventories`.`addedOn`
`drugs_inventories`.`addedBy`
`drugs_inventories`.`modifiedBy`
`drugs_inventories`.`modifiedOn`
`drugs_purchase_files`.*
`drugs_purchase_files`.`id`
`drugs_purchase_files`.`drug_store_id`
`drugs_purchase_files`.`pharmacy_id`
`drugs_purchase_files`.`date`
`drugs_purchase_files`.`file`
`drugs_purchase_files`.`status`
`drugs_purchase_files`.`deleted`
`drugs_purchase_files`.`addedOn`
`drugs_purchase_files`.`addedBy`
`drugs_purchase_files`.`modifiedBy`
`drugs_purchase_files`.`modifiedOn`
`drugs_purchase_items`.*
`drugs_purchase_items`.`id`
`drugs_purchase_items`.`drugs_purchase_id`
`drugs_purchase_items`.`drug_store_id`
`drugs_purchase_items`.`medicine_id`
`drugs_purchase_items`.`pharmacy_id`
`drugs_purchase_items`.`quantity`
`drugs_purchase_items`.`final_qty`
`drugs_purchase_items`.`price`
`drugs_purchase_items`.`date`
`drugs_purchase_items`.`status`
`drugs_purchase_items`.`deleted`
`drugs_purchase_items`.`addedOn`
`drugs_purchase_items`.`addedBy`
`drugs_purchase_items`.`modifiedBy`
`drugs_purchase_items`.`modifiedOn`
`drugs_purchases`.*
`drugs_purchases`.`id`
`drugs_purchases`.`drug_store_id`
`drugs_purchases`.`date`
`drugs_purchases`.`status`
`drugs_purchases`.`deleted`
`drugs_purchases`.`addedOn`
`drugs_purchases`.`addedBy`
`drugs_purchases`.`modifiedBy`
`drugs_purchases`.`modifiedOn`
`drugs_quotation_dates`.*
`drugs_quotation_dates`.`id`
`drugs_quotation_dates`.`drug_store_id`
`drugs_quotation_dates`.`date`
`drugs_quotation_dates`.`status`
`drugs_quotation_dates`.`deleted`
`drugs_quotation_dates`.`addedOn`
`drugs_quotation_dates`.`addedBy`
`drugs_quotation_dates`.`modifiedBy`
`drugs_quotation_dates`.`modifiedOn`
`drugs_quotation_files`.*
`drugs_quotation_files`.`id`
`drugs_quotation_files`.`drug_store_id`
`drugs_quotation_files`.`pharmacy_id`
`drugs_quotation_files`.`date`
`drugs_quotation_files`.`file`
`drugs_quotation_files`.`status`
`drugs_quotation_files`.`deleted`
`drugs_quotation_files`.`addedOn`
`drugs_quotation_files`.`addedBy`
`drugs_quotation_files`.`modifiedBy`
`drugs_quotation_files`.`modifiedOn`
`drugs_quotations`.*
`drugs_quotations`.`id`
`drugs_quotations`.`drugs_quotation_date_id`
`drugs_quotations`.`pharamacy_ids`
`drugs_quotations`.`medicine_id`
`drugs_quotations`.`quantity`
`drugs_quotations`.`final_quantity`
`drugs_quotations`.`checked`
`drugs_quotations`.`price_per_qty`
`drugs_quotations`.`quotation_date`
`drugs_quotations`.`price`
`drugs_quotations`.`choose_pharmacy`
`drugs_quotations`.`is_approved`
`drugs_quotations`.`status`
`drugs_quotations`.`deleted`
`drugs_quotations`.`addedOn`
`drugs_quotations`.`addedBy`
`drugs_quotations`.`modifiedBy`
`drugs_quotations`.`modifiedOn`
`drugs_total_count`.*
`drugs_total_count`.`id`
`drugs_total_count`.`drug_store_id`
`drugs_total_count`.`medicine_id`
`drugs_total_count`.`total`
`drugs_total_count`.`status`
`drugs_total_count`.`deleted`
`drugs_total_count`.`addedOn`
`drugs_total_count`.`addedBy`
`drugs_total_count`.`modifiedBy`
`drugs_total_count`.`modifiedOn`
`drugs_transfers`.*
`drugs_transfers`.`id`
`drugs_transfers`.`from_store`
`drugs_transfers`.`to_store`
`drugs_transfers`.`document`
`drugs_transfers`.`transfer_date`
`drugs_transfers`.`DateOfReceipt`
`drugs_transfers`.`status`
`drugs_transfers`.`deleted`
`drugs_transfers`.`addedOn`
`drugs_transfers`.`addedBy`
`drugs_transfers`.`modifiedBy`
`drugs_transfers`.`modifiedOn`
`drugs_transfers`.`done_by`
`drugs_transfers`.`entered_by`
`drugs_transfers`.`is_confirm`
`drugs_transfers`.`confirm_file_name`
`drugs_transfers_medicine_details`.*
`drugs_transfers_medicine_details`.`id`
`drugs_transfers_medicine_details`.`drug_transfer_id`
`drugs_transfers_medicine_details`.`from_store_id`
`drugs_transfers_medicine_details`.`to_store_id`
`drugs_transfers_medicine_details`.`medicine_id`
`drugs_transfers_medicine_details`.`amount`
`drugs_transfers_medicine_details`.`transfer_date`
`drugs_transfers_medicine_details`.`status`
`drugs_transfers_medicine_details`.`deleted`
`drugs_transfers_medicine_details`.`addedOn`
`drugs_transfers_medicine_details`.`addedBy`
`drugs_transfers_medicine_details`.`modifiedBy`
`drugs_transfers_medicine_details`.`modifiedOn`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`title`
`drugstores`.`checked`
`drugstores`.`small_pharamacy`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`drugstores`.`status`
`drugstores`.`deleted`
`drugstores`.`addedOn`
`drugstores`.`addedBy`
`drugstores`.`modifiedBy`
`drugstores`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`employee_role_id`
`employees`.`email`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`family_planning_services`.*
`family_planning_services`.`id`
`family_planning_services`.`date`
`family_planning_services`.`name_of_patient`
`family_planning_services`.`age_of_patient`
`family_planning_services`.`phone_no`
`family_planning_services`.`gender`
`family_planning_services`.`nationality`
`family_planning_services`.`village_id`
`family_planning_services`.`tribe_id`
`family_planning_services`.`new_acceptor_ids`
`family_planning_services`.`revisit_ids`
`family_planning_services`.`employee_id`
`family_planning_services`.`is_counselled_only`
`family_planning_services`.`is_bad_handwriting`
`family_planning_services`.`is_scanned_document`
`family_planning_services`.`is_verification_needed`
`family_planning_services`.`verification_text`
`family_planning_services`.`checked`
`family_planning_services`.`document_file`
`family_planning_services`.`status`
`family_planning_services`.`deleted`
`family_planning_services`.`addedOn`
`family_planning_services`.`addedBy`
`family_planning_services`.`modifiedBy`
`family_planning_services`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`governmental_statistics_settings`.*
`governmental_statistics_settings`.`id`
`governmental_statistics_settings`.`Name`
`governmental_statistics_settings`.`ShortName`
`governmental_statistics_settings`.`IsEnabledIllnesses`
`governmental_statistics_settings`.`IllnessIdsStr`
`governmental_statistics_settings`.`IsEnabledTreatments`
`governmental_statistics_settings`.`TreatmentsIdsStr`
`governmental_statistics_settings`.`UseAgeSettings`
`governmental_statistics_settings`.`AgeType`
`governmental_statistics_settings`.`AgeFromOver`
`governmental_statistics_settings`.`FromAgeYears`
`governmental_statistics_settings`.`TillAgeYears`
`governmental_statistics_settings`.`UnderYears`
`governmental_statistics_settings`.`OverYears`
`governmental_statistics_settings`.`PatientTypeForStat`
`governmental_statistics_settings`.`UseReasonForDismissal`
`governmental_statistics_settings`.`IsReferral`
`governmental_statistics_settings`.`IsDeath`
`governmental_statistics_settings`.`status`
`governmental_statistics_settings`.`deleted`
`governmental_statistics_settings`.`addedBy`
`governmental_statistics_settings`.`modifiedBy`
`governmental_statistics_settings`.`addedOn`
`governmental_statistics_settings`.`modifiedOn`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`title`
`illnesses`.`checked`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses_dosages`.*
`illnesses_dosages`.`id`
`illnesses_dosages`.`treatment_id`
`illnesses_dosages`.`illness_id`
`illnesses_dosages`.`age`
`illnesses_dosages`.`age_from`
`illnesses_dosages`.`age_till`
`illnesses_dosages`.`duration_per_days`
`illnesses_dosages`.`duration_in_days`
`illnesses_dosages`.`total`
`illnesses_dosages`.`status`
`illnesses_dosages`.`deleted`
`illnesses_dosages`.`addedOn`
`illnesses_dosages`.`addedBy`
`illnesses_dosages`.`modifiedBy`
`illnesses_dosages`.`modifiedOn`
`item_categories`.*
`item_categories`.`id`
`item_categories`.`name`
`item_categories`.`status`
`item_categories`.`deleted`
`item_categories`.`addedOn`
`item_categories`.`addedBy`
`item_categories`.`modifiedBy`
`item_categories`.`modifiedOn`
`lab_types`.*
`lab_types`.`id`
`lab_types`.`name`
`lab_types`.`status`
`lab_types`.`deleted`
`lab_types`.`addedOn`
`lab_types`.`addedBy`
`lab_types`.`modifiedBy`
`lab_types`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`login_records`.`user_id`
`medicine_pack_types`.*
`medicine_pack_types`.`id`
`medicine_pack_types`.`name`
`medicine_pack_types`.`status`
`medicine_pack_types`.`deleted`
`medicine_pack_types`.`addedOn`
`medicine_pack_types`.`addedBy`
`medicine_pack_types`.`modifiedBy`
`medicine_pack_types`.`modifiedOn`
`medicine_types`.*
`medicine_types`.`id`
`medicine_types`.`title`
`medicine_types`.`status`
`medicine_types`.`deleted`
`medicine_types`.`addedBy`
`medicine_types`.`modifiedBy`
`medicine_types`.`addedOn`
`medicine_types`.`modifiedOn`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`medicine_pack_type_id`
`medicines`.`packing_size`
`medicines`.`status`
`medicines`.`deleted`
`medicines`.`addedOn`
`medicines`.`addedBy`
`medicines`.`modifiedBy`
`medicines`.`modifiedOn`
`medicines`.`category_type`
`medicines`.`monthly_required_quantity`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`new_acceptors`.*
`new_acceptors`.`id`
`new_acceptors`.`name`
`new_acceptors`.`status`
`new_acceptors`.`deleted`
`new_acceptors`.`addedOn`
`new_acceptors`.`addedBy`
`new_acceptors`.`modifiedBy`
`new_acceptors`.`modifiedOn`
`outside_purchase_drugs`.*
`outside_purchase_drugs`.`id`
`outside_purchase_drugs`.`document`
`outside_purchase_drugs`.`transfer_date`
`outside_purchase_drugs`.`status`
`outside_purchase_drugs`.`deleted`
`outside_purchase_drugs`.`addedOn`
`outside_purchase_drugs`.`addedBy`
`outside_purchase_drugs`.`modifiedBy`
`outside_purchase_drugs`.`modifiedOn`
`outside_purchase_drugs_details`.*
`outside_purchase_drugs_details`.`id`
`outside_purchase_drugs_details`.`outside_purchase_drug_id`
`outside_purchase_drugs_details`.`medicine_id`
`outside_purchase_drugs_details`.`quantity`
`outside_purchase_drugs_details`.`price`
`outside_purchase_drugs_details`.`pharmacy_id`
`outside_purchase_drugs_details`.`transfer_date`
`outside_purchase_drugs_details`.`status`
`outside_purchase_drugs_details`.`deleted`
`outside_purchase_drugs_details`.`addedOn`
`outside_purchase_drugs_details`.`addedBy`
`outside_purchase_drugs_details`.`modifiedBy`
`outside_purchase_drugs_details`.`modifiedOn`
`patient_file_assigns`.*
`patient_file_assigns`.`id`
`patient_file_assigns`.`patient_file_id`
`patient_file_assigns`.`user_id`
`patient_file_assigns`.`addedOn`
`patient_file_folders`.*
`patient_file_folders`.`id`
`patient_file_folders`.`folder_name`
`patient_file_folders`.`folder_path`
`patient_file_folders`.`modifiedBy`
`patient_file_folders`.`modifiedOn`
`patient_file_folders`.`status`
`patient_file_folders`.`deleted`
`patient_file_folders`.`addedOn`
`patient_file_folders`.`addedBy`
`patient_files`.*
`patient_files`.`id`
`patient_files`.`patient_file_folder_id`
`patient_files`.`patient_property_id`
`patient_files`.`file_orginal_name`
`patient_files`.`file_name`
`patient_files`.`file_size`
`patient_files`.`file_path`
`patient_files`.`extension`
`patient_files`.`type`
`patient_files`.`status`
`patient_files`.`deleted`
`patient_files`.`addedOn`
`patient_files`.`addedBy`
`patient_files`.`modifiedBy`
`patient_files`.`modifiedOn`
`patient_numbers`.*
`patient_numbers`.`id`
`patient_numbers`.`start_number`
`patient_numbers`.`end_number`
`patient_numbers`.`addedBy`
`patient_numbers`.`addedOn`
`patient_numbers`.`modifiedBy`
`patient_numbers`.`modifiedOn`
`patient_numbers`.`date`
`patient_properties`.*
`patient_properties`.`id`
`patient_properties`.`date`
`patient_properties`.`patientNumber`
`patient_properties`.`phone_no`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`nationality`
`patient_properties`.`village_id`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`patient_properties`.`patientStatus`
`patient_properties`.`patientType`
`patient_properties`.`patientStatusForInpatient`
`patient_properties`.`dateOfAdmission`
`patient_properties`.`dateOfDischarge`
`patient_properties`.`reasonOfDismisal`
`patient_properties`.`HBResult`
`patient_properties`.`BFResult`
`patient_properties`.`WBCResult`
`patient_properties`.`UrineResult`
`patient_properties`.`BMResult`
`patient_properties`.`VDRLResult`
`patient_properties`.`HCGResult`
`patient_properties`.`SickleCellsResult`
`patient_properties`.`AFBResult`
`patient_properties`.`CustomResultName`
`patient_properties`.`CustomResult`
`patient_properties`.`badDocStatus`
`patient_properties`.`employee_id`
`patient_properties`.`is_bad_handwriting`
`patient_properties`.`is_scanned_document`
`patient_properties`.`is_verification_needed`
`patient_properties`.`verification_text`
`patient_properties`.`document_file`
`patient_properties`.`status`
`patient_properties`.`deleted`
`patient_properties`.`addedBy`
`patient_properties`.`modifiedBy`
`patient_properties`.`addedOn`
`patient_properties`.`modifiedOn`
`patient_property_tratment_details`.*
`patient_property_tratment_details`.`id`
`patient_property_tratment_details`.`medicine_id`
`patient_property_tratment_details`.`per_day`
`patient_property_tratment_details`.`times`
`patient_property_tratment_details`.`total`
`patient_property_tratment_details`.`patient_property_item_id`
`patient_property_urine_lab_test_results`.*
`patient_property_urine_lab_test_results`.`id`
`patient_property_urine_lab_test_results`.`urine_lab_test_type_id`
`patient_property_urine_lab_test_results`.`result`
`patient_property_urine_lab_test_results`.`patient_property_item_id`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`priority`
`pharmacies`.`name`
`pharmacies`.`address`
`pharmacies`.`phone`
`pharmacies`.`email`
`pharmacies`.`contact_person_name`
`pharmacies`.`contact_person_phone`
`pharmacies`.`contact_person_email`
`pharmacies`.`bank_name`
`pharmacies`.`bank_account`
`pharmacies`.`bank_iban`
`pharmacies`.`status`
`pharmacies`.`deleted`
`pharmacies`.`addedOn`
`pharmacies`.`addedBy`
`pharmacies`.`modifiedBy`
`pharmacies`.`modifiedOn`
`post_natal_cares`.*
`post_natal_cares`.`id`
`post_natal_cares`.`name`
`post_natal_cares`.`status`
`post_natal_cares`.`deleted`
`post_natal_cares`.`addedOn`
`post_natal_cares`.`addedBy`
`post_natal_cares`.`modifiedBy`
`post_natal_cares`.`modifiedOn`
`price_details`.*
`price_details`.`id`
`price_details`.`price_id`
`price_details`.`name`
`price_details`.`type`
`price_details`.`lab_type_id`
`price_details`.`age_from`
`price_details`.`age_till`
`price_details`.`gambians_price`
`price_details`.`non_gambians_price`
`price_details`.`status`
`price_details`.`deleted`
`price_details`.`addedOn`
`price_details`.`addedBy`
`price_details`.`modifiedBy`
`price_details`.`modifiedOn`
`prices`.*
`prices`.`id`
`prices`.`date`
`prices`.`status`
`prices`.`deleted`
`prices`.`addedOn`
`prices`.`addedBy`
`prices`.`modifiedBy`
`prices`.`modifiedOn`
`report_word`.*
`report_word`.`id`
`report_word`.`text`
`report_word`.`status`
`report_word`.`deleted`
`report_word`.`addedOn`
`report_word`.`addedBy`
`report_word`.`modifiedBy`
`report_word`.`modifiedOn`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`revisits`.*
`revisits`.`id`
`revisits`.`name`
`revisits`.`status`
`revisits`.`deleted`
`revisits`.`addedOn`
`revisits`.`addedBy`
`revisits`.`modifiedBy`
`revisits`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`treatment_forms`.*
`treatment_forms`.`id`
`treatment_forms`.`name`
`treatment_forms`.`status`
`treatment_forms`.`deleted`
`treatment_forms`.`addedBy`
`treatment_forms`.`modifiedBy`
`treatment_forms`.`addedOn`
`treatment_forms`.`modifiedOn`
`treatment_illnesses`.*
`treatment_illnesses`.`id`
`treatment_illnesses`.`treatment_id`
`treatment_illnesses`.`illness`
`treatment_illnesses`.`status`
`treatment_illnesses`.`deleted`
`treatment_illnesses`.`addedOn`
`treatment_illnesses`.`addedBy`
`treatment_illnesses`.`modifiedBy`
`treatment_illnesses`.`modifiedOn`
`treatment_ins`.*
`treatment_ins`.`id`
`treatment_ins`.`name`
`treatment_ins`.`status`
`treatment_ins`.`deleted`
`treatment_ins`.`addedBy`
`treatment_ins`.`modifiedBy`
`treatment_ins`.`addedOn`
`treatment_ins`.`modifiedOn`
`treatments`.*
`treatments`.`id`
`treatments`.`medicine_id`
`treatments`.`packsize`
`treatments`.`form`
`treatments`.`strength`
`treatments`.`strength_in`
`treatments`.`male`
`treatments`.`female`
`treatments`.`breast_feeding`
`treatments`.`pregnant`
`treatments`.`from_month`
`treatments`.`till_month`
`treatments`.`only_kids`
`treatments`.`kid_year_from`
`treatments`.`kid_month_from`
`treatments`.`kid_year_till`
`treatments`.`kid_month_till`
`treatments`.`belongs_to`
`treatments`.`alias_names`
`treatments`.`illnesses`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`modifiedOn`
`treatments`.`max_dosage`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`urine_lab_test_types`.*
`urine_lab_test_types`.`id`
`urine_lab_test_types`.`name`
`urine_lab_test_types`.`status`
`urine_lab_test_types`.`deleted`
`urine_lab_test_types`.`addedOn`
`urine_lab_test_types`.`addedBy`
`urine_lab_test_types`.`modifiedBy`
`urine_lab_test_types`.`modifiedOn`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`status`
`warehouses`.`deleted`
`warehouses`.`addedOn`
`warehouses`.`addedBy`
`warehouses`.`modifiedBy`
`warehouses`.`modifiedOn`
`alias_names`.*
`alias_names`.`id`
`alias_names`.`medicine_id`
`alias_names`.`treatment_id`
`alias_names`.`title`
`alias_names`.`status`
`alias_names`.`deleted`
`alias_names`.`addedOn`
`alias_names`.`addedBy`
`alias_names`.`modifiedBy`
`alias_names`.`modifiedOn`
`ante_natal_cares`.*
`ante_natal_cares`.`id`
`ante_natal_cares`.`name`
`ante_natal_cares`.`status`
`ante_natal_cares`.`deleted`
`ante_natal_cares`.`addedOn`
`ante_natal_cares`.`addedBy`
`ante_natal_cares`.`modifiedBy`
`ante_natal_cares`.`modifiedOn`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`status`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`date`
`deliveries`.`name_of_mother`
`deliveries`.`age_of_mother`
`deliveries`.`phone_no`
`deliveries`.`nationality`
`deliveries`.`village_id`
`deliveries`.`tribe_id`
`deliveries`.`ante_natal_care_ids`
`deliveries`.`post_natal_care_ids`
`deliveries`.`baby_number`
`deliveries`.`baby_gender`
`deliveries`.`baby_length`
`deliveries`.`baby_weight`
`deliveries`.`delivery_type`
`deliveries`.`is_multiple_birth`
`deliveries`.`multiple_birth_count`
`deliveries`.`newborn_condition`
`deliveries`.`employee_id`
`deliveries`.`is_bad_handwriting`
`deliveries`.`is_scanned_document`
`deliveries`.`is_verification_needed`
`deliveries`.`verification_text`
`deliveries`.`checked`
`deliveries`.`document_file`
`deliveries`.`status`
`deliveries`.`deleted`
`deliveries`.`addedOn`
`deliveries`.`addedBy`
`deliveries`.`modifiedBy`
`deliveries`.`modifiedOn`
`drug_inventory_batches`.*
`drug_inventory_batches`.`id`
`drug_inventory_batches`.`store_id`
`drug_inventory_batches`.`date`
`drug_inventory_batches`.`file_name`
`drug_inventory_batches`.`addedBy`
`drug_inventory_batches`.`addedOn`
`drug_inventory_batches`.`status`
`drug_inventory_batches`.`deleted`
`drug_inventory_batches`.`done_by`
`drug_inventory_batches`.`entered_by`
`drug_inventory_batches`.`is_confirm`
`drug_inventory_batches`.`confirm_file_name`
`drugs_inventories`.*
`drugs_inventories`.`id`
`drugs_inventories`.`batch_id`
`drugs_inventories`.`store_id`
`drugs_inventories`.`medicine_id`
`drugs_inventories`.`date`
`drugs_inventories`.`calculated`
`drugs_inventories`.`counted`
`drugs_inventories`.`expired`
`drugs_inventories`.`available`
`drugs_inventories`.`status`
`drugs_inventories`.`deleted`
`drugs_inventories`.`addedOn`
`drugs_inventories`.`addedBy`
`drugs_inventories`.`modifiedBy`
`drugs_inventories`.`modifiedOn`
`drugs_purchase_files`.*
`drugs_purchase_files`.`id`
`drugs_purchase_files`.`drug_store_id`
`drugs_purchase_files`.`pharmacy_id`
`drugs_purchase_files`.`date`
`drugs_purchase_files`.`file`
`drugs_purchase_files`.`status`
`drugs_purchase_files`.`deleted`
`drugs_purchase_files`.`addedOn`
`drugs_purchase_files`.`addedBy`
`drugs_purchase_files`.`modifiedBy`
`drugs_purchase_files`.`modifiedOn`
`drugs_purchase_items`.*
`drugs_purchase_items`.`id`
`drugs_purchase_items`.`drugs_purchase_id`
`drugs_purchase_items`.`drug_store_id`
`drugs_purchase_items`.`medicine_id`
`drugs_purchase_items`.`pharmacy_id`
`drugs_purchase_items`.`quantity`
`drugs_purchase_items`.`final_qty`
`drugs_purchase_items`.`price`
`drugs_purchase_items`.`date`
`drugs_purchase_items`.`status`
`drugs_purchase_items`.`deleted`
`drugs_purchase_items`.`addedOn`
`drugs_purchase_items`.`addedBy`
`drugs_purchase_items`.`modifiedBy`
`drugs_purchase_items`.`modifiedOn`
`drugs_purchases`.*
`drugs_purchases`.`id`
`drugs_purchases`.`drug_store_id`
`drugs_purchases`.`date`
`drugs_purchases`.`status`
`drugs_purchases`.`deleted`
`drugs_purchases`.`addedOn`
`drugs_purchases`.`addedBy`
`drugs_purchases`.`modifiedBy`
`drugs_purchases`.`modifiedOn`
`drugs_quotation_dates`.*
`drugs_quotation_dates`.`id`
`drugs_quotation_dates`.`drug_store_id`
`drugs_quotation_dates`.`date`
`drugs_quotation_dates`.`status`
`drugs_quotation_dates`.`deleted`
`drugs_quotation_dates`.`addedOn`
`drugs_quotation_dates`.`addedBy`
`drugs_quotation_dates`.`modifiedBy`
`drugs_quotation_dates`.`modifiedOn`
`drugs_quotation_files`.*
`drugs_quotation_files`.`id`
`drugs_quotation_files`.`drug_store_id`
`drugs_quotation_files`.`pharmacy_id`
`drugs_quotation_files`.`date`
`drugs_quotation_files`.`file`
`drugs_quotation_files`.`status`
`drugs_quotation_files`.`deleted`
`drugs_quotation_files`.`addedOn`
`drugs_quotation_files`.`addedBy`
`drugs_quotation_files`.`modifiedBy`
`drugs_quotation_files`.`modifiedOn`
`drugs_quotations`.*
`drugs_quotations`.`id`
`drugs_quotations`.`drugs_quotation_date_id`
`drugs_quotations`.`pharamacy_ids`
`drugs_quotations`.`medicine_id`
`drugs_quotations`.`quantity`
`drugs_quotations`.`final_quantity`
`drugs_quotations`.`checked`
`drugs_quotations`.`price_per_qty`
`drugs_quotations`.`quotation_date`
`drugs_quotations`.`price`
`drugs_quotations`.`choose_pharmacy`
`drugs_quotations`.`is_approved`
`drugs_quotations`.`status`
`drugs_quotations`.`deleted`
`drugs_quotations`.`addedOn`
`drugs_quotations`.`addedBy`
`drugs_quotations`.`modifiedBy`
`drugs_quotations`.`modifiedOn`
`drugs_total_count`.*
`drugs_total_count`.`id`
`drugs_total_count`.`drug_store_id`
`drugs_total_count`.`medicine_id`
`drugs_total_count`.`total`
`drugs_total_count`.`status`
`drugs_total_count`.`deleted`
`drugs_total_count`.`addedOn`
`drugs_total_count`.`addedBy`
`drugs_total_count`.`modifiedBy`
`drugs_total_count`.`modifiedOn`
`drugs_transfers`.*
`drugs_transfers`.`id`
`drugs_transfers`.`from_store`
`drugs_transfers`.`to_store`
`drugs_transfers`.`document`
`drugs_transfers`.`transfer_date`
`drugs_transfers`.`DateOfReceipt`
`drugs_transfers`.`status`
`drugs_transfers`.`deleted`
`drugs_transfers`.`addedOn`
`drugs_transfers`.`addedBy`
`drugs_transfers`.`modifiedBy`
`drugs_transfers`.`modifiedOn`
`drugs_transfers`.`done_by`
`drugs_transfers`.`entered_by`
`drugs_transfers`.`is_confirm`
`drugs_transfers`.`confirm_file_name`
`drugs_transfers_medicine_details`.*
`drugs_transfers_medicine_details`.`id`
`drugs_transfers_medicine_details`.`drug_transfer_id`
`drugs_transfers_medicine_details`.`from_store_id`
`drugs_transfers_medicine_details`.`to_store_id`
`drugs_transfers_medicine_details`.`medicine_id`
`drugs_transfers_medicine_details`.`amount`
`drugs_transfers_medicine_details`.`transfer_date`
`drugs_transfers_medicine_details`.`status`
`drugs_transfers_medicine_details`.`deleted`
`drugs_transfers_medicine_details`.`addedOn`
`drugs_transfers_medicine_details`.`addedBy`
`drugs_transfers_medicine_details`.`modifiedBy`
`drugs_transfers_medicine_details`.`modifiedOn`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`title`
`drugstores`.`checked`
`drugstores`.`small_pharamacy`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`drugstores`.`status`
`drugstores`.`deleted`
`drugstores`.`addedOn`
`drugstores`.`addedBy`
`drugstores`.`modifiedBy`
`drugstores`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`employee_role_id`
`employees`.`email`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`family_planning_services`.*
`family_planning_services`.`id`
`family_planning_services`.`date`
`family_planning_services`.`name_of_patient`
`family_planning_services`.`age_of_patient`
`family_planning_services`.`phone_no`
`family_planning_services`.`gender`
`family_planning_services`.`nationality`
`family_planning_services`.`village_id`
`family_planning_services`.`tribe_id`
`family_planning_services`.`new_acceptor_ids`
`family_planning_services`.`revisit_ids`
`family_planning_services`.`employee_id`
`family_planning_services`.`is_counselled_only`
`family_planning_services`.`is_bad_handwriting`
`family_planning_services`.`is_scanned_document`
`family_planning_services`.`is_verification_needed`
`family_planning_services`.`verification_text`
`family_planning_services`.`checked`
`family_planning_services`.`document_file`
`family_planning_services`.`status`
`family_planning_services`.`deleted`
`family_planning_services`.`addedOn`
`family_planning_services`.`addedBy`
`family_planning_services`.`modifiedBy`
`family_planning_services`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`governmental_statistics_settings`.*
`governmental_statistics_settings`.`id`
`governmental_statistics_settings`.`Name`
`governmental_statistics_settings`.`ShortName`
`governmental_statistics_settings`.`IsEnabledIllnesses`
`governmental_statistics_settings`.`IllnessIdsStr`
`governmental_statistics_settings`.`IsEnabledTreatments`
`governmental_statistics_settings`.`TreatmentsIdsStr`
`governmental_statistics_settings`.`UseAgeSettings`
`governmental_statistics_settings`.`AgeType`
`governmental_statistics_settings`.`AgeFromOver`
`governmental_statistics_settings`.`FromAgeYears`
`governmental_statistics_settings`.`TillAgeYears`
`governmental_statistics_settings`.`UnderYears`
`governmental_statistics_settings`.`OverYears`
`governmental_statistics_settings`.`PatientTypeForStat`
`governmental_statistics_settings`.`UseReasonForDismissal`
`governmental_statistics_settings`.`IsReferral`
`governmental_statistics_settings`.`IsDeath`
`governmental_statistics_settings`.`status`
`governmental_statistics_settings`.`deleted`
`governmental_statistics_settings`.`addedBy`
`governmental_statistics_settings`.`modifiedBy`
`governmental_statistics_settings`.`addedOn`
`governmental_statistics_settings`.`modifiedOn`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`title`
`illnesses`.`checked`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses_dosages`.*
`illnesses_dosages`.`id`
`illnesses_dosages`.`treatment_id`
`illnesses_dosages`.`illness_id`
`illnesses_dosages`.`age`
`illnesses_dosages`.`age_from`
`illnesses_dosages`.`age_till`
`illnesses_dosages`.`duration_per_days`
`illnesses_dosages`.`duration_in_days`
`illnesses_dosages`.`total`
`illnesses_dosages`.`status`
`illnesses_dosages`.`deleted`
`illnesses_dosages`.`addedOn`
`illnesses_dosages`.`addedBy`
`illnesses_dosages`.`modifiedBy`
`illnesses_dosages`.`modifiedOn`
`item_categories`.*
`item_categories`.`id`
`item_categories`.`name`
`item_categories`.`status`
`item_categories`.`deleted`
`item_categories`.`addedOn`
`item_categories`.`addedBy`
`item_categories`.`modifiedBy`
`item_categories`.`modifiedOn`
`lab_types`.*
`lab_types`.`id`
`lab_types`.`name`
`lab_types`.`status`
`lab_types`.`deleted`
`lab_types`.`addedOn`
`lab_types`.`addedBy`
`lab_types`.`modifiedBy`
`lab_types`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`login_records`.`user_id`
`medicine_pack_types`.*
`medicine_pack_types`.`id`
`medicine_pack_types`.`name`
`medicine_pack_types`.`status`
`medicine_pack_types`.`deleted`
`medicine_pack_types`.`addedOn`
`medicine_pack_types`.`addedBy`
`medicine_pack_types`.`modifiedBy`
`medicine_pack_types`.`modifiedOn`
`medicine_types`.*
`medicine_types`.`id`
`medicine_types`.`title`
`medicine_types`.`status`
`medicine_types`.`deleted`
`medicine_types`.`addedBy`
`medicine_types`.`modifiedBy`
`medicine_types`.`addedOn`
`medicine_types`.`modifiedOn`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`medicine_pack_type_id`
`medicines`.`packing_size`
`medicines`.`status`
`medicines`.`deleted`
`medicines`.`addedOn`
`medicines`.`addedBy`
`medicines`.`modifiedBy`
`medicines`.`modifiedOn`
`medicines`.`category_type`
`medicines`.`monthly_required_quantity`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`new_acceptors`.*
`new_acceptors`.`id`
`new_acceptors`.`name`
`new_acceptors`.`status`
`new_acceptors`.`deleted`
`new_acceptors`.`addedOn`
`new_acceptors`.`addedBy`
`new_acceptors`.`modifiedBy`
`new_acceptors`.`modifiedOn`
`outside_purchase_drugs`.*
`outside_purchase_drugs`.`id`
`outside_purchase_drugs`.`document`
`outside_purchase_drugs`.`transfer_date`
`outside_purchase_drugs`.`status`
`outside_purchase_drugs`.`deleted`
`outside_purchase_drugs`.`addedOn`
`outside_purchase_drugs`.`addedBy`
`outside_purchase_drugs`.`modifiedBy`
`outside_purchase_drugs`.`modifiedOn`
`outside_purchase_drugs_details`.*
`outside_purchase_drugs_details`.`id`
`outside_purchase_drugs_details`.`outside_purchase_drug_id`
`outside_purchase_drugs_details`.`medicine_id`
`outside_purchase_drugs_details`.`quantity`
`outside_purchase_drugs_details`.`price`
`outside_purchase_drugs_details`.`pharmacy_id`
`outside_purchase_drugs_details`.`transfer_date`
`outside_purchase_drugs_details`.`status`
`outside_purchase_drugs_details`.`deleted`
`outside_purchase_drugs_details`.`addedOn`
`outside_purchase_drugs_details`.`addedBy`
`outside_purchase_drugs_details`.`modifiedBy`
`outside_purchase_drugs_details`.`modifiedOn`
`patient_file_assigns`.*
`patient_file_assigns`.`id`
`patient_file_assigns`.`patient_file_id`
`patient_file_assigns`.`user_id`
`patient_file_assigns`.`addedOn`
`patient_file_folders`.*
`patient_file_folders`.`id`
`patient_file_folders`.`folder_name`
`patient_file_folders`.`folder_path`
`patient_file_folders`.`modifiedBy`
`patient_file_folders`.`modifiedOn`
`patient_file_folders`.`status`
`patient_file_folders`.`deleted`
`patient_file_folders`.`addedOn`
`patient_file_folders`.`addedBy`
`patient_files`.*
`patient_files`.`id`
`patient_files`.`patient_file_folder_id`
`patient_files`.`patient_property_id`
`patient_files`.`file_orginal_name`
`patient_files`.`file_name`
`patient_files`.`file_size`
`patient_files`.`file_path`
`patient_files`.`extension`
`patient_files`.`type`
`patient_files`.`status`
`patient_files`.`deleted`
`patient_files`.`addedOn`
`patient_files`.`addedBy`
`patient_files`.`modifiedBy`
`patient_files`.`modifiedOn`
`patient_numbers`.*
`patient_numbers`.`id`
`patient_numbers`.`start_number`
`patient_numbers`.`end_number`
`patient_numbers`.`addedBy`
`patient_numbers`.`addedOn`
`patient_numbers`.`modifiedBy`
`patient_numbers`.`modifiedOn`
`patient_numbers`.`date`
`patient_properties`.*
`patient_properties`.`id`
`patient_properties`.`date`
`patient_properties`.`patientNumber`
`patient_properties`.`phone_no`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`nationality`
`patient_properties`.`village_id`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`patient_properties`.`patientStatus`
`patient_properties`.`patientType`
`patient_properties`.`patientStatusForInpatient`
`patient_properties`.`dateOfAdmission`
`patient_properties`.`dateOfDischarge`
`patient_properties`.`reasonOfDismisal`
`patient_properties`.`HBResult`
`patient_properties`.`BFResult`
`patient_properties`.`WBCResult`
`patient_properties`.`UrineResult`
`patient_properties`.`BMResult`
`patient_properties`.`VDRLResult`
`patient_properties`.`HCGResult`
`patient_properties`.`SickleCellsResult`
`patient_properties`.`AFBResult`
`patient_properties`.`CustomResultName`
`patient_properties`.`CustomResult`
`patient_properties`.`badDocStatus`
`patient_properties`.`employee_id`
`patient_properties`.`is_bad_handwriting`
`patient_properties`.`is_scanned_document`
`patient_properties`.`is_verification_needed`
`patient_properties`.`verification_text`
`patient_properties`.`document_file`
`patient_properties`.`status`
`patient_properties`.`deleted`
`patient_properties`.`addedBy`
`patient_properties`.`modifiedBy`
`patient_properties`.`addedOn`
`patient_properties`.`modifiedOn`
`patient_property_tratment_details`.*
`patient_property_tratment_details`.`id`
`patient_property_tratment_details`.`medicine_id`
`patient_property_tratment_details`.`per_day`
`patient_property_tratment_details`.`times`
`patient_property_tratment_details`.`total`
`patient_property_tratment_details`.`patient_property_item_id`
`patient_property_urine_lab_test_results`.*
`patient_property_urine_lab_test_results`.`id`
`patient_property_urine_lab_test_results`.`urine_lab_test_type_id`
`patient_property_urine_lab_test_results`.`result`
`patient_property_urine_lab_test_results`.`patient_property_item_id`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`priority`
`pharmacies`.`name`
`pharmacies`.`address`
`pharmacies`.`phone`
`pharmacies`.`email`
`pharmacies`.`contact_person_name`
`pharmacies`.`contact_person_phone`
`pharmacies`.`contact_person_email`
`pharmacies`.`bank_name`
`pharmacies`.`bank_account`
`pharmacies`.`bank_iban`
`pharmacies`.`status`
`pharmacies`.`deleted`
`pharmacies`.`addedOn`
`pharmacies`.`addedBy`
`pharmacies`.`modifiedBy`
`pharmacies`.`modifiedOn`
`post_natal_cares`.*
`post_natal_cares`.`id`
`post_natal_cares`.`name`
`post_natal_cares`.`status`
`post_natal_cares`.`deleted`
`post_natal_cares`.`addedOn`
`post_natal_cares`.`addedBy`
`post_natal_cares`.`modifiedBy`
`post_natal_cares`.`modifiedOn`
`price_details`.*
`price_details`.`id`
`price_details`.`price_id`
`price_details`.`name`
`price_details`.`type`
`price_details`.`lab_type_id`
`price_details`.`age_from`
`price_details`.`age_till`
`price_details`.`gambians_price`
`price_details`.`non_gambians_price`
`price_details`.`status`
`price_details`.`deleted`
`price_details`.`addedOn`
`price_details`.`addedBy`
`price_details`.`modifiedBy`
`price_details`.`modifiedOn`
`prices`.*
`prices`.`id`
`prices`.`date`
`prices`.`status`
`prices`.`deleted`
`prices`.`addedOn`
`prices`.`addedBy`
`prices`.`modifiedBy`
`prices`.`modifiedOn`
`report_word`.*
`report_word`.`id`
`report_word`.`text`
`report_word`.`status`
`report_word`.`deleted`
`report_word`.`addedOn`
`report_word`.`addedBy`
`report_word`.`modifiedBy`
`report_word`.`modifiedOn`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`revisits`.*
`revisits`.`id`
`revisits`.`name`
`revisits`.`status`
`revisits`.`deleted`
`revisits`.`addedOn`
`revisits`.`addedBy`
`revisits`.`modifiedBy`
`revisits`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`treatment_forms`.*
`treatment_forms`.`id`
`treatment_forms`.`name`
`treatment_forms`.`status`
`treatment_forms`.`deleted`
`treatment_forms`.`addedBy`
`treatment_forms`.`modifiedBy`
`treatment_forms`.`addedOn`
`treatment_forms`.`modifiedOn`
`treatment_illnesses`.*
`treatment_illnesses`.`id`
`treatment_illnesses`.`treatment_id`
`treatment_illnesses`.`illness`
`treatment_illnesses`.`status`
`treatment_illnesses`.`deleted`
`treatment_illnesses`.`addedOn`
`treatment_illnesses`.`addedBy`
`treatment_illnesses`.`modifiedBy`
`treatment_illnesses`.`modifiedOn`
`treatment_ins`.*
`treatment_ins`.`id`
`treatment_ins`.`name`
`treatment_ins`.`status`
`treatment_ins`.`deleted`
`treatment_ins`.`addedBy`
`treatment_ins`.`modifiedBy`
`treatment_ins`.`addedOn`
`treatment_ins`.`modifiedOn`
`treatments`.*
`treatments`.`id`
`treatments`.`medicine_id`
`treatments`.`packsize`
`treatments`.`form`
`treatments`.`strength`
`treatments`.`strength_in`
`treatments`.`male`
`treatments`.`female`
`treatments`.`breast_feeding`
`treatments`.`pregnant`
`treatments`.`from_month`
`treatments`.`till_month`
`treatments`.`only_kids`
`treatments`.`kid_year_from`
`treatments`.`kid_month_from`
`treatments`.`kid_year_till`
`treatments`.`kid_month_till`
`treatments`.`belongs_to`
`treatments`.`alias_names`
`treatments`.`illnesses`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`modifiedOn`
`treatments`.`max_dosage`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`urine_lab_test_types`.*
`urine_lab_test_types`.`id`
`urine_lab_test_types`.`name`
`urine_lab_test_types`.`status`
`urine_lab_test_types`.`deleted`
`urine_lab_test_types`.`addedOn`
`urine_lab_test_types`.`addedBy`
`urine_lab_test_types`.`modifiedBy`
`urine_lab_test_types`.`modifiedOn`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`status`
`warehouses`.`deleted`
`warehouses`.`addedOn`
`warehouses`.`addedBy`
`warehouses`.`modifiedBy`
`warehouses`.`modifiedOn`
`alias_names`.*
`alias_names`.`id`
`alias_names`.`medicine_id`
`alias_names`.`treatment_id`
`alias_names`.`title`
`alias_names`.`status`
`alias_names`.`deleted`
`alias_names`.`addedOn`
`alias_names`.`addedBy`
`alias_names`.`modifiedBy`
`alias_names`.`modifiedOn`
`ante_natal_cares`.*
`ante_natal_cares`.`id`
`ante_natal_cares`.`name`
`ante_natal_cares`.`status`
`ante_natal_cares`.`deleted`
`ante_natal_cares`.`addedOn`
`ante_natal_cares`.`addedBy`
`ante_natal_cares`.`modifiedBy`
`ante_natal_cares`.`modifiedOn`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`status`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`date`
`deliveries`.`name_of_mother`
`deliveries`.`age_of_mother`
`deliveries`.`phone_no`
`deliveries`.`nationality`
`deliveries`.`village_id`
`deliveries`.`tribe_id`
`deliveries`.`ante_natal_care_ids`
`deliveries`.`post_natal_care_ids`
`deliveries`.`baby_number`
`deliveries`.`baby_gender`
`deliveries`.`baby_length`
`deliveries`.`baby_weight`
`deliveries`.`delivery_type`
`deliveries`.`is_multiple_birth`
`deliveries`.`multiple_birth_count`
`deliveries`.`newborn_condition`
`deliveries`.`employee_id`
`deliveries`.`is_bad_handwriting`
`deliveries`.`is_scanned_document`
`deliveries`.`is_verification_needed`
`deliveries`.`verification_text`
`deliveries`.`checked`
`deliveries`.`document_file`
`deliveries`.`status`
`deliveries`.`deleted`
`deliveries`.`addedOn`
`deliveries`.`addedBy`
`deliveries`.`modifiedBy`
`deliveries`.`modifiedOn`
`drug_inventory_batches`.*
`drug_inventory_batches`.`id`
`drug_inventory_batches`.`store_id`
`drug_inventory_batches`.`date`
`drug_inventory_batches`.`file_name`
`drug_inventory_batches`.`addedBy`
`drug_inventory_batches`.`addedOn`
`drug_inventory_batches`.`status`
`drug_inventory_batches`.`deleted`
`drug_inventory_batches`.`done_by`
`drug_inventory_batches`.`entered_by`
`drug_inventory_batches`.`is_confirm`
`drug_inventory_batches`.`confirm_file_name`
`drugs_inventories`.*
`drugs_inventories`.`id`
`drugs_inventories`.`batch_id`
`drugs_inventories`.`store_id`
`drugs_inventories`.`medicine_id`
`drugs_inventories`.`date`
`drugs_inventories`.`calculated`
`drugs_inventories`.`counted`
`drugs_inventories`.`expired`
`drugs_inventories`.`available`
`drugs_inventories`.`status`
`drugs_inventories`.`deleted`
`drugs_inventories`.`addedOn`
`drugs_inventories`.`addedBy`
`drugs_inventories`.`modifiedBy`
`drugs_inventories`.`modifiedOn`
`drugs_purchase_files`.*
`drugs_purchase_files`.`id`
`drugs_purchase_files`.`drug_store_id`
`drugs_purchase_files`.`pharmacy_id`
`drugs_purchase_files`.`date`
`drugs_purchase_files`.`file`
`drugs_purchase_files`.`status`
`drugs_purchase_files`.`deleted`
`drugs_purchase_files`.`addedOn`
`drugs_purchase_files`.`addedBy`
`drugs_purchase_files`.`modifiedBy`
`drugs_purchase_files`.`modifiedOn`
`drugs_purchase_items`.*
`drugs_purchase_items`.`id`
`drugs_purchase_items`.`drugs_purchase_id`
`drugs_purchase_items`.`drug_store_id`
`drugs_purchase_items`.`medicine_id`
`drugs_purchase_items`.`pharmacy_id`
`drugs_purchase_items`.`quantity`
`drugs_purchase_items`.`final_qty`
`drugs_purchase_items`.`price`
`drugs_purchase_items`.`date`
`drugs_purchase_items`.`status`
`drugs_purchase_items`.`deleted`
`drugs_purchase_items`.`addedOn`
`drugs_purchase_items`.`addedBy`
`drugs_purchase_items`.`modifiedBy`
`drugs_purchase_items`.`modifiedOn`
`drugs_purchases`.*
`drugs_purchases`.`id`
`drugs_purchases`.`drug_store_id`
`drugs_purchases`.`date`
`drugs_purchases`.`status`
`drugs_purchases`.`deleted`
`drugs_purchases`.`addedOn`
`drugs_purchases`.`addedBy`
`drugs_purchases`.`modifiedBy`
`drugs_purchases`.`modifiedOn`
`drugs_quotation_dates`.*
`drugs_quotation_dates`.`id`
`drugs_quotation_dates`.`drug_store_id`
`drugs_quotation_dates`.`date`
`drugs_quotation_dates`.`status`
`drugs_quotation_dates`.`deleted`
`drugs_quotation_dates`.`addedOn`
`drugs_quotation_dates`.`addedBy`
`drugs_quotation_dates`.`modifiedBy`
`drugs_quotation_dates`.`modifiedOn`
`drugs_quotation_files`.*
`drugs_quotation_files`.`id`
`drugs_quotation_files`.`drug_store_id`
`drugs_quotation_files`.`pharmacy_id`
`drugs_quotation_files`.`date`
`drugs_quotation_files`.`file`
`drugs_quotation_files`.`status`
`drugs_quotation_files`.`deleted`
`drugs_quotation_files`.`addedOn`
`drugs_quotation_files`.`addedBy`
`drugs_quotation_files`.`modifiedBy`
`drugs_quotation_files`.`modifiedOn`
`drugs_quotations`.*
`drugs_quotations`.`id`
`drugs_quotations`.`drugs_quotation_date_id`
`drugs_quotations`.`pharamacy_ids`
`drugs_quotations`.`medicine_id`
`drugs_quotations`.`quantity`
`drugs_quotations`.`final_quantity`
`drugs_quotations`.`checked`
`drugs_quotations`.`price_per_qty`
`drugs_quotations`.`quotation_date`
`drugs_quotations`.`price`
`drugs_quotations`.`choose_pharmacy`
`drugs_quotations`.`is_approved`
`drugs_quotations`.`status`
`drugs_quotations`.`deleted`
`drugs_quotations`.`addedOn`
`drugs_quotations`.`addedBy`
`drugs_quotations`.`modifiedBy`
`drugs_quotations`.`modifiedOn`
`drugs_total_count`.*
`drugs_total_count`.`id`
`drugs_total_count`.`drug_store_id`
`drugs_total_count`.`medicine_id`
`drugs_total_count`.`total`
`drugs_total_count`.`status`
`drugs_total_count`.`deleted`
`drugs_total_count`.`addedOn`
`drugs_total_count`.`addedBy`
`drugs_total_count`.`modifiedBy`
`drugs_total_count`.`modifiedOn`
`drugs_transfers`.*
`drugs_transfers`.`id`
`drugs_transfers`.`from_store`
`drugs_transfers`.`to_store`
`drugs_transfers`.`document`
`drugs_transfers`.`transfer_date`
`drugs_transfers`.`DateOfReceipt`
`drugs_transfers`.`status`
`drugs_transfers`.`deleted`
`drugs_transfers`.`addedOn`
`drugs_transfers`.`addedBy`
`drugs_transfers`.`modifiedBy`
`drugs_transfers`.`modifiedOn`
`drugs_transfers`.`done_by`
`drugs_transfers`.`entered_by`
`drugs_transfers`.`is_confirm`
`drugs_transfers`.`confirm_file_name`
`drugs_transfers_medicine_details`.*
`drugs_transfers_medicine_details`.`id`
`drugs_transfers_medicine_details`.`drug_transfer_id`
`drugs_transfers_medicine_details`.`from_store_id`
`drugs_transfers_medicine_details`.`to_store_id`
`drugs_transfers_medicine_details`.`medicine_id`
`drugs_transfers_medicine_details`.`amount`
`drugs_transfers_medicine_details`.`transfer_date`
`drugs_transfers_medicine_details`.`status`
`drugs_transfers_medicine_details`.`deleted`
`drugs_transfers_medicine_details`.`addedOn`
`drugs_transfers_medicine_details`.`addedBy`
`drugs_transfers_medicine_details`.`modifiedBy`
`drugs_transfers_medicine_details`.`modifiedOn`
`drugstores`.*
`drugstores`.`id`
`drugstores`.`title`
`drugstores`.`checked`
`drugstores`.`small_pharamacy`
`drugstores`.`isDispensePharmacy`
`drugstores`.`isOutsideStore`
`drugstores`.`status`
`drugstores`.`deleted`
`drugstores`.`addedOn`
`drugstores`.`addedBy`
`drugstores`.`modifiedBy`
`drugstores`.`modifiedOn`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`employee_role_id`
`employees`.`email`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`family_planning_services`.*
`family_planning_services`.`id`
`family_planning_services`.`date`
`family_planning_services`.`name_of_patient`
`family_planning_services`.`age_of_patient`
`family_planning_services`.`phone_no`
`family_planning_services`.`gender`
`family_planning_services`.`nationality`
`family_planning_services`.`village_id`
`family_planning_services`.`tribe_id`
`family_planning_services`.`new_acceptor_ids`
`family_planning_services`.`revisit_ids`
`family_planning_services`.`employee_id`
`family_planning_services`.`is_counselled_only`
`family_planning_services`.`is_bad_handwriting`
`family_planning_services`.`is_scanned_document`
`family_planning_services`.`is_verification_needed`
`family_planning_services`.`verification_text`
`family_planning_services`.`checked`
`family_planning_services`.`document_file`
`family_planning_services`.`status`
`family_planning_services`.`deleted`
`family_planning_services`.`addedOn`
`family_planning_services`.`addedBy`
`family_planning_services`.`modifiedBy`
`family_planning_services`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`governmental_statistics_settings`.*
`governmental_statistics_settings`.`id`
`governmental_statistics_settings`.`Name`
`governmental_statistics_settings`.`ShortName`
`governmental_statistics_settings`.`IsEnabledIllnesses`
`governmental_statistics_settings`.`IllnessIdsStr`
`governmental_statistics_settings`.`IsEnabledTreatments`
`governmental_statistics_settings`.`TreatmentsIdsStr`
`governmental_statistics_settings`.`UseAgeSettings`
`governmental_statistics_settings`.`AgeType`
`governmental_statistics_settings`.`AgeFromOver`
`governmental_statistics_settings`.`FromAgeYears`
`governmental_statistics_settings`.`TillAgeYears`
`governmental_statistics_settings`.`UnderYears`
`governmental_statistics_settings`.`OverYears`
`governmental_statistics_settings`.`PatientTypeForStat`
`governmental_statistics_settings`.`UseReasonForDismissal`
`governmental_statistics_settings`.`IsReferral`
`governmental_statistics_settings`.`IsDeath`
`governmental_statistics_settings`.`status`
`governmental_statistics_settings`.`deleted`
`governmental_statistics_settings`.`addedBy`
`governmental_statistics_settings`.`modifiedBy`
`governmental_statistics_settings`.`addedOn`
`governmental_statistics_settings`.`modifiedOn`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`title`
`illnesses`.`checked`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses_dosages`.*
`illnesses_dosages`.`id`
`illnesses_dosages`.`treatment_id`
`illnesses_dosages`.`illness_id`
`illnesses_dosages`.`age`
`illnesses_dosages`.`age_from`
`illnesses_dosages`.`age_till`
`illnesses_dosages`.`duration_per_days`
`illnesses_dosages`.`duration_in_days`
`illnesses_dosages`.`total`
`illnesses_dosages`.`status`
`illnesses_dosages`.`deleted`
`illnesses_dosages`.`addedOn`
`illnesses_dosages`.`addedBy`
`illnesses_dosages`.`modifiedBy`
`illnesses_dosages`.`modifiedOn`
`item_categories`.*
`item_categories`.`id`
`item_categories`.`name`
`item_categories`.`status`
`item_categories`.`deleted`
`item_categories`.`addedOn`
`item_categories`.`addedBy`
`item_categories`.`modifiedBy`
`item_categories`.`modifiedOn`
`lab_types`.*
`lab_types`.`id`
`lab_types`.`name`
`lab_types`.`status`
`lab_types`.`deleted`
`lab_types`.`addedOn`
`lab_types`.`addedBy`
`lab_types`.`modifiedBy`
`lab_types`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`login_records`.`user_id`
`medicine_pack_types`.*
`medicine_pack_types`.`id`
`medicine_pack_types`.`name`
`medicine_pack_types`.`status`
`medicine_pack_types`.`deleted`
`medicine_pack_types`.`addedOn`
`medicine_pack_types`.`addedBy`
`medicine_pack_types`.`modifiedBy`
`medicine_pack_types`.`modifiedOn`
`medicine_types`.*
`medicine_types`.`id`
`medicine_types`.`title`
`medicine_types`.`status`
`medicine_types`.`deleted`
`medicine_types`.`addedBy`
`medicine_types`.`modifiedBy`
`medicine_types`.`addedOn`
`medicine_types`.`modifiedOn`
`medicines`.*
`medicines`.`id`
`medicines`.`name`
`medicines`.`medicine_pack_type_id`
`medicines`.`packing_size`
`medicines`.`status`
`medicines`.`deleted`
`medicines`.`addedOn`
`medicines`.`addedBy`
`medicines`.`modifiedBy`
`medicines`.`modifiedOn`
`medicines`.`category_type`
`medicines`.`monthly_required_quantity`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`new_acceptors`.*
`new_acceptors`.`id`
`new_acceptors`.`name`
`new_acceptors`.`status`
`new_acceptors`.`deleted`
`new_acceptors`.`addedOn`
`new_acceptors`.`addedBy`
`new_acceptors`.`modifiedBy`
`new_acceptors`.`modifiedOn`
`outside_purchase_drugs`.*
`outside_purchase_drugs`.`id`
`outside_purchase_drugs`.`document`
`outside_purchase_drugs`.`transfer_date`
`outside_purchase_drugs`.`status`
`outside_purchase_drugs`.`deleted`
`outside_purchase_drugs`.`addedOn`
`outside_purchase_drugs`.`addedBy`
`outside_purchase_drugs`.`modifiedBy`
`outside_purchase_drugs`.`modifiedOn`
`outside_purchase_drugs_details`.*
`outside_purchase_drugs_details`.`id`
`outside_purchase_drugs_details`.`outside_purchase_drug_id`
`outside_purchase_drugs_details`.`medicine_id`
`outside_purchase_drugs_details`.`quantity`
`outside_purchase_drugs_details`.`price`
`outside_purchase_drugs_details`.`pharmacy_id`
`outside_purchase_drugs_details`.`transfer_date`
`outside_purchase_drugs_details`.`status`
`outside_purchase_drugs_details`.`deleted`
`outside_purchase_drugs_details`.`addedOn`
`outside_purchase_drugs_details`.`addedBy`
`outside_purchase_drugs_details`.`modifiedBy`
`outside_purchase_drugs_details`.`modifiedOn`
`patient_file_assigns`.*
`patient_file_assigns`.`id`
`patient_file_assigns`.`patient_file_id`
`patient_file_assigns`.`user_id`
`patient_file_assigns`.`addedOn`
`patient_file_folders`.*
`patient_file_folders`.`id`
`patient_file_folders`.`folder_name`
`patient_file_folders`.`folder_path`
`patient_file_folders`.`modifiedBy`
`patient_file_folders`.`modifiedOn`
`patient_file_folders`.`status`
`patient_file_folders`.`deleted`
`patient_file_folders`.`addedOn`
`patient_file_folders`.`addedBy`
`patient_files`.*
`patient_files`.`id`
`patient_files`.`patient_file_folder_id`
`patient_files`.`patient_property_id`
`patient_files`.`file_orginal_name`
`patient_files`.`file_name`
`patient_files`.`file_size`
`patient_files`.`file_path`
`patient_files`.`extension`
`patient_files`.`type`
`patient_files`.`status`
`patient_files`.`deleted`
`patient_files`.`addedOn`
`patient_files`.`addedBy`
`patient_files`.`modifiedBy`
`patient_files`.`modifiedOn`
`patient_numbers`.*
`patient_numbers`.`id`
`patient_numbers`.`start_number`
`patient_numbers`.`end_number`
`patient_numbers`.`addedBy`
`patient_numbers`.`addedOn`
`patient_numbers`.`modifiedBy`
`patient_numbers`.`modifiedOn`
`patient_numbers`.`date`
`patient_properties`.*
`patient_properties`.`id`
`patient_properties`.`date`
`patient_properties`.`patientNumber`
`patient_properties`.`phone_no`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`nationality`
`patient_properties`.`village_id`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`patient_properties`.`patientStatus`
`patient_properties`.`patientType`
`patient_properties`.`patientStatusForInpatient`
`patient_properties`.`dateOfAdmission`
`patient_properties`.`dateOfDischarge`
`patient_properties`.`reasonOfDismisal`
`patient_properties`.`HBResult`
`patient_properties`.`BFResult`
`patient_properties`.`WBCResult`
`patient_properties`.`UrineResult`
`patient_properties`.`BMResult`
`patient_properties`.`VDRLResult`
`patient_properties`.`HCGResult`
`patient_properties`.`SickleCellsResult`
`patient_properties`.`AFBResult`
`patient_properties`.`CustomResultName`
`patient_properties`.`CustomResult`
`patient_properties`.`badDocStatus`
`patient_properties`.`employee_id`
`patient_properties`.`is_bad_handwriting`
`patient_properties`.`is_scanned_document`
`patient_properties`.`is_verification_needed`
`patient_properties`.`verification_text`
`patient_properties`.`document_file`
`patient_properties`.`status`
`patient_properties`.`deleted`
`patient_properties`.`addedBy`
`patient_properties`.`modifiedBy`
`patient_properties`.`addedOn`
`patient_properties`.`modifiedOn`
`patient_property_tratment_details`.*
`patient_property_tratment_details`.`id`
`patient_property_tratment_details`.`medicine_id`
`patient_property_tratment_details`.`per_day`
`patient_property_tratment_details`.`times`
`patient_property_tratment_details`.`total`
`patient_property_tratment_details`.`patient_property_item_id`
`patient_property_urine_lab_test_results`.*
`patient_property_urine_lab_test_results`.`id`
`patient_property_urine_lab_test_results`.`urine_lab_test_type_id`
`patient_property_urine_lab_test_results`.`result`
`patient_property_urine_lab_test_results`.`patient_property_item_id`
`pharmacies`.*
`pharmacies`.`id`
`pharmacies`.`priority`
`pharmacies`.`name`
`pharmacies`.`address`
`pharmacies`.`phone`
`pharmacies`.`email`
`pharmacies`.`contact_person_name`
`pharmacies`.`contact_person_phone`
`pharmacies`.`contact_person_email`
`pharmacies`.`bank_name`
`pharmacies`.`bank_account`
`pharmacies`.`bank_iban`
`pharmacies`.`status`
`pharmacies`.`deleted`
`pharmacies`.`addedOn`
`pharmacies`.`addedBy`
`pharmacies`.`modifiedBy`
`pharmacies`.`modifiedOn`
`post_natal_cares`.*
`post_natal_cares`.`id`
`post_natal_cares`.`name`
`post_natal_cares`.`status`
`post_natal_cares`.`deleted`
`post_natal_cares`.`addedOn`
`post_natal_cares`.`addedBy`
`post_natal_cares`.`modifiedBy`
`post_natal_cares`.`modifiedOn`
`price_details`.*
`price_details`.`id`
`price_details`.`price_id`
`price_details`.`name`
`price_details`.`type`
`price_details`.`lab_type_id`
`price_details`.`age_from`
`price_details`.`age_till`
`price_details`.`gambians_price`
`price_details`.`non_gambians_price`
`price_details`.`status`
`price_details`.`deleted`
`price_details`.`addedOn`
`price_details`.`addedBy`
`price_details`.`modifiedBy`
`price_details`.`modifiedOn`
`prices`.*
`prices`.`id`
`prices`.`date`
`prices`.`status`
`prices`.`deleted`
`prices`.`addedOn`
`prices`.`addedBy`
`prices`.`modifiedBy`
`prices`.`modifiedOn`
`report_word`.*
`report_word`.`id`
`report_word`.`text`
`report_word`.`status`
`report_word`.`deleted`
`report_word`.`addedOn`
`report_word`.`addedBy`
`report_word`.`modifiedBy`
`report_word`.`modifiedOn`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`revisits`.*
`revisits`.`id`
`revisits`.`name`
`revisits`.`status`
`revisits`.`deleted`
`revisits`.`addedOn`
`revisits`.`addedBy`
`revisits`.`modifiedBy`
`revisits`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`treatment_forms`.*
`treatment_forms`.`id`
`treatment_forms`.`name`
`treatment_forms`.`status`
`treatment_forms`.`deleted`
`treatment_forms`.`addedBy`
`treatment_forms`.`modifiedBy`
`treatment_forms`.`addedOn`
`treatment_forms`.`modifiedOn`
`treatment_illnesses`.*
`treatment_illnesses`.`id`
`treatment_illnesses`.`treatment_id`
`treatment_illnesses`.`illness`
`treatment_illnesses`.`status`
`treatment_illnesses`.`deleted`
`treatment_illnesses`.`addedOn`
`treatment_illnesses`.`addedBy`
`treatment_illnesses`.`modifiedBy`
`treatment_illnesses`.`modifiedOn`
`treatment_ins`.*
`treatment_ins`.`id`
`treatment_ins`.`name`
`treatment_ins`.`status`
`treatment_ins`.`deleted`
`treatment_ins`.`addedBy`
`treatment_ins`.`modifiedBy`
`treatment_ins`.`addedOn`
`treatment_ins`.`modifiedOn`
`treatments`.*
`treatments`.`id`
`treatments`.`medicine_id`
`treatments`.`packsize`
`treatments`.`form`
`treatments`.`strength`
`treatments`.`strength_in`
`treatments`.`male`
`treatments`.`female`
`treatments`.`breast_feeding`
`treatments`.`pregnant`
`treatments`.`from_month`
`treatments`.`till_month`
`treatments`.`only_kids`
`treatments`.`kid_year_from`
`treatments`.`kid_month_from`
`treatments`.`kid_year_till`
`treatments`.`kid_month_till`
`treatments`.`belongs_to`
`treatments`.`alias_names`
`treatments`.`illnesses`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`modifiedOn`
`treatments`.`max_dosage`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`urine_lab_test_types`.*
`urine_lab_test_types`.`id`
`urine_lab_test_types`.`name`
`urine_lab_test_types`.`status`
`urine_lab_test_types`.`deleted`
`urine_lab_test_types`.`addedOn`
`urine_lab_test_types`.`addedBy`
`urine_lab_test_types`.`modifiedBy`
`urine_lab_test_types`.`modifiedOn`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`status`
`warehouses`.`deleted`
`warehouses`.`addedOn`
`warehouses`.`addedBy`
`warehouses`.`modifiedBy`
`warehouses`.`modifiedOn`
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
alias_names
ante_natal_cares
ci_sessions
company_details
contents
currencies
deliveries
drug_inventory_batches
drugs_inventories
drugs_purchase_files
drugs_purchase_items
drugs_purchases
drugs_quotation_dates
drugs_quotation_files
drugs_quotations
drugs_total_count
drugs_transfers
drugs_transfers_medicine_details
drugstores
email_templates
employee_roles
employees
family_planning_services
folder_files
folders
governmental_statistics_settings
illnesses
illnesses_dosages
item_categories
lab_types
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
medicine_pack_types
medicine_types
medicines
modules
new_acceptors
outside_purchase_drugs
outside_purchase_drugs_details
patient_file_assigns
patient_file_folders
patient_files
patient_numbers
patient_properties
patient_property_tratment_details
patient_property_urine_lab_test_results
pharmacies
post_natal_cares
price_details
prices
report_word
reports_dates
revisits
role_permissions
roles
settings
treatment_forms
treatment_illnesses
treatment_ins
treatments
tribes
uploads
urine_lab_test_types
user_address_books
user_profiles
user_schedules
user_settings
users
warehouses
SQL query on database
axiuss40_africa_patient_program
: