* id email fromName from_uid toName to_uid socketId message ts isRead

* id description class_code Clasification

* id description income_code fee stat

* id trans_type trans_id file_name file_path file_size stat uid

* id code description

* business_number app_id business_name trade_name president registered saved_by_department_code business_date_started brgy_id purok_id purok_name business_address_temp buss_house_no buss_unit_no buss_building_name buss_street_no buss_purok buss_barangay buss_sub buss_city buss_province buss_email_add buss_contact_no owner_address_temp owner_house_no owner_unit_no owner_building_name owner_street_no owner_purok owner_barangay owner_sub owner_city owner_province owner_contact_no owner_email_add less_address_temp business_contact_no_temp business_email_add business_status reference_org less_contact_no less_email_add less_contact_person less_tel_no less_mobile less_email less_house_no less_unit_no less_building_name less_street_no less_purok less_barangay less_sub less_city less_province less_rental taxpayer taxpayer_lname taxpayer_fname taxpayer_mname local_tax_payer_id local_taxpayer_name local_business_number

* id connection queue payload exception failed_at

* id module grouping form_name file_route access global

* id profile_name stat

* id profile_id file_route access

* id uid profile_id

* SysPK_Brgy city_mun_id brgy_id brgy_name checker brgy_code URBAN_RURAL POPULATION CITY PROVINCE REGION person_code stat brgy_code1

* id brgy_id barangay purok status

* id business_id name address lat lng type status

* id migration batch

* permission_id model_type model_id

* role_id model_type model_id

* id user_id client_id name scopes revoked created_at updated_at expires_at

* id user_id client_id scopes revoked expires_at

* id user_id name secret redirect personal_access_client password_client revoked created_at updated_at

* id client_id created_at updated_at

* id access_token_id revoked expires_at

* id apptype businessType businesskind businessName tradeName taxpayer_fname taxpayer_mname taxpayer_lname ctc barangayClearance businessOwned ts

* id app_id file_size file_name file_path file_full_path entry_type ts stat

* id app_id orgType mop isBSP bspNo bspType bmbeNo taxpayer_fname taxpayer_lname taxpayer_mname businessName tradeName president governmentIncentives governmentIncentivesNo dti_reg_no dti_Reg_date dti_Exp_date sss nfa pca ctc tin buss_house_no buss_unit_no buss_building_name buss_street_no buss_purok_name buss_purok buss_barangay buss_sub buss_city buss_province buss_contact_no buss_email_add owner_house_no owner_unit_no owner_building_name owner_street_no owner_purok owner_barangay owner_sub owner_city owner_province owner_contact_no owner_email_add deliveryUnit officeType OfficeOthers areaSqm representative male female lgucount less_house_no less_unit_no less_building_name less_street_no less_purok less_barangay less_sub less_city less_province less_contact_no less_email_add less_contact_person less_rental less_tel_no less_mobile less_email ts local_tax_payer_id local_taxpayer_name local_business_number

* id app_id desc_id desc_name gross remarks

* id app_id desc_id description emp_count remarks

* email token created_at

* id name guard_name created_at updated_at

* id tokenable_type tokenable_id name token abilities last_used_at created_at updated_at

* id brgyCode brgyDesc regCode provCode citymunCode

* id psgcCode citymunDesc regDesc provCode citymunCode

* id psgcCode provDesc regCode provCode

* id psgcCode regDesc regCode

* id name guard_name created_at updated_at

* permission_id role_id

* id transDate groupType description remarks transStat created_at updated_at

* id mun_cit_id prov_id reg_id Term_From Term_To zip_code overview type status projectAquisition ProjectAcq_id year_declared date_declared

* id item_name uom date time type amount description

* id name amount uom status

* pkID user_id prefix fname mname lname suffix nickname dob pob gender civilStatus citizenship height weight religion occupation bloodType address1 address2 street barangay_id barangay cityMun_id cityMun province_id province region zipcode address1_ address2_ street_ barangay_id_ barangay_ cityMun_id_ cityMun_ province_id_ province_ region_ zipcode_ telNo cellNo emailAdd facebook twitter instagram trans_stat created_at updated_at

* id local_id name mobile email email_verified_at password remember_token created_at updated_at verified Employee_id status isActive image_path isLogin cancel admin approved Login Logout socketId empid google_id

* id uid IPX MAC ts

* id facility_name numbers colors target fac_codes

* id facility_id queuing_count

* user_id token created_at updated_at

select table chatlogs cto_kind_business_setup cto_occupation_fees docs_upload ebplo_bsp ebplo_business_list failed_jobs form_name form_profile form_profile_access form_user_profile lgu_brgy_setup lgu_purok_setup mapa migrations model_has_permissions model_has_roles oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens online_application online_application_docs online_profile online_profile_kind_business online_profile_occupational_fee password_resets permissions personal_access_tokens refbrgy refcitymun refprovince refregion roles role_has_permissions setup tbl_general_location tbl_items_setup tbl_item_type tbl_person_setup users user_logs vaccine_facility vaccine_queuing verify_users . 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 chatlogs cto_kind_business_setup cto_occupation_fees docs_upload ebplo_bsp ebplo_business_list failed_jobs form_name form_profile form_profile_access form_user_profile lgu_brgy_setup lgu_purok_setup mapa migrations model_has_permissions model_has_roles oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens online_application online_application_docs online_profile online_profile_kind_business online_profile_occupational_fee password_resets permissions personal_access_tokens refbrgy refcitymun refprovince refregion roles role_has_permissions setup tbl_general_location tbl_items_setup tbl_item_type tbl_person_setup users user_logs vaccine_facility vaccine_queuing verify_users .	select column