* id prefix fname lname mname ext bod gender address contact_number stat

* id section_name stat

* id class_type_id class_year_id subject_abr subject_name no_of_units stat ts

* id class_type sorting

* id class_type class_class stat

* id committee_report_no date title committee_description status

* id document_type documentName fileSave stats

* id mainID fileName filePath fileSize transtype thumbnail_path uid ts status

* id App_No title purpose fund department status

* id document_name status

* id document_name stats

* id attend_No attend_date attend_time category status

* id IncDocs_No title datex status

* id OutcDocs_No doc_type datex status

* id title status

* id tAndS_no to thru from subject tAndS_date status

* id transmittal_no trans_date recipient status

* id verMotion_No title term_id description datex status

* id vermotion_id pp_code attend mposition

* id uuid 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 emp_tag_id

* id uid profile_id emp_tag_id

* leave_number leave_type leave_description leave_code withPay stat with_credit leave_limit isLimited date_save

* 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

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

* SysPK_City_mun province_id zipcode_id city_mun_id city_mun_name status_name country province_area zip_code municipal_code checker citydate

* SysPK_City_mun province_id zipcode_id city_mun_id city_mun_name status_name country province_area zip_code municipal_code checker

* SysPK_Province province_id province_name province_code province_capital province_class province_area province_population region_id province_code1

* SysPK_Province province_id province_name province_code province_capital province_class province_area province_population region_id province_code1

* id brgy_id barangay purok status

* SysPK_region reg_name reg_code reg_order

* SysPK_region reg_name reg_code reg_order

* SysPK_Zipcode zipcode_id zipcode_country zipcode_province zipcode_name zipcode_location

* SysPK_Zipcode zipcode_id zipcode_country zipcode_province zipcode_name zipcode_location

* id migration batch

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

* email token created_at

* id payment_name initial_amount income_account_code income_account_description stat ts

* id section section_category section_limit stats

* id dayname abr

* SysPK_AIPCode aip_id aip_cy aip_lgutype aip_lguname aip_reference aip_lguactivitydes aip_offdep aip_startdate aip_compdate aip_expoutput aip_fundsource aip_ps aip_mooe aip_co aip_total

* ResolutionNo CategoryID LawNo

* commitee_report_no sp_member session_date title file_path type_of_report

* id term_id pp_code commitee_asign date_assign assign status

* id term_id trans_date title report_no agenda findings recommendation ts text_content

* id committee_id filename fileblob ts

* id memo_id pp_code attend

* id committe_name status

* sysPK_drf drf_id drf_date drf_name drf_add drf_r1 drf_r2 drf_r3 drf_r4 drf_signature drf_amountpaid drf_receiptno drf_releasedby

* document_id file_location

* receiving_no incoming_doc_no date_received time_received received_by department remarks

* sp_doc_id sp_doc_no document_type document_date sender subject remarks received_by date_received time_received file_path

* LawNo EffectivityDate PlaceHeld Stat ReferenceOrdNo StatusDate filename file_Location2 counter_m file_save_type title description

* id term_id trans_date agenda subject ts text_content status

* id memo_id filename fileblob ts status

* id memo_id pp_code attend mposition

* MinutesNo term_id application_date Session CalltoOrderBy CalltoOrderTime CalltoOrderDate PreviousSessionDate PlaceHeld Invocatedby EndTime Ajournedby filename file_Location2 save_date counter_m file_save_type title description content status

* Detail_id MinutesNo filename

* id date_trans pp_id ts

* id _name ordering ts visible

* id ppid username pwd _image

* term_id termfrom termto ts status

* id term_id person_no position termfrom termto ts ordering image _position status

* document_id document_no document_date title note addressee document_type

* doc_no file_location

* outgoing_received_no doc_int received_by department_code date_received time_received remarks

* id position_name status

* ProjectID ProjectName Amount SourcedFrom ModeofProcurement ProjectDescription

* ResolutionNo Sponsor CoSponsor LawNo

* ResolutionNo Movant Seconder LawNo

* LawNo EffectivityDate PlaceHeld Stat ReferenceOrdNo StatusDate filename file_Location2 counter_m file_save_type title description

* ResolutionNo approved_date trans_date PlaceHeld SessionType EffectivityDate filename file_Location2 counter_m file_save_type title_id title title2 description ts term_id category_id trans_type mins_id status amended_id resStats dateApproved datePublished

* ID res_id filename fileblob ts status

* session_id session_no session_date title description

* session_id file_path

* id term_id day_name session_type ts status

* id _type agenda _date status _color _isrecurring regid

* id _from _to _dayname status

* leave_id ref_no asOfDate sl_bal vl_bal applied_date approved_date approved_by by_authority_id employee_id contact_person contact_no purpose supervisor_comment status tmstamp dept_id position_id commutation incaseVLPhilCheck incaseVLPhilText incaseVLAbroadCheck incaseVLAbroadText incaseSLHospitalCheck incaseSLHospitalText incaseSLOutPatientCheck incaseSLOutPatientText incaseSpecialLeaveWomenText incaseStudyMastersDegreeCheck incaseStudyBARBoardCheck MonetizationLeaveCheck TerminalLeaveCheck LeaveRemarks recommended_by recommended_date certify_by certify_date wherespent declined_remarks declined_remarks_approval isWebApp dateSelected isposted

* id leave_id leave_type_id leave_date leave_dateto leave_for hrs_leave payment_mode status status_rec status_cert status_approved leave_others deductLeave

* id enrolled_id payment_setup_id amount

* id student_id student_name course_id major semesters academic_year class_year_id stat

* SysPKID pp_person_code application_date pp_student_no pp_prefix pp_lastname pp_firstname pp_middlename pp_suffix gender dob civil_stat cellno phoneno nationality religion spouseOccupation spouse mother_name mother_cellno father_name father_cellno email_add purok_id barangay_id municipal_id province_id save_by update_by cancelled_by status ts

* id enrolled_id subject_id day time_from time_to units

* id study_load_id day_name

* id travel_number date title status

* id name email email_verified_at password mobile remember_token created_at updated_at image_path facility_id facilityName approved cancel admin ts

* id uid IPX MAC ts

select table class_instructors class_section class_subject class_type class_type_year committee_report documentmanager documentmanager_file document_financial document_name1 document_setup doc_attendance doc_incoming doc_outgoing doc_recording doc_trainseminar doc_transmittal doc_verbalmotion doc_verbalmotion_dtls failed_jobs form_name form_profile form_profile_access form_user_profile form_user_profile_tag hr_emp_leave_type lgu_brgy_setup lgu_brgy_setup_temp lgu_city_mun_setup lgu_city_mun_setup_temp lgu_province_setup lgu_province_setup_temp lgu_purok_setup lgu_region_setup lgu_region_setup_temp lgu_zipcode_setup lgu_zipcode_setup_temp migrations oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens password_resets payment_setup p_tbl_section setup_day sp_aip sp_category sp_commitee_report sp_committee_assign sp_committee_report sp_committee_report_attach sp_committee_report_details sp_committe_setup sp_document_request_form2012 sp_incoming_document_details sp_incoming_document_receiving sp_incoming_document_tracking sp_law sp_memorandum sp_memorandum_attach sp_memorandum_details sp_minutes sp_minutesdetail sp_official_attendance sp_official_name sp_official_password sp_official_setup sp_official_setup2 sp_outgoing_document sp_outgoing_document_details sp_outgoing_receiving sp_position sp_projectsupply sp_proponents sp_proponents_ms sp_quasi sp_resolution sp_resolution_files sp_session sp_session_details sp_session_setup sp_special_date sp_special_date_reg tbl_leaves tbl_leaves_dtl tbl_student_enrolled_assessment tbl_student_enrolled_main tbl_student_setup tbl_student_study_load tbl_student_study_load_days travel users user_logs . 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 class_instructors class_section class_subject class_type class_type_year committee_report documentmanager documentmanager_file document_financial document_name1 document_setup doc_attendance doc_incoming doc_outgoing doc_recording doc_trainseminar doc_transmittal doc_verbalmotion doc_verbalmotion_dtls failed_jobs form_name form_profile form_profile_access form_user_profile form_user_profile_tag hr_emp_leave_type lgu_brgy_setup lgu_brgy_setup_temp lgu_city_mun_setup lgu_city_mun_setup_temp lgu_province_setup lgu_province_setup_temp lgu_purok_setup lgu_region_setup lgu_region_setup_temp lgu_zipcode_setup lgu_zipcode_setup_temp migrations oauth_access_tokens oauth_auth_codes oauth_clients oauth_personal_access_clients oauth_refresh_tokens password_resets payment_setup p_tbl_section setup_day sp_aip sp_category sp_commitee_report sp_committee_assign sp_committee_report sp_committee_report_attach sp_committee_report_details sp_committe_setup sp_document_request_form2012 sp_incoming_document_details sp_incoming_document_receiving sp_incoming_document_tracking sp_law sp_memorandum sp_memorandum_attach sp_memorandum_details sp_minutes sp_minutesdetail sp_official_attendance sp_official_name sp_official_password sp_official_setup sp_official_setup2 sp_outgoing_document sp_outgoing_document_details sp_outgoing_receiving sp_position sp_projectsupply sp_proponents sp_proponents_ms sp_quasi sp_resolution sp_resolution_files sp_session sp_session_details sp_session_setup sp_special_date sp_special_date_reg tbl_leaves tbl_leaves_dtl tbl_student_enrolled_assessment tbl_student_enrolled_main tbl_student_setup tbl_student_study_load tbl_student_study_load_days travel users user_logs .	select column