* id empno cano Amount Dates pid

* id Type empno Drequested Dneeded Adesired Reason Remarks Until Aapproved ApprovedBy ptype Balance

* id EMPNO NAME POS DEPT CLASS SSS TIN PHIC HDMF TALLOWANCE CALLOWANCE MALLOWANCE CGIFT SVLEAVE PIC BRANCH ACCNO STATUS DHIRED

* id empno mrate hrate

* id empno Amount

* id empno Amount CutOff

* id empno DFrom DTo Pdate Mrate Prate Dept BasicPay OS AddOthers Tallowance Callowance Mallowance CGift SVL Absences Lates Tax SSS PHIC HDMF CA DeductOthers TIncome TDeduct NetPay Savings Branch Type nabsent nlate nundertime nhours sssloan nos undertime gentype calump cainstall

* id empno Amount BALANCE STATUS Deduction

* id empno amount paydate

* id date time user Log Data Ref

* id nextevent date

* id studid sy sem about

* id userid Name Status ip

* id Froms Tos Message Status

* id from to message sent read direction

* id announcement time to

* id channel message sent

* id fromid toid

* id userid chatroomid message sent

* id name lastactivity createdby password type vidsession

* userid chatroomid lastactivity

* id channel message sent

* userid score games recentlist highscorelist

* id name lastactivity

* id from to message sent read direction

* userid message status typingto typingtime

* username identity timestamp

* course_id course_name course_description course_year active

* courseId courseCode courseTitle sem course status year deletes units degree lab type

* courseId courseCode courseTitle sem course status year deletes units degree lab type

* id about status

* id stud_id name discount course

* id stud_id Sem Sy Units Total TF Misc Prev Discount Others lab

* id EmpNo Name Status Birthdate Department TIN SSS PHIC HDMF mRate hRate

* enrol_id stud_id stud_name sems year section subject course year_enroled sub_id courseTitle status date degree sy

* enrol_id stud_id stud_name sems year section subject course year_enroled sub_id courseTitle status date degree sy

* enrol_del stud_id stud_name sems year section subject course year_enroled sub_id courseTitle date degree

* enrolled_id stud_id stud_name sems section subject course year_enrolled sub_id courseTitle date degree year

* file_id file date froms purpose from_id

* id subjectCode courseTitle sem units status

* id subjectCode courseTitle sem units status

* id stud_id sec_id sygrad sectionname secidd semgrad

* id stud_id sec_id sygrad sectionname secidd semgrad

* gId subject course section prof_id prelim midterm finals prelim_date midterm_date final_date year sems status coursecode

* grade_del

* grade_id name subject course sem year prelim midterm final total_grade remarks course_code prof_id section stud_id final_output status

* grade_id name subject course sem year prelim midterm final total_grade remarks course_code prof_id section stud_id final_output status

* grade_id name subject course sem year prelim midterm final total_grade remarks course_code prof_id section stud_id final_output status

* gssId section subject status sub_id coursecode year_entered room day time units sem degree prof prof_id max current sy timefrom timeend secid

* grade_id name Subject sem year prelim midterm final total_grade remarks course_code Prof_id section stud_id final_output status

* id username email password_hash created_at status role

* id scode subject glvl sem status lab course type

* id stud_id section glvl sy status date_enrolled sem balance

* id section strand glvl sem sy status

* hs_id hs_grade_lvl hs_stat

* id subject status jslvl lab

* id Amount Particulars SY stud_id

* id section lvl status sy

* id stud_id section glvl sy status date_enrolled Balance

* id ACCNO CLASS AUTHOR TITLE PAGES PUBLISHER YEAR REMARKS DATERECEIVED EDITION VOLUME SOF COST quan

* id stud_id Name Intime Outtime Dates Status

* id AccNo Dborrowed Rborrowed BorrowerID DateDue Status Type

* id name username password division last_login last_logout lastactivity status fixed hrs address bday email contact EmpNumber SSS TIN empno pic

* log_id done date person per_id person_edit person_edit_id

* id userid button panel btnfont panelfont

* ID STUDID SY SEM PARTICULARS TYPE STATUS AMOUNT

* p_new_id title info date_post status pic

* pay_id amount orNo date time stud_id sem year course method downpayment sy status

* pay_id stud_id stud_name units sem year course balance total misc others ds1 lab cancel deducted ds2 ds3 ds4 ds5 ds6 printed per_unit per_lab total_unit temp_balance total_others transfer_to other_dis promo p_type class_type classtypebalance

* id stud_id sy sem term date_received

* ID STUD_ID FRM CARD PSA GM TWOPIC ONEPIC PNV CLASS REMARKS GRADE STRAND SECTION STATUS FRM_PDF CARD_PDF PSA_PDF GM_PDF TWOPIC_PDF PNV_PDF

* id reserve_cnt sy sem status lvl course date

* stud_cnt name course contact email year gender bday province brgy municipality lvl street district town Guardian LRN gcontact institution voucher School estatus mname prevsec prevadviser

* ID STUD_ID FRM CARD PSA GM TWOPIC ONEPIC PNV CLASS REMARKS GRADE STRAND SECTION STATUS

* rule_id activity date stat sem

* id_act activities day status year

* sec_id sectionName course sem year year_entered status degree sy isLocked

* id courseid Time Day Prof Room Max Section Sem SY isLocked status

* ssId section course subject year status sub_id coursecode year_entered room day time units sem degree prof prof_id max current sy timefrom timeend secid

* ssId section course subject year status sub_id coursecode year_entered room day time units sem degree prof prof_id max current sy timefrom timeend secid

* id Filename upid Uploader Viewer uploadDate vid Status

* id student_number account_status section lrn last_name first_name middle_name grade_10_school birthday address student_contact_number guardian_contact_number parents_guardian four_ps date_enrolled school_year remaining_balance tuition_fee referred_by birth_certificate card_form_138 good_moral_certificate pic_1x1_2pcs pic_2x2_2pcs form_137 created_at grade_10_section

* id stud_id sy sems exam_period file_path uploaded_at

* id status activity date student_id

* stud_cnt name course year_enrolled address contact email stud_id status year gender pic bday password province brgy municipality civil age lvl street district town Guardian LRN gcontact institution voucher School estatus yrgrad crsgrad mname prevsec prevadviser

* stud_cnt name course year_enrolled address contact email stud_id status year gender pic bday password province brgy municipality civil age lvl street district town Guardian LRN gcontact institution voucher School estatus yrgrad crsgrad mname prevsec

* violation_record_id stud_id type_id violation_description violation_date duration status school_year gender

* remove_id name course year_enrolled address contact email stud_id year gender pic bday password province brgy municipality civil age lvl

* sysVerID sysVerNumber sysVerDate Description Uploader

* ID SN NAME COURSE STUD_ID DG DR CLASS

* id StudID Section SubID EnrolledID

* id StudID Sem Sy Grade EnrollmentPayment

* ID SN Stud_id Name DG Competency DR Course

* id name studid

* SID NAME COURSE TIMEINS TIMEOUTS STATUS DATESS ID

* upId amount date sem type owner

* type_id violation_name sanction_description sanction_1st_offense sanction_2nd_offense sanction_3rd_offense sanction_final_offense offense_category department

* id voucher_code mac_address used_at duration_minutes

select table acccapayment acccashadvance accempprofile accemprate accempsavings accempsavingshistory accpayroll accsssloan accsssloanpayment activitylogs calendarschool cashiernote chattech chattechmsg cometchat cometchat_announcements cometchat_apehistory cometchat_block cometchat_chatroommessages cometchat_chatrooms cometchat_chatrooms_users cometchat_comethistory cometchat_games cometchat_guests cometchat_messages_old cometchat_status cometchat_videochatsessions course curriculum curriculum(copy) dashboard_rules discounts earnerassessment empprofile enrolled enrolled(copy) enrolled_delete enrolled_drop file_name gradcurriculum gradcurriculum(copy) gradenlistment gradenlistment(copy) grade_checker grade_delete grade_segregation grade_segregation(copy) grade_segregation_test gradsection_subject grad_grade_segregation guidancelogin high_curri high_enrolled high_section hs_grade jhs_curri jsothers js_section junior_enrolled libaccession libinout librecords login_personel logs mytheme otherscollege page_news payment payment_enrolled permit_receives requirements reservationhistory reservation_record reservation_req rules_table school_act section sectiongrad section_subject section_subject(copy) sharedfiles students_shs student_attachments student_case student_record student_record(copy) student_violations studen_remove systemversion tblched tblhenrolled tblshenrolledlist tbltesda test timeinandout upaid_cash violation_types wifi_vouchers . 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 acccapayment acccashadvance accempprofile accemprate accempsavings accempsavingshistory accpayroll accsssloan accsssloanpayment activitylogs calendarschool cashiernote chattech chattechmsg cometchat cometchat_announcements cometchat_apehistory cometchat_block cometchat_chatroommessages cometchat_chatrooms cometchat_chatrooms_users cometchat_comethistory cometchat_games cometchat_guests cometchat_messages_old cometchat_status cometchat_videochatsessions course curriculum curriculum(copy) dashboard_rules discounts earnerassessment empprofile enrolled enrolled(copy) enrolled_delete enrolled_drop file_name gradcurriculum gradcurriculum(copy) gradenlistment gradenlistment(copy) grade_checker grade_delete grade_segregation grade_segregation(copy) grade_segregation_test gradsection_subject grad_grade_segregation guidancelogin high_curri high_enrolled high_section hs_grade jhs_curri jsothers js_section junior_enrolled libaccession libinout librecords login_personel logs mytheme otherscollege page_news payment payment_enrolled permit_receives requirements reservationhistory reservation_record reservation_req rules_table school_act section sectiongrad section_subject section_subject(copy) sharedfiles students_shs student_attachments student_case student_record student_record(copy) student_violations studen_remove systemversion tblched tblhenrolled tblshenrolledlist tbltesda test timeinandout upaid_cash violation_types wifi_vouchers .	select column