Drop files here

SQL upload ( 0 ) x -

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





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v illness_checker ci_sessions
* id : varchar(40)
* user_email : varchar(255)
* ip_address : varchar(16)
* user_agent : varchar(50)
* timestamp : int(10) unsigned
* data : text
* browser : varchar(255)
* version : varchar(255)
* device : varchar(255)
* platform : varchar(255)
v illness_checker company_details
* id : int(11)
* name : varchar(255)
* value : text
* language_id : int(11)
* addedOn : datetime
* modifiedOn : datetime
v illness_checker contents
* id : int(11)
* category_id : int(11)
* title : varchar(255)
* description : longtext
* image : varchar(255)
* status : int(11)
* order_no : int(11)
* deleted : int(11)
* slug : varchar(255)
* meta_title : varchar(255)
* meta_key : varchar(255)
* meta_description : varchar(255)
* addedBy : int(11)
* addedOn : datetime
* modifiedOn : timestamp
* modifiedBy : int(11)
v illness_checker currencies
* id : int(11)
* name : varchar(255)
* symbol : varchar(255)
* exchange_rate : varchar(255)
* code : varchar(20)
* exchange_rate_def : varchar(100)
* status : int(11)
* deleted : int(11)
* addedBy : int(11)
* modifiedBy : int(11)
* addedOn : datetime
* modifiedOn : timestamp
v illness_checker email_templates
* id : int(10) unsigned
* name : varchar(255)
* email_template_key : varchar(255)
* email_from : varchar(50)
* email_subject : mediumtext
* content : longtext
* content_cn : longtext
* email_subject_cn : varchar(255)
* variables : mediumtext
* sms_template : mediumtext
* sms_send_status : enum('0','1')
* status : tinyint(1)
* modifiedDate : datetime
* createdDate : datetime
* addedBy : int(11)
* modifiedBy : int(11)
v illness_checker employees
* id : int(11)
* first_name : varchar(255)
* sur_name : varchar(255)
* gender : varchar(120)
* date_of_birth : date
* nationality_id : int(11)
* religion_id : int(11)
* mobile_no_1 : text
* is_whatsapp_mobile_1 : int(11)
* is_comon_mobile_1 : int(11)
* mobile_no_2 : text
* is_whatsapp_mobile_2 : int(11)
* is_comon_mobile_2 : int(11)
* email : text
* city : varchar(255)
* town : varchar(255)
* street : text
* social_security_no : int(11)
* tax_no : int(11)
* profession_id : int(11)
* sector_id : int(11)
* can_read : int(11)
* can_write : int(11)
* is_lives_in_project_staff_house : int(11)
* from_date : date
* to_date : date
* image : text
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker folders
* id : int(11)
* parent_id : int(11)
* name : varchar(255)
* date : date
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker folder_files
* id : int(11)
* folder_id : int(11)
* file_original_name : varchar(255)
* file_name : varchar(255)
* user_id : int(11)
* file_size : int(11)
* extension : varchar(10)
* type : varchar(15)
* created_at : timestamp
* updated_at : timestamp
* deleted_at : timestamp
* deleted : int(11)
* status : int(11)
v illness_checker illnesses
* id : int(10) unsigned
* name : varchar(255)
* status : int(11)
* deleted : int(11)
* clinical_notes : text
* caused_by : text
* patient_types : varchar(50)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
* referral : text
v illness_checker illness_advices
* id : int(10) unsigned
* illness_id : int(10) unsigned
* advice_text : text
* is_topic : tinyint(1)
* sort_order : int(11)
* status : tinyint(1)
* addedOn : datetime
v illness_checker illness_images
* id : int(10) unsigned
* illness_id : int(10) unsigned
* image_path : varchar(500)
* image_order : int(11)
* caption : varchar(255)
v illness_checker illness_lab_tests
* id : int(10) unsigned
* illness_id : int(10) unsigned
* lab_test_id : int(10) unsigned
* is_available : int(11)
v illness_checker illness_symptoms
* id : int(10) unsigned
* illness_id : int(10) unsigned
* symptom_id : int(10) unsigned
* frequency : decimal(10,2)
v illness_checker illness_topics
* id : int(10) unsigned
* illness_id : int(10) unsigned
* topic_id : int(10) unsigned
v illness_checker illness_treatments
* id : int(10) unsigned
* illness_id : int(10) unsigned
* treatment_id : int(10) unsigned
* severity_level : varchar(255)
* dosage : text
* contraindication : text
* additional_info : text
* dosage_schedule : varchar(50)
* dosage_frequency_text : varchar(100)
* initial_dose : text
* notes : text
* total_quantity : varchar(100)
* alternative_group : tinyint(3) unsigned
* combination_group : tinyint(3) unsigned
v illness_checker illness_treatment_dosages
* id : int(10) unsigned
* illness_treatment_id : int(10) unsigned
* dosage_type : enum('age','weight')
* range_from : decimal(8,2)
* range_to : decimal(8,2)
* dosage_value : varchar(100)
* sort_order : int(10) unsigned
v illness_checker lab_tests
* id : int(10) unsigned
* name : varchar(255)
* short_form : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker languages
* id : tinyint(4)
* name : varchar(255)
* short_form : varchar(20)
* language_code : varchar(20)
* text_direction : varchar(10)
* status : tinyint(1)
* deleted : int(11)
* language_order : tinyint(4)
* text_editor_lang : varchar(10)
* flag_path : varchar(255)
v illness_checker location_cities
* id : mediumint(8) unsigned
* name : varchar(255)
* state_id : mediumint(8) unsigned
* state_code : varchar(255)
* country_id : mediumint(8) unsigned
* country_code : char(2)
* latitude : decimal(10,8)
* longitude : decimal(11,8)
* created_at : timestamp
* updated_at : timestamp
* flag : tinyint(1)
* wikiDataId : varchar(255)
v illness_checker location_countries
* id : mediumint(8) unsigned
* name : varchar(100)
* iso3 : char(3)
* iso2 : char(2)
* phonecode : varchar(255)
* capital : varchar(255)
* currency : varchar(255)
* currency_symbol : varchar(255)
* tld : varchar(255)
* native : varchar(255)
* region : varchar(255)
* subregion : varchar(255)
* timezones : text
* translations : text
* latitude : decimal(10,8)
* longitude : decimal(11,8)
* emoji : varchar(191)
* emojiU : varchar(191)
* created_at : timestamp
* updated_at : timestamp
* status : tinyint(1)
* wikiDataId : varchar(255)
v illness_checker location_states
* id : mediumint(8) unsigned
* name : varchar(255)
* country_id : mediumint(8) unsigned
* country_code : char(2)
* fips_code : varchar(255)
* iso2 : varchar(255)
* latitude : decimal(10,8)
* longitude : decimal(11,8)
* created_at : timestamp
* updated_at : timestamp
* flag : tinyint(1)
* wikiDataId : varchar(255)
v illness_checker location_villages
* id : int(11)
* name : varchar(255)
* distance : float
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker login_attempts
* id : int(10) unsigned
* ip_address : varchar(45)
* login : varchar(100)
* time : int(10) unsigned
v illness_checker login_records
* id : int(11)
* session_id : varchar(255)
* user_email : varchar(255)
* user_id : int(11)
* ip_address : varchar(16)
* user_agent : varchar(50)
* login_time : int(10) unsigned
* logout_time : int(11)
* browser : varchar(255)
* version : varchar(255)
* device : varchar(255)
* platform : varchar(255)
* mac_id : varchar(255)
* modifiedOn : timestamp
v illness_checker mail_templates
* id : int(10) unsigned
* name : varchar(255)
* email_template_key : varchar(255)
* email_subject : mediumtext
* content : longtext
* status : tinyint(1)
* deleted : int(11)
* modifiedDate : datetime
* createdDate : datetime
* addedBy : int(11)
* modifiedBy : int(11)
v illness_checker modules
* id : int(11)
* section : varchar(255)
* name : varchar(100)
* lang_names : longtext
* alias : varchar(100)
* order_no : float
* is_url : int(11)
* url : varchar(255)
* parent_id : int(11)
* description : mediumtext
* icon : varchar(255)
* permissions : varchar(255)
* is_public : int(11)
* addedBy : int(11)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* modifiedOn : timestamp
* modifiedBy : varchar(100)
v illness_checker patient_advice_log
* id : int(10) unsigned
* illness_id : int(10) unsigned
* advice_id : int(10) unsigned
* patient_id : int(10) unsigned
* nurse_id : int(11)
* advised_on : datetime
v illness_checker patient_files
* id : int(11)
* patient_file_folder_id : int(11)
* patient_property_id : int(11)
* file_orginal_name : varchar(255)
* file_name : varchar(255)
* file_size : varchar(255)
* file_path : varchar(255)
* extension : varchar(255)
* type : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker patient_file_assigns
* id : int(11)
* patient_file_id : int(11)
* user_id : int(11)
* addedOn : timestamp
v illness_checker patient_file_folders
* id : int(11)
* folder_name : varchar(255)
* folder_path : varchar(255)
* modifiedBy : int(11)
* modifiedOn : timestamp
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
v illness_checker patient_illness_symptoms
* id : int(11)
* patient_property_id : int(11)
* illness_id : int(11)
* symptom_id : int(11)
* frequency : varchar(255)
v illness_checker patient_lab_test_results
* id : int(11)
* patient_property_id : int(11)
* lab_test_id : int(11)
* result_value : varchar(255)
v illness_checker patient_numbers
* id : int(11)
* start_number : int(11)
* end_number : int(11)
* addedBy : int(11)
* addedOn : datetime
* modifiedBy : int(11)
* modifiedOn : timestamp
* date : date
v illness_checker patient_properties
* id : int(11)
* patient_name : varchar(255)
* date : date
* time : time
* year : int(11)
* month : int(11)
* gender : varchar(50)
* contact_no : int(11)
* email : varchar(255)
* bpTop : int(11)
* bpBottom : int(11)
* temperature : decimal(10,2)
* pulse : int(11)
* illness_ids : varchar(255)
* medicine_ids : varchar(255)
* status : int(11)
* deleted : int(11)
* addedBy : int(11)
* modifiedBy : int(11)
* addedOn : datetime
* modifiedOn : timestamp
v illness_checker patient_property_tratment_details
* id : int(11)
* patient_id : int(11)
* medicine_id : int(11)
* per_day : int(11)
* times : decimal(10,1)
* total : decimal(10,1)
* treatment_note : text
v illness_checker patient_property_urine_lab_test_results
* id : int(11)
* urine_lab_test_type_id : int(11)
* result : text
* patient_property_item_id : int(11)
v illness_checker patient_symptoms
* id : int(11)
* patient_id : int(11)
* symptom_id : int(10) unsigned
* frequency : enum('rarely','usually','most_often','always')
* addedOn : datetime
* addedBy : int(11)
v illness_checker patient_treatment_groups
* id : int(11)
* patient_id : int(11)
* group_label : varchar(100)
* group_note : text
* medicine_ids : varchar(500)
* sort_order : int(11)
* created_on : timestamp
v illness_checker reports_dates
* id : int(11)
* user_id : int(11)
* from_date : date
* to_date : date
v illness_checker roles
* id : int(11)
* parent_id : int(11)
* name : varchar(255)
* description : varchar(255)
* modifiedBy : varchar(16)
* deleted : int(11)
* addedBy : varchar(255)
* addedOn : datetime
* modifiedOn : timestamp
* status : int(11)
v illness_checker role_permissions
* id : int(11)
* role_id : int(11)
* module_id : int(11)
* parent_module_id : int(11)
* section : varchar(255)
* permission_add : int(11)
* permission_edit : int(11)
* permission_view : int(11)
* permission_delete : int(11)
* permission_status : int(11)
* addedBy : int(11)
* addedOn : datetime
* modifiedOn : timestamp
v illness_checker send_email_logs
* id : int(11)
* owner_id : int(11)
* type : text
* from_email : varchar(255)
* to_email : varchar(255)
* subject : text
* body : longtext
* sent_at : datetime
* pdf_file : longblob
* pdf_filename : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
* pdf_file_2 : longblob
* pdf_filename_2 : varchar(255)
v illness_checker settings
* id : int(11)
* name : varchar(255)
* value : text
* language_id : int(11)
* addedOn : datetime
* modifiedOn : datetime
v illness_checker signers
* id : int(10) unsigned
* Surname : varchar(255)
* Name : varchar(255)
* Position : varchar(255)
* File : longblob
* Filename : varchar(255)
* File_Ext : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker symptoms
* id : int(10) unsigned
* name : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker titles
* id : int(10) unsigned
* Bezeichnung_Designation : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker topics
* id : int(10) unsigned
* name : varchar(255)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
v illness_checker treatments
* id : int(10) unsigned
* name : varchar(255)
* max_dosage : int(11)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
v illness_checker uploads
* id : int(11)
* file_original_name : varchar(255)
* file_name : varchar(255)
* user_id : int(11)
* file_size : int(11)
* extension : varchar(10)
* type : varchar(15)
* created_at : timestamp
* updated_at : timestamp
* deleted_at : timestamp
v illness_checker users
* id : int(11)
* parent_id : int(11)
* role_ids : varchar(255)
* login_id : varchar(255)
* password : varchar(255)
* is_online : int(11)
* is_verified : int(11)
* is_admin_verified : int(11)
* is_first_login : int(11)
* otp : varchar(255)
* device_type : varchar(255)
* ios_device_id : varchar(255)
* android_device_id : varchar(255)
* web_token : longtext
* login_type : varchar(255)
* addedOn : datetime
* modifiedOn : timestamp
* addedBy : varchar(255)
* modifiedBy : varchar(255)
* status : int(11)
* deleted : int(11)
* login_language : text
v illness_checker user_address_books
* id : int(11)
* user_id : int(11)
* is_favourite : int(11)
* name : varchar(255)
* phone_no : varchar(255)
* address : varchar(255)
* area : varchar(255)
* lat : varchar(255)
* lng : varchar(255)
* address_type : varchar(255)
* is_gift : int(11)
* status : int(11)
* deleted : int(11)
* addedBy : int(11)
* modifiedBy : int(11)
* addedOn : datetime
* modifiedOn : timestamp
v illness_checker user_profiles
* id : int(11)
* parent_id : int(11)
* user_id : int(11)
* full_name : varchar(255)
* fname : varchar(255)
* lname : varchar(255)
* email : varchar(255)
* phone_code : varchar(255)
* phone_no : varchar(255)
* profile_image : varchar(255)
* gender : varchar(16)
* dob : date
* about : longtext
* landmark : varchar(255)
* address : varchar(255)
* lat : varchar(255)
* lng : varchar(255)
* state_id : varchar(16)
* country_id : varchar(255)
* city_id : varchar(255)
* pincode : varchar(255)
* addedOn : datetime
* modifiedOn : timestamp
* modifiedBy : varchar(255)
v illness_checker user_schedules
* id : int(11)
* user_id : int(11)
* day : int(11)
* day_name : varchar(255)
* time_from : time
* time_to : time
* type : varchar(255)
* modifiedOn : timestamp
v illness_checker user_settings
* id : int(11)
* user_id : int(11)
* time_zone : varchar(255)
* language_id : int(11)
* multifactor_authenticate : int(11)
* google_auth_code : varchar(255)
* authenticate_using_otp : int(11)
* otp_phone : varchar(255)
* otp : varchar(255)
* authenticate_using_google : int(11)
* modifiedOn : timestamp
* modifiedBy : int(11)
v illness_checker weight_references
* id : int(10) unsigned
* age_years : int(11)
* gender : enum('male','female')
* body_type : enum('slim','normal','fat')
* weight_min_kg : decimal(5,1)
* weight_max_kg : decimal(5,1)
* status : int(11)
* deleted : int(11)
* addedOn : datetime
* addedBy : int(11)
* modifiedBy : int(11)
* modifiedOn : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship