Recent
There are no recent tables.
Favorites
There are no favorite tables.
New
axiuss40_africa
charity_program
axiuss40_africa_charity_program
axiuss40_africa_charity_program_14022026
axiuss40_africa_charity_program_15022026
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
car_program
car_program
car_program_staging
illness_checker
illness_checker
illness_checker_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: illness_checker
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:
`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`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`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`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`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`
`illness_advices`.*
`illness_advices`.`id`
`illness_advices`.`illness_id`
`illness_advices`.`advice_text`
`illness_advices`.`is_topic`
`illness_advices`.`sort_order`
`illness_advices`.`status`
`illness_advices`.`addedOn`
`illness_images`.*
`illness_images`.`id`
`illness_images`.`illness_id`
`illness_images`.`image_path`
`illness_images`.`image_order`
`illness_images`.`caption`
`illness_lab_tests`.*
`illness_lab_tests`.`id`
`illness_lab_tests`.`illness_id`
`illness_lab_tests`.`lab_test_id`
`illness_lab_tests`.`is_available`
`illness_symptoms`.*
`illness_symptoms`.`id`
`illness_symptoms`.`illness_id`
`illness_symptoms`.`symptom_id`
`illness_symptoms`.`frequency`
`illness_topics`.*
`illness_topics`.`id`
`illness_topics`.`illness_id`
`illness_topics`.`topic_id`
`illness_treatment_dosages`.*
`illness_treatment_dosages`.`id`
`illness_treatment_dosages`.`illness_treatment_id`
`illness_treatment_dosages`.`dosage_type`
`illness_treatment_dosages`.`range_from`
`illness_treatment_dosages`.`range_to`
`illness_treatment_dosages`.`dosage_value`
`illness_treatment_dosages`.`sort_order`
`illness_treatments`.*
`illness_treatments`.`id`
`illness_treatments`.`illness_id`
`illness_treatments`.`treatment_id`
`illness_treatments`.`severity_level`
`illness_treatments`.`dosage`
`illness_treatments`.`contraindication`
`illness_treatments`.`additional_info`
`illness_treatments`.`dosage_schedule`
`illness_treatments`.`dosage_frequency_text`
`illness_treatments`.`initial_dose`
`illness_treatments`.`notes`
`illness_treatments`.`total_quantity`
`illness_treatments`.`alternative_group`
`illness_treatments`.`combination_group`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`name`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`clinical_notes`
`illnesses`.`caused_by`
`illnesses`.`patient_types`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses`.`referral`
`lab_tests`.*
`lab_tests`.`id`
`lab_tests`.`name`
`lab_tests`.`short_form`
`lab_tests`.`status`
`lab_tests`.`deleted`
`lab_tests`.`addedOn`
`lab_tests`.`addedBy`
`lab_tests`.`modifiedBy`
`lab_tests`.`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`.`user_id`
`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`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`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`
`patient_advice_log`.*
`patient_advice_log`.`id`
`patient_advice_log`.`illness_id`
`patient_advice_log`.`advice_id`
`patient_advice_log`.`patient_id`
`patient_advice_log`.`nurse_id`
`patient_advice_log`.`advised_on`
`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_illness_symptoms`.*
`patient_illness_symptoms`.`id`
`patient_illness_symptoms`.`patient_property_id`
`patient_illness_symptoms`.`illness_id`
`patient_illness_symptoms`.`symptom_id`
`patient_illness_symptoms`.`frequency`
`patient_lab_test_results`.*
`patient_lab_test_results`.`id`
`patient_lab_test_results`.`patient_property_id`
`patient_lab_test_results`.`lab_test_id`
`patient_lab_test_results`.`result_value`
`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`.`patient_name`
`patient_properties`.`date`
`patient_properties`.`time`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`contact_no`
`patient_properties`.`email`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`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`.`patient_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`.`treatment_note`
`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`
`patient_symptoms`.*
`patient_symptoms`.`id`
`patient_symptoms`.`patient_id`
`patient_symptoms`.`symptom_id`
`patient_symptoms`.`frequency`
`patient_symptoms`.`addedOn`
`patient_symptoms`.`addedBy`
`patient_treatment_groups`.*
`patient_treatment_groups`.`id`
`patient_treatment_groups`.`patient_id`
`patient_treatment_groups`.`group_label`
`patient_treatment_groups`.`group_note`
`patient_treatment_groups`.`medicine_ids`
`patient_treatment_groups`.`sort_order`
`patient_treatment_groups`.`created_on`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`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`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`symptoms`.*
`symptoms`.`id`
`symptoms`.`name`
`symptoms`.`status`
`symptoms`.`deleted`
`symptoms`.`addedOn`
`symptoms`.`addedBy`
`symptoms`.`modifiedBy`
`symptoms`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`topics`.*
`topics`.`id`
`topics`.`name`
`topics`.`status`
`topics`.`deleted`
`topics`.`addedOn`
`topics`.`addedBy`
`treatments`.*
`treatments`.`id`
`treatments`.`name`
`treatments`.`max_dosage`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`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`
`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`
`weight_references`.*
`weight_references`.`id`
`weight_references`.`age_years`
`weight_references`.`gender`
`weight_references`.`body_type`
`weight_references`.`weight_min_kg`
`weight_references`.`weight_max_kg`
`weight_references`.`status`
`weight_references`.`deleted`
`weight_references`.`addedOn`
`weight_references`.`addedBy`
`weight_references`.`modifiedBy`
`weight_references`.`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`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`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`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`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`
`illness_advices`.*
`illness_advices`.`id`
`illness_advices`.`illness_id`
`illness_advices`.`advice_text`
`illness_advices`.`is_topic`
`illness_advices`.`sort_order`
`illness_advices`.`status`
`illness_advices`.`addedOn`
`illness_images`.*
`illness_images`.`id`
`illness_images`.`illness_id`
`illness_images`.`image_path`
`illness_images`.`image_order`
`illness_images`.`caption`
`illness_lab_tests`.*
`illness_lab_tests`.`id`
`illness_lab_tests`.`illness_id`
`illness_lab_tests`.`lab_test_id`
`illness_lab_tests`.`is_available`
`illness_symptoms`.*
`illness_symptoms`.`id`
`illness_symptoms`.`illness_id`
`illness_symptoms`.`symptom_id`
`illness_symptoms`.`frequency`
`illness_topics`.*
`illness_topics`.`id`
`illness_topics`.`illness_id`
`illness_topics`.`topic_id`
`illness_treatment_dosages`.*
`illness_treatment_dosages`.`id`
`illness_treatment_dosages`.`illness_treatment_id`
`illness_treatment_dosages`.`dosage_type`
`illness_treatment_dosages`.`range_from`
`illness_treatment_dosages`.`range_to`
`illness_treatment_dosages`.`dosage_value`
`illness_treatment_dosages`.`sort_order`
`illness_treatments`.*
`illness_treatments`.`id`
`illness_treatments`.`illness_id`
`illness_treatments`.`treatment_id`
`illness_treatments`.`severity_level`
`illness_treatments`.`dosage`
`illness_treatments`.`contraindication`
`illness_treatments`.`additional_info`
`illness_treatments`.`dosage_schedule`
`illness_treatments`.`dosage_frequency_text`
`illness_treatments`.`initial_dose`
`illness_treatments`.`notes`
`illness_treatments`.`total_quantity`
`illness_treatments`.`alternative_group`
`illness_treatments`.`combination_group`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`name`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`clinical_notes`
`illnesses`.`caused_by`
`illnesses`.`patient_types`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses`.`referral`
`lab_tests`.*
`lab_tests`.`id`
`lab_tests`.`name`
`lab_tests`.`short_form`
`lab_tests`.`status`
`lab_tests`.`deleted`
`lab_tests`.`addedOn`
`lab_tests`.`addedBy`
`lab_tests`.`modifiedBy`
`lab_tests`.`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`.`user_id`
`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`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`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`
`patient_advice_log`.*
`patient_advice_log`.`id`
`patient_advice_log`.`illness_id`
`patient_advice_log`.`advice_id`
`patient_advice_log`.`patient_id`
`patient_advice_log`.`nurse_id`
`patient_advice_log`.`advised_on`
`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_illness_symptoms`.*
`patient_illness_symptoms`.`id`
`patient_illness_symptoms`.`patient_property_id`
`patient_illness_symptoms`.`illness_id`
`patient_illness_symptoms`.`symptom_id`
`patient_illness_symptoms`.`frequency`
`patient_lab_test_results`.*
`patient_lab_test_results`.`id`
`patient_lab_test_results`.`patient_property_id`
`patient_lab_test_results`.`lab_test_id`
`patient_lab_test_results`.`result_value`
`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`.`patient_name`
`patient_properties`.`date`
`patient_properties`.`time`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`contact_no`
`patient_properties`.`email`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`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`.`patient_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`.`treatment_note`
`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`
`patient_symptoms`.*
`patient_symptoms`.`id`
`patient_symptoms`.`patient_id`
`patient_symptoms`.`symptom_id`
`patient_symptoms`.`frequency`
`patient_symptoms`.`addedOn`
`patient_symptoms`.`addedBy`
`patient_treatment_groups`.*
`patient_treatment_groups`.`id`
`patient_treatment_groups`.`patient_id`
`patient_treatment_groups`.`group_label`
`patient_treatment_groups`.`group_note`
`patient_treatment_groups`.`medicine_ids`
`patient_treatment_groups`.`sort_order`
`patient_treatment_groups`.`created_on`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`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`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`symptoms`.*
`symptoms`.`id`
`symptoms`.`name`
`symptoms`.`status`
`symptoms`.`deleted`
`symptoms`.`addedOn`
`symptoms`.`addedBy`
`symptoms`.`modifiedBy`
`symptoms`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`topics`.*
`topics`.`id`
`topics`.`name`
`topics`.`status`
`topics`.`deleted`
`topics`.`addedOn`
`topics`.`addedBy`
`treatments`.*
`treatments`.`id`
`treatments`.`name`
`treatments`.`max_dosage`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`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`
`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`
`weight_references`.*
`weight_references`.`id`
`weight_references`.`age_years`
`weight_references`.`gender`
`weight_references`.`body_type`
`weight_references`.`weight_min_kg`
`weight_references`.`weight_max_kg`
`weight_references`.`status`
`weight_references`.`deleted`
`weight_references`.`addedOn`
`weight_references`.`addedBy`
`weight_references`.`modifiedBy`
`weight_references`.`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`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`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`
`employees`.*
`employees`.`id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`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`
`illness_advices`.*
`illness_advices`.`id`
`illness_advices`.`illness_id`
`illness_advices`.`advice_text`
`illness_advices`.`is_topic`
`illness_advices`.`sort_order`
`illness_advices`.`status`
`illness_advices`.`addedOn`
`illness_images`.*
`illness_images`.`id`
`illness_images`.`illness_id`
`illness_images`.`image_path`
`illness_images`.`image_order`
`illness_images`.`caption`
`illness_lab_tests`.*
`illness_lab_tests`.`id`
`illness_lab_tests`.`illness_id`
`illness_lab_tests`.`lab_test_id`
`illness_lab_tests`.`is_available`
`illness_symptoms`.*
`illness_symptoms`.`id`
`illness_symptoms`.`illness_id`
`illness_symptoms`.`symptom_id`
`illness_symptoms`.`frequency`
`illness_topics`.*
`illness_topics`.`id`
`illness_topics`.`illness_id`
`illness_topics`.`topic_id`
`illness_treatment_dosages`.*
`illness_treatment_dosages`.`id`
`illness_treatment_dosages`.`illness_treatment_id`
`illness_treatment_dosages`.`dosage_type`
`illness_treatment_dosages`.`range_from`
`illness_treatment_dosages`.`range_to`
`illness_treatment_dosages`.`dosage_value`
`illness_treatment_dosages`.`sort_order`
`illness_treatments`.*
`illness_treatments`.`id`
`illness_treatments`.`illness_id`
`illness_treatments`.`treatment_id`
`illness_treatments`.`severity_level`
`illness_treatments`.`dosage`
`illness_treatments`.`contraindication`
`illness_treatments`.`additional_info`
`illness_treatments`.`dosage_schedule`
`illness_treatments`.`dosage_frequency_text`
`illness_treatments`.`initial_dose`
`illness_treatments`.`notes`
`illness_treatments`.`total_quantity`
`illness_treatments`.`alternative_group`
`illness_treatments`.`combination_group`
`illnesses`.*
`illnesses`.`id`
`illnesses`.`name`
`illnesses`.`status`
`illnesses`.`deleted`
`illnesses`.`clinical_notes`
`illnesses`.`caused_by`
`illnesses`.`patient_types`
`illnesses`.`addedOn`
`illnesses`.`addedBy`
`illnesses`.`modifiedBy`
`illnesses`.`modifiedOn`
`illnesses`.`referral`
`lab_tests`.*
`lab_tests`.`id`
`lab_tests`.`name`
`lab_tests`.`short_form`
`lab_tests`.`status`
`lab_tests`.`deleted`
`lab_tests`.`addedOn`
`lab_tests`.`addedBy`
`lab_tests`.`modifiedBy`
`lab_tests`.`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`.`user_id`
`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`
`mail_templates`.*
`mail_templates`.`id`
`mail_templates`.`name`
`mail_templates`.`email_template_key`
`mail_templates`.`email_subject`
`mail_templates`.`content`
`mail_templates`.`status`
`mail_templates`.`deleted`
`mail_templates`.`modifiedDate`
`mail_templates`.`createdDate`
`mail_templates`.`addedBy`
`mail_templates`.`modifiedBy`
`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`
`patient_advice_log`.*
`patient_advice_log`.`id`
`patient_advice_log`.`illness_id`
`patient_advice_log`.`advice_id`
`patient_advice_log`.`patient_id`
`patient_advice_log`.`nurse_id`
`patient_advice_log`.`advised_on`
`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_illness_symptoms`.*
`patient_illness_symptoms`.`id`
`patient_illness_symptoms`.`patient_property_id`
`patient_illness_symptoms`.`illness_id`
`patient_illness_symptoms`.`symptom_id`
`patient_illness_symptoms`.`frequency`
`patient_lab_test_results`.*
`patient_lab_test_results`.`id`
`patient_lab_test_results`.`patient_property_id`
`patient_lab_test_results`.`lab_test_id`
`patient_lab_test_results`.`result_value`
`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`.`patient_name`
`patient_properties`.`date`
`patient_properties`.`time`
`patient_properties`.`year`
`patient_properties`.`month`
`patient_properties`.`gender`
`patient_properties`.`contact_no`
`patient_properties`.`email`
`patient_properties`.`bpTop`
`patient_properties`.`bpBottom`
`patient_properties`.`temperature`
`patient_properties`.`pulse`
`patient_properties`.`illness_ids`
`patient_properties`.`medicine_ids`
`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`.`patient_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`.`treatment_note`
`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`
`patient_symptoms`.*
`patient_symptoms`.`id`
`patient_symptoms`.`patient_id`
`patient_symptoms`.`symptom_id`
`patient_symptoms`.`frequency`
`patient_symptoms`.`addedOn`
`patient_symptoms`.`addedBy`
`patient_treatment_groups`.*
`patient_treatment_groups`.`id`
`patient_treatment_groups`.`patient_id`
`patient_treatment_groups`.`group_label`
`patient_treatment_groups`.`group_note`
`patient_treatment_groups`.`medicine_ids`
`patient_treatment_groups`.`sort_order`
`patient_treatment_groups`.`created_on`
`reports_dates`.*
`reports_dates`.`id`
`reports_dates`.`user_id`
`reports_dates`.`from_date`
`reports_dates`.`to_date`
`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`
`send_email_logs`.*
`send_email_logs`.`id`
`send_email_logs`.`owner_id`
`send_email_logs`.`type`
`send_email_logs`.`from_email`
`send_email_logs`.`to_email`
`send_email_logs`.`subject`
`send_email_logs`.`body`
`send_email_logs`.`sent_at`
`send_email_logs`.`pdf_file`
`send_email_logs`.`pdf_filename`
`send_email_logs`.`status`
`send_email_logs`.`deleted`
`send_email_logs`.`addedOn`
`send_email_logs`.`addedBy`
`send_email_logs`.`modifiedBy`
`send_email_logs`.`modifiedOn`
`send_email_logs`.`pdf_file_2`
`send_email_logs`.`pdf_filename_2`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`signers`.*
`signers`.`id`
`signers`.`Surname`
`signers`.`Name`
`signers`.`Position`
`signers`.`File`
`signers`.`Filename`
`signers`.`File_Ext`
`signers`.`status`
`signers`.`deleted`
`signers`.`addedOn`
`signers`.`addedBy`
`signers`.`modifiedBy`
`signers`.`modifiedOn`
`symptoms`.*
`symptoms`.`id`
`symptoms`.`name`
`symptoms`.`status`
`symptoms`.`deleted`
`symptoms`.`addedOn`
`symptoms`.`addedBy`
`symptoms`.`modifiedBy`
`symptoms`.`modifiedOn`
`titles`.*
`titles`.`id`
`titles`.`Bezeichnung_Designation`
`titles`.`status`
`titles`.`deleted`
`titles`.`addedOn`
`titles`.`addedBy`
`titles`.`modifiedBy`
`titles`.`modifiedOn`
`topics`.*
`topics`.`id`
`topics`.`name`
`topics`.`status`
`topics`.`deleted`
`topics`.`addedOn`
`topics`.`addedBy`
`treatments`.*
`treatments`.`id`
`treatments`.`name`
`treatments`.`max_dosage`
`treatments`.`status`
`treatments`.`deleted`
`treatments`.`addedOn`
`treatments`.`addedBy`
`treatments`.`modifiedBy`
`treatments`.`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`
`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`
`weight_references`.*
`weight_references`.`id`
`weight_references`.`age_years`
`weight_references`.`gender`
`weight_references`.`body_type`
`weight_references`.`weight_min_kg`
`weight_references`.`weight_max_kg`
`weight_references`.`status`
`weight_references`.`deleted`
`weight_references`.`addedOn`
`weight_references`.`addedBy`
`weight_references`.`modifiedBy`
`weight_references`.`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
ci_sessions
company_details
contents
currencies
email_templates
employees
folder_files
folders
illness_advices
illness_images
illness_lab_tests
illness_symptoms
illness_topics
illness_treatment_dosages
illness_treatments
illnesses
lab_tests
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
mail_templates
modules
patient_advice_log
patient_file_assigns
patient_file_folders
patient_files
patient_illness_symptoms
patient_lab_test_results
patient_numbers
patient_properties
patient_property_tratment_details
patient_property_urine_lab_test_results
patient_symptoms
patient_treatment_groups
reports_dates
role_permissions
roles
send_email_logs
settings
signers
symptoms
titles
topics
treatments
uploads
user_address_books
user_profiles
user_schedules
user_settings
users
weight_references
SQL query on database
illness_checker
: