* id user_email ip_address user_agent timestamp data browser version device platform

* id name value language_id addedOn modifiedOn

* id category_id title description image status order_no deleted slug meta_title meta_key meta_description addedBy addedOn modifiedOn modifiedBy

* id name symbol exchange_rate code exchange_rate_def status deleted addedBy modifiedBy addedOn modifiedOn

* id name email_template_key email_from email_subject content content_cn email_subject_cn variables sms_template sms_send_status status modifiedDate createdDate addedBy modifiedBy

* id first_name sur_name gender date_of_birth nationality_id religion_id mobile_no_1 is_whatsapp_mobile_1 is_comon_mobile_1 mobile_no_2 is_whatsapp_mobile_2 is_comon_mobile_2 email city town street social_security_no tax_no profession_id sector_id can_read can_write is_lives_in_project_staff_house from_date to_date image status deleted addedOn addedBy modifiedBy modifiedOn

* id parent_id name date status deleted addedOn addedBy modifiedBy modifiedOn

* id folder_id file_original_name file_name user_id file_size extension type created_at updated_at deleted_at deleted status

* id name status deleted clinical_notes caused_by patient_types addedOn addedBy modifiedBy modifiedOn referral

* id illness_id advice_text is_topic sort_order status addedOn

* id illness_id image_path image_order caption

* id illness_id lab_test_id is_available

* id illness_id symptom_id frequency

* id illness_id topic_id

* id illness_id treatment_id severity_level dosage contraindication additional_info dosage_schedule dosage_frequency_text initial_dose notes total_quantity alternative_group combination_group

* id illness_treatment_id dosage_type range_from range_to dosage_value sort_order

* id name short_form status deleted addedOn addedBy modifiedBy modifiedOn

* id name short_form language_code text_direction status deleted language_order text_editor_lang flag_path

* id name state_id state_code country_id country_code latitude longitude created_at updated_at flag wikiDataId

* id name iso3 iso2 phonecode capital currency currency_symbol tld native region subregion timezones translations latitude longitude emoji emojiU created_at updated_at status wikiDataId

* id name country_id country_code fips_code iso2 latitude longitude created_at updated_at flag wikiDataId

* id name distance status deleted addedOn addedBy modifiedBy modifiedOn

* id ip_address login time

* id session_id user_email user_id ip_address user_agent login_time logout_time browser version device platform mac_id modifiedOn

* id name email_template_key email_subject content status deleted modifiedDate createdDate addedBy modifiedBy

* id section name lang_names alias order_no is_url url parent_id description icon permissions is_public addedBy status deleted addedOn modifiedOn modifiedBy

* id illness_id advice_id patient_id nurse_id advised_on

* id patient_file_folder_id patient_property_id file_orginal_name file_name file_size file_path extension type status deleted addedOn addedBy modifiedBy modifiedOn

* id patient_file_id user_id addedOn

* id folder_name folder_path modifiedBy modifiedOn status deleted addedOn addedBy

* id patient_property_id illness_id symptom_id frequency

* id patient_property_id lab_test_id result_value

* id start_number end_number addedBy addedOn modifiedBy modifiedOn date

* id patient_name date time year month gender contact_no email bpTop bpBottom temperature pulse illness_ids medicine_ids status deleted addedBy modifiedBy addedOn modifiedOn

* id patient_id medicine_id per_day times total treatment_note

* id urine_lab_test_type_id result patient_property_item_id

* id patient_id symptom_id frequency addedOn addedBy

* id patient_id group_label group_note medicine_ids sort_order created_on

* id user_id from_date to_date

* id parent_id name description modifiedBy deleted addedBy addedOn modifiedOn status

* id role_id module_id parent_module_id section permission_add permission_edit permission_view permission_delete permission_status addedBy addedOn modifiedOn

* id owner_id type from_email to_email subject body sent_at pdf_file pdf_filename status deleted addedOn addedBy modifiedBy modifiedOn pdf_file_2 pdf_filename_2

* id name value language_id addedOn modifiedOn

* id Surname Name Position File Filename File_Ext status deleted addedOn addedBy modifiedBy modifiedOn

* id name status deleted addedOn addedBy modifiedBy modifiedOn

* id Bezeichnung_Designation status deleted addedOn addedBy modifiedBy modifiedOn

* id name status deleted addedOn addedBy

* id name max_dosage status deleted addedOn addedBy modifiedBy modifiedOn

* id file_original_name file_name user_id file_size extension type created_at updated_at deleted_at

* id parent_id role_ids login_id password is_online is_verified is_admin_verified is_first_login otp device_type ios_device_id android_device_id web_token login_type addedOn modifiedOn addedBy modifiedBy status deleted login_language

* id user_id is_favourite name phone_no address area lat lng address_type is_gift status deleted addedBy modifiedBy addedOn modifiedOn

* id parent_id user_id full_name fname lname email phone_code phone_no profile_image gender dob about landmark address lat lng state_id country_id city_id pincode addedOn modifiedOn modifiedBy

* id user_id day day_name time_from time_to type modifiedOn

* id user_id time_zone language_id multifactor_authenticate google_auth_code authenticate_using_otp otp_phone otp authenticate_using_google modifiedOn modifiedBy

* id age_years gender body_type weight_min_kg weight_max_kg status deleted addedOn addedBy modifiedBy modifiedOn

select table ci_sessions company_details contents currencies email_templates employees folders folder_files illnesses illness_advices illness_images illness_lab_tests illness_symptoms illness_topics illness_treatments illness_treatment_dosages lab_tests languages location_cities location_countries location_states location_villages login_attempts login_records mail_templates modules patient_advice_log patient_files patient_file_assigns patient_file_folders 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 roles role_permissions send_email_logs settings signers symptoms titles topics treatments uploads users user_address_books user_profiles user_schedules user_settings weight_references . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table ci_sessions company_details contents currencies email_templates employees folders folder_files illnesses illness_advices illness_images illness_lab_tests illness_symptoms illness_topics illness_treatments illness_treatment_dosages lab_tests languages location_cities location_countries location_states location_villages login_attempts login_records mail_templates modules patient_advice_log patient_files patient_file_assigns patient_file_folders 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 roles role_permissions send_email_logs settings signers symptoms titles topics treatments uploads users user_address_books user_profiles user_schedules user_settings weight_references .	select column