* id main_id delivery_fee print_fee rush_fee total_amount

* id user_id LastN MiddleN FirsN ext_name gender Region region_name province province_name Municipality municipality_name DoB status

* id main_id father_lastN father_Mname father_firstN mother_lastN mother_Mname mother_firstN

* id main_id requester_tax info_lastname info_Mname info_Fname relationship mail_Region mail_regionN mail_province mail_provinceN mail_municipality mail_mncipalityN mail_barangay mail_brngyN unit_room tel_no mobile_no

* id main_id specify_abroad birth_register hospital_name Registered_late register_when no_copies print_what purpose valid_id del_optn

* id email fromName from_uid toName to_uid socketId message ts isRead

* id corp_municipality corp_municipality_name corp_province corp_province_name corp_cedula_amount corp_region corp_region_name corp_home corp_barangay corp_barangay_name line_business nature_business corp_reg_date corp_place_reg corp_tin_num extension_validID corp_name civil_status representative corp_total_amount corp_total_cedula corp_earnings_amount corp_earnings_cedula partial_total interest total_amount status

* id user_id firstName middleName lastName extension_name indi_region indi_region_name indi_province indi_province_name indi_municipality indi_municipality_name indi_barangay indi_barangay_name indi_home gender dob dob_province dob_province_name dob_municipality dob_municipality_name dob_region dob_region_name civil_status country_citizenship alien_citizenship height weight employed_stat tax_act_num tax_due profession profession_other indi_validID income_total_amount income_cedula_amount earnings_taxable_amount earnings_cedula_amount salaries_taxable_amount salaries_cedula_amount partial_total interest total_amount status

* id description class_code Clasification

* id description income_code fee stat

* id reg_no LastN MiddleN FirsN ext_name gender DoD place_Death status

* id main_id delivery_fee print_fee rush_fee total_amount

* id main_id user_id Doc_lastN Doc_Mname Doc_firstN Rel_owner Region region_name province province_name municipality municipality_name Barangay brngy_name unit_room tel_no mobile_no

* id main_id no_copies print_what valid_id del_optn

* id business_number app_id trans_type attch_description remarks doctype_id file_name file_path file_size stat uid ts

* id type description order

* id bsp_id bus_id

* id code description

* business_app_id user_id appno business_number tax_year application_date release_date permit_status permit_no permit_no1 busAccntNo business_name trade_name transaction_type application_type BMBE BMBE_no bspType BSP BSP_no with_property status business_status bstatus_beforeTerm transfer transfer_tax_pyer_id transfer_owner_id ammendment organization_type pca_no nfa_no dti_reg_no dti_reg_date dti_expiry_date entity owner president_name president_fname president_mname president_lname president_suffix business_address brgy_address purok_id owners_address place_of_issuance bookeeper reference_no ctc_no TIN SSS contact_no email_address PIN employee_residing total_employee total_male total_female no_delivery_units delivery_vehicle delivery_motorcycle business_area bus_activity bus_activity_branch other_specify lessor lessor_address contact_person monthly_rental tel_no mode_of_payment temp_permit_no violationNoticeCount PIC gross_sales_capitalization new_capital timestamp application_from verified_by verified_date verified_remarks drug_free payment_status td_id business_president uid profile_id app_id lnglat governmentIncentives governmentIncentivesNo officeType textbox jointFiling valid_ID guidx local_business_app_id sched_date application_status assessment_amount

* business_dtl business_no tax_year capitalization new_capitalization gross_sales new_gross_sales lessor_name business_add_blk business_add_lot business_add_bldg business_add_street business_add_purok_name buss_purok business_add_brgy business_add_brgy_name business_add_subd business_add_city business_add_prov business_add_telno business_add_email owner_add_blk owner_add_lot owner_add_bldg owner_add_street owner_purok owner_add_brgy owner_add_subd owner_add_city owner_add_prov owner_add_telno owner_add_email lessor_add_blk lessor_add_lot lessor_add_bldg lessor_add_street lessor_add_brgy lessor_add_subd lessor_add_city lessor_add_prov lessor_add_telno lessor_add_email SSS in_case_telno in_case_mobile in_case_email

* id bappid kind_id description psiCode products_services remarks app_type cp_gs

* business_number business_name trade_name registered saved_by_department_code business_date_started brgy_id business_address_temp business_contact_no_temp business_email_add business_status retirement_reason retirement_date reference_owner reference_address reference_org Vat_NonVat Type YearType status vat_id

* id bappid lng lat status

* id bappid occ_id no_emp remarks

* ver_docs_id bus_app_id verified doc_id doc_description date_issued verified_by verified_by_ID dept violation_id

* id cert_no series_no app_date payee_id payee_type excempt prop_owner prop_name prop_address taxdec_id taxdec_no pin_number prop_type cert_id income_account_code res_purpose status onlinerequestid businessapplicant businessname businessapplicant_id brgy_address classification_type cert_remarks cert_type rev_from rev_to classname classid savedate rpt_ownership rpt_ownership_others encoded cpy

* pkid id td_id arp_no property_owner property_address pin lot_no title_no land_area assessed_value savedate

* id description abv status

* id connection queue payload exception failed_at

* id module grouping form_name file_route access

* id profile_name stat

* id profile_id file_route access

* id uid profile_id

* name abv abv3 abv3_alt code slug

* SysPK_Brgy city_mun_id brgy_id brgy_name checker brgy_code URBAN_RURAL POPULATION CITY PROVINCE REGION person_code bank_name bank_account_no stat brgy_code1 qr_brgy_id district_id

* id brgy_id barangay purok status

* id business_id name address lat lng type status

* id main_id place_marriage place_marriageAdd date time1 time2

* id LastN MiddleN FirstN DoB age place_birthMuni place_birthProv place_birthctry gender citizenship addrss_houseST Addrss_brgy addrss_cityMun addrss_prov addrss_cntry religion civil_status father_first father_mName father_last father_ctznship mother_first mother_Mname mother_last mother_ctznship person_consent relationship residence status

* id main_id LastN MiddleN FirstN DoB age place_birthMuni place_birthProv place_birthctry gender citizenship addrss_houseST Addrss_brgy addrss_cityMun addrss_prov addrss_cntry religion civil_status father_first father_mName father_last father_ctznship mother_first mother_Mname mother_last mother_ctznship person_consent relationship residence

* id migration batch

* permission_id model_type model_id

* role_id model_type model_id

* business_app_id user_id appno business_number tax_year application_date release_date permit_status permit_no permit_no1 busAccntNo business_name trade_name transaction_type application_type BMBE BMBE_no bspType BSP BSP_no with_property status business_status bstatus_beforeTerm transfer transfer_tax_pyer_id transfer_owner_id ammendment organization_type pca_no nfa_no dti_reg_no dti_reg_date dti_expiry_date entity owner president_name president_fname president_mname president_lname president_suffix business_address brgy_address purok_id owners_address place_of_issuance bookeeper reference_no ctc_no TIN SSS contact_no email_address PIN employee_residing total_employee total_male total_female no_delivery_units delivery_vehicle delivery_motorcycle business_area bus_activity bus_activity_branch other_specify lessor lessor_address contact_person monthly_rental tel_no mode_of_payment temp_permit_no violationNoticeCount PIC gross_sales_capitalization new_capital timestamp application_from verified_by verified_date verified_remarks drug_free payment_status td_id business_president uid profile_id app_id lnglat governmentIncentives governmentIncentivesNo officeType textbox jointFiling valid_ID guidx local_business_app_id sched_date application_status assessment_amount

* business_dtl business_no tax_year capitalization new_capitalization gross_sales new_gross_sales lessor_name business_add_blk business_add_lot business_add_bldg business_add_street business_add_purok_name buss_purok business_add_brgy business_add_brgy_name business_add_subd business_add_city business_add_prov business_add_telno business_add_email owner_add_blk owner_add_lot owner_add_bldg owner_add_street owner_purok owner_add_brgy owner_add_subd owner_add_city owner_add_prov owner_add_telno owner_add_email lessor_add_blk lessor_add_lot lessor_add_bldg lessor_add_street lessor_add_brgy lessor_add_subd lessor_add_city lessor_add_prov lessor_add_telno lessor_add_email SSS in_case_telno in_case_mobile in_case_email

* id bappid kind_id description psiCode products_services remarks app_type cp_gs

* id bappid lng lat status

* id bappid occ_id no_emp remarks

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

* id app_id docs_id file_size file_name file_path file_full_path entry_type ts stat guidx

* 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 provider

* id client_id created_at updated_at

* id access_token_id revoked expires_at

* id mainID bzName address addCopy paidCopy total status

* id user_id typex lname mname fname extName region regName province provName municipal munName brgy brgyName streetName regionBirth regBirthx provinceBirth provBirthx municipalBirth munBirthx dob gender telno mobileno civilStat citizenship height weight complexion educAttainment institution natureWork positionx validId status paidCopy totalx addCopy bzName address

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

* id app_id docs_id file_size file_name file_path file_full_path entry_type ts stat guidx

* 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

* 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 ref_city_id ref_prov_id

* 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 app_id local_id name fname mname lname suffix 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

* doc_id doc_description office_agency department required real_property no_prop_taxcler payemet charge_account stat filter new_type renew_type priority_no form_id violation_id effectivity_date pre_req post_req rent_only

* dtl_id doc_id organizational_type

* user_id token created_at updated_at

select table birthcert_dtls birthcert_info birthcert_parentinfo birthcert_requestorinfo birthcert_transinfo chatlogs ctc_corporation ctc_individual cto_kind_business_setup cto_occupation_fees deathcert_docowner deathcert_dtls deathcert_reqinfo deathcert_transinfo document_entry document_setup ebplo_application_bsp ebplo_bsp ebplo_business_application ebplo_business_application_detail ebplo_business_kind_business ebplo_business_list ebplo_business_location ebplo_business_occ_fees_app ebplo_verification_docs ecao_certification_trans ecao_certification_trans_detail ecao_classification_type failed_jobs form_name form_profile form_profile_access form_user_profile geo_countries lgu_brgy_setup lgu_purok_setup mapa marriagecert_details marriagecert_husbandinfo marriagecert_wifeinfo migrations model_has_permissions model_has_roles naga_ebplo_business_application naga_ebplo_business_application_detail naga_ebplo_business_kind_business naga_ebplo_business_location naga_ebplo_business_occ_fees_app naga_online_application naga_online_application_docs oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens occupational_healthcert_businessname occupational_healthcert_main 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 verify_doc_setup verify_doc_setup_dtl 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 birthcert_dtls birthcert_info birthcert_parentinfo birthcert_requestorinfo birthcert_transinfo chatlogs ctc_corporation ctc_individual cto_kind_business_setup cto_occupation_fees deathcert_docowner deathcert_dtls deathcert_reqinfo deathcert_transinfo document_entry document_setup ebplo_application_bsp ebplo_bsp ebplo_business_application ebplo_business_application_detail ebplo_business_kind_business ebplo_business_list ebplo_business_location ebplo_business_occ_fees_app ebplo_verification_docs ecao_certification_trans ecao_certification_trans_detail ecao_classification_type failed_jobs form_name form_profile form_profile_access form_user_profile geo_countries lgu_brgy_setup lgu_purok_setup mapa marriagecert_details marriagecert_husbandinfo marriagecert_wifeinfo migrations model_has_permissions model_has_roles naga_ebplo_business_application naga_ebplo_business_application_detail naga_ebplo_business_kind_business naga_ebplo_business_location naga_ebplo_business_occ_fees_app naga_online_application naga_online_application_docs oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens occupational_healthcert_businessname occupational_healthcert_main 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 verify_doc_setup verify_doc_setup_dtl verify_users .	select column