Recent
There are no recent tables.
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: online_hr
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`class_instructors`.*
`class_instructors`.`id`
`class_instructors`.`prefix`
`class_instructors`.`fname`
`class_instructors`.`lname`
`class_instructors`.`mname`
`class_instructors`.`ext`
`class_instructors`.`bod`
`class_instructors`.`gender`
`class_instructors`.`address`
`class_instructors`.`contact_number`
`class_instructors`.`stat`
`class_section`.*
`class_section`.`id`
`class_section`.`section_name`
`class_section`.`stat`
`class_subject`.*
`class_subject`.`id`
`class_subject`.`class_type_id`
`class_subject`.`class_year_id`
`class_subject`.`subject_abr`
`class_subject`.`subject_name`
`class_subject`.`no_of_units`
`class_subject`.`stat`
`class_subject`.`ts`
`class_type`.*
`class_type`.`id`
`class_type`.`class_type`
`class_type`.`sorting`
`class_type_year`.*
`class_type_year`.`id`
`class_type_year`.`class_type`
`class_type_year`.`class_class`
`class_type_year`.`stat`
`committee_report`.*
`committee_report`.`id`
`committee_report`.`committee_report_no`
`committee_report`.`date`
`committee_report`.`title`
`committee_report`.`committee_description`
`committee_report`.`status`
`doc_attendance`.*
`doc_attendance`.`id`
`doc_attendance`.`attend_No`
`doc_attendance`.`attend_date`
`doc_attendance`.`attend_time`
`doc_attendance`.`category`
`doc_attendance`.`status`
`doc_incoming`.*
`doc_incoming`.`id`
`doc_incoming`.`IncDocs_No`
`doc_incoming`.`title`
`doc_incoming`.`datex`
`doc_incoming`.`status`
`doc_outgoing`.*
`doc_outgoing`.`id`
`doc_outgoing`.`OutcDocs_No`
`doc_outgoing`.`doc_type`
`doc_outgoing`.`datex`
`doc_outgoing`.`status`
`doc_recording`.*
`doc_recording`.`id`
`doc_recording`.`title`
`doc_recording`.`status`
`doc_trainseminar`.*
`doc_trainseminar`.`id`
`doc_trainseminar`.`tAndS_no`
`doc_trainseminar`.`to`
`doc_trainseminar`.`thru`
`doc_trainseminar`.`from`
`doc_trainseminar`.`subject`
`doc_trainseminar`.`tAndS_date`
`doc_trainseminar`.`status`
`doc_transmittal`.*
`doc_transmittal`.`id`
`doc_transmittal`.`transmittal_no`
`doc_transmittal`.`trans_date`
`doc_transmittal`.`recipient`
`doc_transmittal`.`status`
`doc_verbalmotion`.*
`doc_verbalmotion`.`id`
`doc_verbalmotion`.`verMotion_No`
`doc_verbalmotion`.`title`
`doc_verbalmotion`.`term_id`
`doc_verbalmotion`.`description`
`doc_verbalmotion`.`datex`
`doc_verbalmotion`.`status`
`doc_verbalmotion_dtls`.*
`doc_verbalmotion_dtls`.`id`
`doc_verbalmotion_dtls`.`vermotion_id`
`doc_verbalmotion_dtls`.`pp_code`
`doc_verbalmotion_dtls`.`attend`
`doc_verbalmotion_dtls`.`mposition`
`document_financial`.*
`document_financial`.`id`
`document_financial`.`App_No`
`document_financial`.`title`
`document_financial`.`purpose`
`document_financial`.`fund`
`document_financial`.`department`
`document_financial`.`status`
`document_name1`.*
`document_name1`.`id`
`document_name1`.`document_name`
`document_name1`.`status`
`document_setup`.*
`document_setup`.`id`
`document_setup`.`document_name`
`document_setup`.`stats`
`documentmanager`.*
`documentmanager`.`id`
`documentmanager`.`document_type`
`documentmanager`.`documentName`
`documentmanager`.`fileSave`
`documentmanager`.`stats`
`documentmanager_file`.*
`documentmanager_file`.`id`
`documentmanager_file`.`mainID`
`documentmanager_file`.`fileName`
`documentmanager_file`.`filePath`
`documentmanager_file`.`fileSize`
`documentmanager_file`.`transtype`
`documentmanager_file`.`thumbnail_path`
`documentmanager_file`.`uid`
`documentmanager_file`.`ts`
`documentmanager_file`.`status`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`form_user_profile`.`emp_tag_id`
`form_user_profile_tag`.*
`form_user_profile_tag`.`id`
`form_user_profile_tag`.`uid`
`form_user_profile_tag`.`profile_id`
`form_user_profile_tag`.`emp_tag_id`
`hr_emp_leave_type`.*
`hr_emp_leave_type`.`leave_number`
`hr_emp_leave_type`.`leave_type`
`hr_emp_leave_type`.`leave_description`
`hr_emp_leave_type`.`leave_code`
`hr_emp_leave_type`.`withPay`
`hr_emp_leave_type`.`stat`
`hr_emp_leave_type`.`with_credit`
`hr_emp_leave_type`.`leave_limit`
`hr_emp_leave_type`.`isLimited`
`hr_emp_leave_type`.`date_save`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`bank_name`
`lgu_brgy_setup`.`bank_account_no`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_brgy_setup`.`qr_brgy_id`
`lgu_brgy_setup_temp`.*
`lgu_brgy_setup_temp`.`SysPK_Brgy`
`lgu_brgy_setup_temp`.`city_mun_id`
`lgu_brgy_setup_temp`.`brgy_id`
`lgu_brgy_setup_temp`.`brgy_name`
`lgu_brgy_setup_temp`.`checker`
`lgu_brgy_setup_temp`.`brgy_code`
`lgu_brgy_setup_temp`.`URBAN_RURAL`
`lgu_brgy_setup_temp`.`POPULATION`
`lgu_brgy_setup_temp`.`CITY`
`lgu_brgy_setup_temp`.`PROVINCE`
`lgu_brgy_setup_temp`.`REGION`
`lgu_brgy_setup_temp`.`person_code`
`lgu_brgy_setup_temp`.`stat`
`lgu_brgy_setup_temp`.`brgy_code1`
`lgu_city_mun_setup`.*
`lgu_city_mun_setup`.`SysPK_City_mun`
`lgu_city_mun_setup`.`province_id`
`lgu_city_mun_setup`.`zipcode_id`
`lgu_city_mun_setup`.`city_mun_id`
`lgu_city_mun_setup`.`city_mun_name`
`lgu_city_mun_setup`.`status_name`
`lgu_city_mun_setup`.`country`
`lgu_city_mun_setup`.`province_area`
`lgu_city_mun_setup`.`zip_code`
`lgu_city_mun_setup`.`municipal_code`
`lgu_city_mun_setup`.`checker`
`lgu_city_mun_setup`.`citydate`
`lgu_city_mun_setup_temp`.*
`lgu_city_mun_setup_temp`.`SysPK_City_mun`
`lgu_city_mun_setup_temp`.`province_id`
`lgu_city_mun_setup_temp`.`zipcode_id`
`lgu_city_mun_setup_temp`.`city_mun_id`
`lgu_city_mun_setup_temp`.`city_mun_name`
`lgu_city_mun_setup_temp`.`status_name`
`lgu_city_mun_setup_temp`.`country`
`lgu_city_mun_setup_temp`.`province_area`
`lgu_city_mun_setup_temp`.`zip_code`
`lgu_city_mun_setup_temp`.`municipal_code`
`lgu_city_mun_setup_temp`.`checker`
`lgu_province_setup`.*
`lgu_province_setup`.`SysPK_Province`
`lgu_province_setup`.`province_id`
`lgu_province_setup`.`province_name`
`lgu_province_setup`.`province_code`
`lgu_province_setup`.`province_capital`
`lgu_province_setup`.`province_class`
`lgu_province_setup`.`province_area`
`lgu_province_setup`.`province_population`
`lgu_province_setup`.`region_id`
`lgu_province_setup`.`province_code1`
`lgu_province_setup_temp`.*
`lgu_province_setup_temp`.`SysPK_Province`
`lgu_province_setup_temp`.`province_id`
`lgu_province_setup_temp`.`province_name`
`lgu_province_setup_temp`.`province_code`
`lgu_province_setup_temp`.`province_capital`
`lgu_province_setup_temp`.`province_class`
`lgu_province_setup_temp`.`province_area`
`lgu_province_setup_temp`.`province_population`
`lgu_province_setup_temp`.`region_id`
`lgu_province_setup_temp`.`province_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`lgu_region_setup`.*
`lgu_region_setup`.`SysPK_region`
`lgu_region_setup`.`reg_name`
`lgu_region_setup`.`reg_code`
`lgu_region_setup`.`reg_order`
`lgu_region_setup_temp`.*
`lgu_region_setup_temp`.`SysPK_region`
`lgu_region_setup_temp`.`reg_name`
`lgu_region_setup_temp`.`reg_code`
`lgu_region_setup_temp`.`reg_order`
`lgu_zipcode_setup`.*
`lgu_zipcode_setup`.`SysPK_Zipcode`
`lgu_zipcode_setup`.`zipcode_id`
`lgu_zipcode_setup`.`zipcode_country`
`lgu_zipcode_setup`.`zipcode_province`
`lgu_zipcode_setup`.`zipcode_name`
`lgu_zipcode_setup`.`zipcode_location`
`lgu_zipcode_setup_temp`.*
`lgu_zipcode_setup_temp`.`SysPK_Zipcode`
`lgu_zipcode_setup_temp`.`zipcode_id`
`lgu_zipcode_setup_temp`.`zipcode_country`
`lgu_zipcode_setup_temp`.`zipcode_province`
`lgu_zipcode_setup_temp`.`zipcode_name`
`lgu_zipcode_setup_temp`.`zipcode_location`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`p_tbl_section`.*
`p_tbl_section`.`id`
`p_tbl_section`.`section`
`p_tbl_section`.`section_category`
`p_tbl_section`.`section_limit`
`p_tbl_section`.`stats`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payment_setup`.*
`payment_setup`.`id`
`payment_setup`.`payment_name`
`payment_setup`.`initial_amount`
`payment_setup`.`income_account_code`
`payment_setup`.`income_account_description`
`payment_setup`.`stat`
`payment_setup`.`ts`
`setup_day`.*
`setup_day`.`id`
`setup_day`.`dayname`
`setup_day`.`abr`
`sp_aip`.*
`sp_aip`.`SysPK_AIPCode`
`sp_aip`.`aip_id`
`sp_aip`.`aip_cy`
`sp_aip`.`aip_lgutype`
`sp_aip`.`aip_lguname`
`sp_aip`.`aip_reference`
`sp_aip`.`aip_lguactivitydes`
`sp_aip`.`aip_offdep`
`sp_aip`.`aip_startdate`
`sp_aip`.`aip_compdate`
`sp_aip`.`aip_expoutput`
`sp_aip`.`aip_fundsource`
`sp_aip`.`aip_ps`
`sp_aip`.`aip_mooe`
`sp_aip`.`aip_co`
`sp_aip`.`aip_total`
`sp_category`.*
`sp_category`.`ResolutionNo`
`sp_category`.`CategoryID`
`sp_category`.`LawNo`
`sp_commitee_report`.*
`sp_commitee_report`.`commitee_report_no`
`sp_commitee_report`.`sp_member`
`sp_commitee_report`.`session_date`
`sp_commitee_report`.`title`
`sp_commitee_report`.`file_path`
`sp_commitee_report`.`type_of_report`
`sp_committe_setup`.*
`sp_committe_setup`.`id`
`sp_committe_setup`.`committe_name`
`sp_committe_setup`.`status`
`sp_committee_assign`.*
`sp_committee_assign`.`id`
`sp_committee_assign`.`term_id`
`sp_committee_assign`.`pp_code`
`sp_committee_assign`.`commitee_asign`
`sp_committee_assign`.`date_assign`
`sp_committee_assign`.`assign`
`sp_committee_assign`.`status`
`sp_committee_report`.*
`sp_committee_report`.`id`
`sp_committee_report`.`term_id`
`sp_committee_report`.`trans_date`
`sp_committee_report`.`title`
`sp_committee_report`.`report_no`
`sp_committee_report`.`agenda`
`sp_committee_report`.`findings`
`sp_committee_report`.`recommendation`
`sp_committee_report`.`ts`
`sp_committee_report`.`text_content`
`sp_committee_report_attach`.*
`sp_committee_report_attach`.`id`
`sp_committee_report_attach`.`committee_id`
`sp_committee_report_attach`.`filename`
`sp_committee_report_attach`.`fileblob`
`sp_committee_report_attach`.`ts`
`sp_committee_report_details`.*
`sp_committee_report_details`.`id`
`sp_committee_report_details`.`memo_id`
`sp_committee_report_details`.`pp_code`
`sp_committee_report_details`.`attend`
`sp_document_request_form2012`.*
`sp_document_request_form2012`.`sysPK_drf`
`sp_document_request_form2012`.`drf_id`
`sp_document_request_form2012`.`drf_date`
`sp_document_request_form2012`.`drf_name`
`sp_document_request_form2012`.`drf_add`
`sp_document_request_form2012`.`drf_r1`
`sp_document_request_form2012`.`drf_r2`
`sp_document_request_form2012`.`drf_r3`
`sp_document_request_form2012`.`drf_r4`
`sp_document_request_form2012`.`drf_signature`
`sp_document_request_form2012`.`drf_amountpaid`
`sp_document_request_form2012`.`drf_receiptno`
`sp_document_request_form2012`.`drf_releasedby`
`sp_incoming_document_details`.*
`sp_incoming_document_details`.`document_id`
`sp_incoming_document_details`.`file_location`
`sp_incoming_document_receiving`.*
`sp_incoming_document_receiving`.`receiving_no`
`sp_incoming_document_receiving`.`incoming_doc_no`
`sp_incoming_document_receiving`.`date_received`
`sp_incoming_document_receiving`.`time_received`
`sp_incoming_document_receiving`.`received_by`
`sp_incoming_document_receiving`.`department`
`sp_incoming_document_receiving`.`remarks`
`sp_incoming_document_tracking`.*
`sp_incoming_document_tracking`.`sp_doc_id`
`sp_incoming_document_tracking`.`sp_doc_no`
`sp_incoming_document_tracking`.`document_type`
`sp_incoming_document_tracking`.`document_date`
`sp_incoming_document_tracking`.`sender`
`sp_incoming_document_tracking`.`subject`
`sp_incoming_document_tracking`.`remarks`
`sp_incoming_document_tracking`.`received_by`
`sp_incoming_document_tracking`.`date_received`
`sp_incoming_document_tracking`.`time_received`
`sp_incoming_document_tracking`.`file_path`
`sp_law`.*
`sp_law`.`LawNo`
`sp_law`.`EffectivityDate`
`sp_law`.`PlaceHeld`
`sp_law`.`Stat`
`sp_law`.`ReferenceOrdNo`
`sp_law`.`StatusDate`
`sp_law`.`filename`
`sp_law`.`file_Location2`
`sp_law`.`counter_m`
`sp_law`.`file_save_type`
`sp_law`.`title`
`sp_law`.`description`
`sp_memorandum`.*
`sp_memorandum`.`id`
`sp_memorandum`.`term_id`
`sp_memorandum`.`trans_date`
`sp_memorandum`.`agenda`
`sp_memorandum`.`subject`
`sp_memorandum`.`ts`
`sp_memorandum`.`text_content`
`sp_memorandum`.`status`
`sp_memorandum_attach`.*
`sp_memorandum_attach`.`id`
`sp_memorandum_attach`.`memo_id`
`sp_memorandum_attach`.`filename`
`sp_memorandum_attach`.`fileblob`
`sp_memorandum_attach`.`ts`
`sp_memorandum_attach`.`status`
`sp_memorandum_details`.*
`sp_memorandum_details`.`id`
`sp_memorandum_details`.`memo_id`
`sp_memorandum_details`.`pp_code`
`sp_memorandum_details`.`attend`
`sp_memorandum_details`.`mposition`
`sp_minutes`.*
`sp_minutes`.`MinutesNo`
`sp_minutes`.`term_id`
`sp_minutes`.`application_date`
`sp_minutes`.`Session`
`sp_minutes`.`CalltoOrderBy`
`sp_minutes`.`CalltoOrderTime`
`sp_minutes`.`CalltoOrderDate`
`sp_minutes`.`PreviousSessionDate`
`sp_minutes`.`PlaceHeld`
`sp_minutes`.`Invocatedby`
`sp_minutes`.`EndTime`
`sp_minutes`.`Ajournedby`
`sp_minutes`.`filename`
`sp_minutes`.`file_Location2`
`sp_minutes`.`save_date`
`sp_minutes`.`counter_m`
`sp_minutes`.`file_save_type`
`sp_minutes`.`title`
`sp_minutes`.`description`
`sp_minutes`.`content`
`sp_minutes`.`status`
`sp_minutesdetail`.*
`sp_minutesdetail`.`Detail_id`
`sp_minutesdetail`.`MinutesNo`
`sp_minutesdetail`.`filename`
`sp_official_attendance`.*
`sp_official_attendance`.`id`
`sp_official_attendance`.`date_trans`
`sp_official_attendance`.`pp_id`
`sp_official_attendance`.`ts`
`sp_official_name`.*
`sp_official_name`.`id`
`sp_official_name`.`_name`
`sp_official_name`.`ordering`
`sp_official_name`.`ts`
`sp_official_name`.`visible`
`sp_official_password`.*
`sp_official_password`.`id`
`sp_official_password`.`ppid`
`sp_official_password`.`username`
`sp_official_password`.`pwd`
`sp_official_password`.`_image`
`sp_official_setup`.*
`sp_official_setup`.`term_id`
`sp_official_setup`.`termfrom`
`sp_official_setup`.`termto`
`sp_official_setup`.`ts`
`sp_official_setup`.`status`
`sp_official_setup2`.*
`sp_official_setup2`.`id`
`sp_official_setup2`.`term_id`
`sp_official_setup2`.`person_no`
`sp_official_setup2`.`position`
`sp_official_setup2`.`termfrom`
`sp_official_setup2`.`termto`
`sp_official_setup2`.`ts`
`sp_official_setup2`.`ordering`
`sp_official_setup2`.`image`
`sp_official_setup2`.`_position`
`sp_official_setup2`.`status`
`sp_outgoing_document`.*
`sp_outgoing_document`.`document_id`
`sp_outgoing_document`.`document_no`
`sp_outgoing_document`.`document_date`
`sp_outgoing_document`.`title`
`sp_outgoing_document`.`note`
`sp_outgoing_document`.`addressee`
`sp_outgoing_document`.`document_type`
`sp_outgoing_document_details`.*
`sp_outgoing_document_details`.`doc_no`
`sp_outgoing_document_details`.`file_location`
`sp_outgoing_receiving`.*
`sp_outgoing_receiving`.`outgoing_received_no`
`sp_outgoing_receiving`.`doc_int`
`sp_outgoing_receiving`.`received_by`
`sp_outgoing_receiving`.`department_code`
`sp_outgoing_receiving`.`date_received`
`sp_outgoing_receiving`.`time_received`
`sp_outgoing_receiving`.`remarks`
`sp_position`.*
`sp_position`.`id`
`sp_position`.`position_name`
`sp_position`.`status`
`sp_projectsupply`.*
`sp_projectsupply`.`ProjectID`
`sp_projectsupply`.`ProjectName`
`sp_projectsupply`.`Amount`
`sp_projectsupply`.`SourcedFrom`
`sp_projectsupply`.`ModeofProcurement`
`sp_projectsupply`.`ProjectDescription`
`sp_proponents`.*
`sp_proponents`.`ResolutionNo`
`sp_proponents`.`Sponsor`
`sp_proponents`.`CoSponsor`
`sp_proponents`.`LawNo`
`sp_proponents_ms`.*
`sp_proponents_ms`.`ResolutionNo`
`sp_proponents_ms`.`Movant`
`sp_proponents_ms`.`Seconder`
`sp_proponents_ms`.`LawNo`
`sp_quasi`.*
`sp_quasi`.`LawNo`
`sp_quasi`.`EffectivityDate`
`sp_quasi`.`PlaceHeld`
`sp_quasi`.`Stat`
`sp_quasi`.`ReferenceOrdNo`
`sp_quasi`.`StatusDate`
`sp_quasi`.`filename`
`sp_quasi`.`file_Location2`
`sp_quasi`.`counter_m`
`sp_quasi`.`file_save_type`
`sp_quasi`.`title`
`sp_quasi`.`description`
`sp_resolution`.*
`sp_resolution`.`ResolutionNo`
`sp_resolution`.`approved_date`
`sp_resolution`.`trans_date`
`sp_resolution`.`PlaceHeld`
`sp_resolution`.`SessionType`
`sp_resolution`.`EffectivityDate`
`sp_resolution`.`filename`
`sp_resolution`.`file_Location2`
`sp_resolution`.`counter_m`
`sp_resolution`.`file_save_type`
`sp_resolution`.`title_id`
`sp_resolution`.`title`
`sp_resolution`.`title2`
`sp_resolution`.`description`
`sp_resolution`.`ts`
`sp_resolution`.`term_id`
`sp_resolution`.`category_id`
`sp_resolution`.`trans_type`
`sp_resolution`.`mins_id`
`sp_resolution`.`status`
`sp_resolution`.`amended_id`
`sp_resolution`.`resStats`
`sp_resolution`.`dateApproved`
`sp_resolution`.`datePublished`
`sp_resolution_files`.*
`sp_resolution_files`.`ID`
`sp_resolution_files`.`res_id`
`sp_resolution_files`.`filename`
`sp_resolution_files`.`fileblob`
`sp_resolution_files`.`ts`
`sp_resolution_files`.`status`
`sp_session`.*
`sp_session`.`session_id`
`sp_session`.`session_no`
`sp_session`.`session_date`
`sp_session`.`title`
`sp_session`.`description`
`sp_session_details`.*
`sp_session_details`.`session_id`
`sp_session_details`.`file_path`
`sp_session_setup`.*
`sp_session_setup`.`id`
`sp_session_setup`.`term_id`
`sp_session_setup`.`day_name`
`sp_session_setup`.`session_type`
`sp_session_setup`.`ts`
`sp_session_setup`.`status`
`sp_special_date`.*
`sp_special_date`.`id`
`sp_special_date`.`_type`
`sp_special_date`.`agenda`
`sp_special_date`.`_date`
`sp_special_date`.`status`
`sp_special_date`.`_color`
`sp_special_date`.`_isrecurring`
`sp_special_date`.`regid`
`sp_special_date_reg`.*
`sp_special_date_reg`.`id`
`sp_special_date_reg`.`_from`
`sp_special_date_reg`.`_to`
`sp_special_date_reg`.`_dayname`
`sp_special_date_reg`.`status`
`tbl_leaves`.*
`tbl_leaves`.`leave_id`
`tbl_leaves`.`ref_no`
`tbl_leaves`.`asOfDate`
`tbl_leaves`.`sl_bal`
`tbl_leaves`.`vl_bal`
`tbl_leaves`.`applied_date`
`tbl_leaves`.`approved_date`
`tbl_leaves`.`approved_by`
`tbl_leaves`.`by_authority_id`
`tbl_leaves`.`employee_id`
`tbl_leaves`.`contact_person`
`tbl_leaves`.`contact_no`
`tbl_leaves`.`purpose`
`tbl_leaves`.`supervisor_comment`
`tbl_leaves`.`status`
`tbl_leaves`.`tmstamp`
`tbl_leaves`.`dept_id`
`tbl_leaves`.`position_id`
`tbl_leaves`.`commutation`
`tbl_leaves`.`incaseVLPhilCheck`
`tbl_leaves`.`incaseVLPhilText`
`tbl_leaves`.`incaseVLAbroadCheck`
`tbl_leaves`.`incaseVLAbroadText`
`tbl_leaves`.`incaseSLHospitalCheck`
`tbl_leaves`.`incaseSLHospitalText`
`tbl_leaves`.`incaseSLOutPatientCheck`
`tbl_leaves`.`incaseSLOutPatientText`
`tbl_leaves`.`incaseSpecialLeaveWomenText`
`tbl_leaves`.`incaseStudyMastersDegreeCheck`
`tbl_leaves`.`incaseStudyBARBoardCheck`
`tbl_leaves`.`MonetizationLeaveCheck`
`tbl_leaves`.`TerminalLeaveCheck`
`tbl_leaves`.`LeaveRemarks`
`tbl_leaves`.`recommended_by`
`tbl_leaves`.`recommended_date`
`tbl_leaves`.`certify_by`
`tbl_leaves`.`certify_date`
`tbl_leaves`.`wherespent`
`tbl_leaves`.`declined_remarks`
`tbl_leaves`.`declined_remarks_approval`
`tbl_leaves`.`isWebApp`
`tbl_leaves`.`dateSelected`
`tbl_leaves`.`isposted`
`tbl_leaves_dtl`.*
`tbl_leaves_dtl`.`id`
`tbl_leaves_dtl`.`leave_id`
`tbl_leaves_dtl`.`leave_type_id`
`tbl_leaves_dtl`.`leave_date`
`tbl_leaves_dtl`.`leave_dateto`
`tbl_leaves_dtl`.`leave_for`
`tbl_leaves_dtl`.`hrs_leave`
`tbl_leaves_dtl`.`payment_mode`
`tbl_leaves_dtl`.`status`
`tbl_leaves_dtl`.`status_rec`
`tbl_leaves_dtl`.`status_cert`
`tbl_leaves_dtl`.`status_approved`
`tbl_leaves_dtl`.`leave_others`
`tbl_leaves_dtl`.`deductLeave`
`tbl_student_enrolled_assessment`.*
`tbl_student_enrolled_assessment`.`id`
`tbl_student_enrolled_assessment`.`enrolled_id`
`tbl_student_enrolled_assessment`.`payment_setup_id`
`tbl_student_enrolled_assessment`.`amount`
`tbl_student_enrolled_main`.*
`tbl_student_enrolled_main`.`id`
`tbl_student_enrolled_main`.`student_id`
`tbl_student_enrolled_main`.`student_name`
`tbl_student_enrolled_main`.`course_id`
`tbl_student_enrolled_main`.`major`
`tbl_student_enrolled_main`.`semesters`
`tbl_student_enrolled_main`.`academic_year`
`tbl_student_enrolled_main`.`class_year_id`
`tbl_student_enrolled_main`.`stat`
`tbl_student_setup`.*
`tbl_student_setup`.`SysPKID`
`tbl_student_setup`.`pp_person_code`
`tbl_student_setup`.`application_date`
`tbl_student_setup`.`pp_student_no`
`tbl_student_setup`.`pp_prefix`
`tbl_student_setup`.`pp_lastname`
`tbl_student_setup`.`pp_firstname`
`tbl_student_setup`.`pp_middlename`
`tbl_student_setup`.`pp_suffix`
`tbl_student_setup`.`gender`
`tbl_student_setup`.`dob`
`tbl_student_setup`.`civil_stat`
`tbl_student_setup`.`cellno`
`tbl_student_setup`.`phoneno`
`tbl_student_setup`.`nationality`
`tbl_student_setup`.`religion`
`tbl_student_setup`.`spouseOccupation`
`tbl_student_setup`.`spouse`
`tbl_student_setup`.`mother_name`
`tbl_student_setup`.`mother_cellno`
`tbl_student_setup`.`father_name`
`tbl_student_setup`.`father_cellno`
`tbl_student_setup`.`email_add`
`tbl_student_setup`.`purok_id`
`tbl_student_setup`.`barangay_id`
`tbl_student_setup`.`municipal_id`
`tbl_student_setup`.`province_id`
`tbl_student_setup`.`save_by`
`tbl_student_setup`.`update_by`
`tbl_student_setup`.`cancelled_by`
`tbl_student_setup`.`status`
`tbl_student_setup`.`ts`
`tbl_student_study_load`.*
`tbl_student_study_load`.`id`
`tbl_student_study_load`.`enrolled_id`
`tbl_student_study_load`.`subject_id`
`tbl_student_study_load`.`day`
`tbl_student_study_load`.`time_from`
`tbl_student_study_load`.`time_to`
`tbl_student_study_load`.`units`
`tbl_student_study_load_days`.*
`tbl_student_study_load_days`.`id`
`tbl_student_study_load_days`.`study_load_id`
`tbl_student_study_load_days`.`day_name`
`travel`.*
`travel`.`id`
`travel`.`travel_number`
`travel`.`date`
`travel`.`title`
`travel`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`mobile`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`image_path`
`users`.`facility_id`
`users`.`facilityName`
`users`.`approved`
`users`.`cancel`
`users`.`admin`
`users`.`ts`
`class_instructors`.*
`class_instructors`.`id`
`class_instructors`.`prefix`
`class_instructors`.`fname`
`class_instructors`.`lname`
`class_instructors`.`mname`
`class_instructors`.`ext`
`class_instructors`.`bod`
`class_instructors`.`gender`
`class_instructors`.`address`
`class_instructors`.`contact_number`
`class_instructors`.`stat`
`class_section`.*
`class_section`.`id`
`class_section`.`section_name`
`class_section`.`stat`
`class_subject`.*
`class_subject`.`id`
`class_subject`.`class_type_id`
`class_subject`.`class_year_id`
`class_subject`.`subject_abr`
`class_subject`.`subject_name`
`class_subject`.`no_of_units`
`class_subject`.`stat`
`class_subject`.`ts`
`class_type`.*
`class_type`.`id`
`class_type`.`class_type`
`class_type`.`sorting`
`class_type_year`.*
`class_type_year`.`id`
`class_type_year`.`class_type`
`class_type_year`.`class_class`
`class_type_year`.`stat`
`committee_report`.*
`committee_report`.`id`
`committee_report`.`committee_report_no`
`committee_report`.`date`
`committee_report`.`title`
`committee_report`.`committee_description`
`committee_report`.`status`
`doc_attendance`.*
`doc_attendance`.`id`
`doc_attendance`.`attend_No`
`doc_attendance`.`attend_date`
`doc_attendance`.`attend_time`
`doc_attendance`.`category`
`doc_attendance`.`status`
`doc_incoming`.*
`doc_incoming`.`id`
`doc_incoming`.`IncDocs_No`
`doc_incoming`.`title`
`doc_incoming`.`datex`
`doc_incoming`.`status`
`doc_outgoing`.*
`doc_outgoing`.`id`
`doc_outgoing`.`OutcDocs_No`
`doc_outgoing`.`doc_type`
`doc_outgoing`.`datex`
`doc_outgoing`.`status`
`doc_recording`.*
`doc_recording`.`id`
`doc_recording`.`title`
`doc_recording`.`status`
`doc_trainseminar`.*
`doc_trainseminar`.`id`
`doc_trainseminar`.`tAndS_no`
`doc_trainseminar`.`to`
`doc_trainseminar`.`thru`
`doc_trainseminar`.`from`
`doc_trainseminar`.`subject`
`doc_trainseminar`.`tAndS_date`
`doc_trainseminar`.`status`
`doc_transmittal`.*
`doc_transmittal`.`id`
`doc_transmittal`.`transmittal_no`
`doc_transmittal`.`trans_date`
`doc_transmittal`.`recipient`
`doc_transmittal`.`status`
`doc_verbalmotion`.*
`doc_verbalmotion`.`id`
`doc_verbalmotion`.`verMotion_No`
`doc_verbalmotion`.`title`
`doc_verbalmotion`.`term_id`
`doc_verbalmotion`.`description`
`doc_verbalmotion`.`datex`
`doc_verbalmotion`.`status`
`doc_verbalmotion_dtls`.*
`doc_verbalmotion_dtls`.`id`
`doc_verbalmotion_dtls`.`vermotion_id`
`doc_verbalmotion_dtls`.`pp_code`
`doc_verbalmotion_dtls`.`attend`
`doc_verbalmotion_dtls`.`mposition`
`document_financial`.*
`document_financial`.`id`
`document_financial`.`App_No`
`document_financial`.`title`
`document_financial`.`purpose`
`document_financial`.`fund`
`document_financial`.`department`
`document_financial`.`status`
`document_name1`.*
`document_name1`.`id`
`document_name1`.`document_name`
`document_name1`.`status`
`document_setup`.*
`document_setup`.`id`
`document_setup`.`document_name`
`document_setup`.`stats`
`documentmanager`.*
`documentmanager`.`id`
`documentmanager`.`document_type`
`documentmanager`.`documentName`
`documentmanager`.`fileSave`
`documentmanager`.`stats`
`documentmanager_file`.*
`documentmanager_file`.`id`
`documentmanager_file`.`mainID`
`documentmanager_file`.`fileName`
`documentmanager_file`.`filePath`
`documentmanager_file`.`fileSize`
`documentmanager_file`.`transtype`
`documentmanager_file`.`thumbnail_path`
`documentmanager_file`.`uid`
`documentmanager_file`.`ts`
`documentmanager_file`.`status`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`form_user_profile`.`emp_tag_id`
`form_user_profile_tag`.*
`form_user_profile_tag`.`id`
`form_user_profile_tag`.`uid`
`form_user_profile_tag`.`profile_id`
`form_user_profile_tag`.`emp_tag_id`
`hr_emp_leave_type`.*
`hr_emp_leave_type`.`leave_number`
`hr_emp_leave_type`.`leave_type`
`hr_emp_leave_type`.`leave_description`
`hr_emp_leave_type`.`leave_code`
`hr_emp_leave_type`.`withPay`
`hr_emp_leave_type`.`stat`
`hr_emp_leave_type`.`with_credit`
`hr_emp_leave_type`.`leave_limit`
`hr_emp_leave_type`.`isLimited`
`hr_emp_leave_type`.`date_save`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`bank_name`
`lgu_brgy_setup`.`bank_account_no`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_brgy_setup`.`qr_brgy_id`
`lgu_brgy_setup_temp`.*
`lgu_brgy_setup_temp`.`SysPK_Brgy`
`lgu_brgy_setup_temp`.`city_mun_id`
`lgu_brgy_setup_temp`.`brgy_id`
`lgu_brgy_setup_temp`.`brgy_name`
`lgu_brgy_setup_temp`.`checker`
`lgu_brgy_setup_temp`.`brgy_code`
`lgu_brgy_setup_temp`.`URBAN_RURAL`
`lgu_brgy_setup_temp`.`POPULATION`
`lgu_brgy_setup_temp`.`CITY`
`lgu_brgy_setup_temp`.`PROVINCE`
`lgu_brgy_setup_temp`.`REGION`
`lgu_brgy_setup_temp`.`person_code`
`lgu_brgy_setup_temp`.`stat`
`lgu_brgy_setup_temp`.`brgy_code1`
`lgu_city_mun_setup`.*
`lgu_city_mun_setup`.`SysPK_City_mun`
`lgu_city_mun_setup`.`province_id`
`lgu_city_mun_setup`.`zipcode_id`
`lgu_city_mun_setup`.`city_mun_id`
`lgu_city_mun_setup`.`city_mun_name`
`lgu_city_mun_setup`.`status_name`
`lgu_city_mun_setup`.`country`
`lgu_city_mun_setup`.`province_area`
`lgu_city_mun_setup`.`zip_code`
`lgu_city_mun_setup`.`municipal_code`
`lgu_city_mun_setup`.`checker`
`lgu_city_mun_setup`.`citydate`
`lgu_city_mun_setup_temp`.*
`lgu_city_mun_setup_temp`.`SysPK_City_mun`
`lgu_city_mun_setup_temp`.`province_id`
`lgu_city_mun_setup_temp`.`zipcode_id`
`lgu_city_mun_setup_temp`.`city_mun_id`
`lgu_city_mun_setup_temp`.`city_mun_name`
`lgu_city_mun_setup_temp`.`status_name`
`lgu_city_mun_setup_temp`.`country`
`lgu_city_mun_setup_temp`.`province_area`
`lgu_city_mun_setup_temp`.`zip_code`
`lgu_city_mun_setup_temp`.`municipal_code`
`lgu_city_mun_setup_temp`.`checker`
`lgu_province_setup`.*
`lgu_province_setup`.`SysPK_Province`
`lgu_province_setup`.`province_id`
`lgu_province_setup`.`province_name`
`lgu_province_setup`.`province_code`
`lgu_province_setup`.`province_capital`
`lgu_province_setup`.`province_class`
`lgu_province_setup`.`province_area`
`lgu_province_setup`.`province_population`
`lgu_province_setup`.`region_id`
`lgu_province_setup`.`province_code1`
`lgu_province_setup_temp`.*
`lgu_province_setup_temp`.`SysPK_Province`
`lgu_province_setup_temp`.`province_id`
`lgu_province_setup_temp`.`province_name`
`lgu_province_setup_temp`.`province_code`
`lgu_province_setup_temp`.`province_capital`
`lgu_province_setup_temp`.`province_class`
`lgu_province_setup_temp`.`province_area`
`lgu_province_setup_temp`.`province_population`
`lgu_province_setup_temp`.`region_id`
`lgu_province_setup_temp`.`province_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`lgu_region_setup`.*
`lgu_region_setup`.`SysPK_region`
`lgu_region_setup`.`reg_name`
`lgu_region_setup`.`reg_code`
`lgu_region_setup`.`reg_order`
`lgu_region_setup_temp`.*
`lgu_region_setup_temp`.`SysPK_region`
`lgu_region_setup_temp`.`reg_name`
`lgu_region_setup_temp`.`reg_code`
`lgu_region_setup_temp`.`reg_order`
`lgu_zipcode_setup`.*
`lgu_zipcode_setup`.`SysPK_Zipcode`
`lgu_zipcode_setup`.`zipcode_id`
`lgu_zipcode_setup`.`zipcode_country`
`lgu_zipcode_setup`.`zipcode_province`
`lgu_zipcode_setup`.`zipcode_name`
`lgu_zipcode_setup`.`zipcode_location`
`lgu_zipcode_setup_temp`.*
`lgu_zipcode_setup_temp`.`SysPK_Zipcode`
`lgu_zipcode_setup_temp`.`zipcode_id`
`lgu_zipcode_setup_temp`.`zipcode_country`
`lgu_zipcode_setup_temp`.`zipcode_province`
`lgu_zipcode_setup_temp`.`zipcode_name`
`lgu_zipcode_setup_temp`.`zipcode_location`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`p_tbl_section`.*
`p_tbl_section`.`id`
`p_tbl_section`.`section`
`p_tbl_section`.`section_category`
`p_tbl_section`.`section_limit`
`p_tbl_section`.`stats`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payment_setup`.*
`payment_setup`.`id`
`payment_setup`.`payment_name`
`payment_setup`.`initial_amount`
`payment_setup`.`income_account_code`
`payment_setup`.`income_account_description`
`payment_setup`.`stat`
`payment_setup`.`ts`
`setup_day`.*
`setup_day`.`id`
`setup_day`.`dayname`
`setup_day`.`abr`
`sp_aip`.*
`sp_aip`.`SysPK_AIPCode`
`sp_aip`.`aip_id`
`sp_aip`.`aip_cy`
`sp_aip`.`aip_lgutype`
`sp_aip`.`aip_lguname`
`sp_aip`.`aip_reference`
`sp_aip`.`aip_lguactivitydes`
`sp_aip`.`aip_offdep`
`sp_aip`.`aip_startdate`
`sp_aip`.`aip_compdate`
`sp_aip`.`aip_expoutput`
`sp_aip`.`aip_fundsource`
`sp_aip`.`aip_ps`
`sp_aip`.`aip_mooe`
`sp_aip`.`aip_co`
`sp_aip`.`aip_total`
`sp_category`.*
`sp_category`.`ResolutionNo`
`sp_category`.`CategoryID`
`sp_category`.`LawNo`
`sp_commitee_report`.*
`sp_commitee_report`.`commitee_report_no`
`sp_commitee_report`.`sp_member`
`sp_commitee_report`.`session_date`
`sp_commitee_report`.`title`
`sp_commitee_report`.`file_path`
`sp_commitee_report`.`type_of_report`
`sp_committe_setup`.*
`sp_committe_setup`.`id`
`sp_committe_setup`.`committe_name`
`sp_committe_setup`.`status`
`sp_committee_assign`.*
`sp_committee_assign`.`id`
`sp_committee_assign`.`term_id`
`sp_committee_assign`.`pp_code`
`sp_committee_assign`.`commitee_asign`
`sp_committee_assign`.`date_assign`
`sp_committee_assign`.`assign`
`sp_committee_assign`.`status`
`sp_committee_report`.*
`sp_committee_report`.`id`
`sp_committee_report`.`term_id`
`sp_committee_report`.`trans_date`
`sp_committee_report`.`title`
`sp_committee_report`.`report_no`
`sp_committee_report`.`agenda`
`sp_committee_report`.`findings`
`sp_committee_report`.`recommendation`
`sp_committee_report`.`ts`
`sp_committee_report`.`text_content`
`sp_committee_report_attach`.*
`sp_committee_report_attach`.`id`
`sp_committee_report_attach`.`committee_id`
`sp_committee_report_attach`.`filename`
`sp_committee_report_attach`.`fileblob`
`sp_committee_report_attach`.`ts`
`sp_committee_report_details`.*
`sp_committee_report_details`.`id`
`sp_committee_report_details`.`memo_id`
`sp_committee_report_details`.`pp_code`
`sp_committee_report_details`.`attend`
`sp_document_request_form2012`.*
`sp_document_request_form2012`.`sysPK_drf`
`sp_document_request_form2012`.`drf_id`
`sp_document_request_form2012`.`drf_date`
`sp_document_request_form2012`.`drf_name`
`sp_document_request_form2012`.`drf_add`
`sp_document_request_form2012`.`drf_r1`
`sp_document_request_form2012`.`drf_r2`
`sp_document_request_form2012`.`drf_r3`
`sp_document_request_form2012`.`drf_r4`
`sp_document_request_form2012`.`drf_signature`
`sp_document_request_form2012`.`drf_amountpaid`
`sp_document_request_form2012`.`drf_receiptno`
`sp_document_request_form2012`.`drf_releasedby`
`sp_incoming_document_details`.*
`sp_incoming_document_details`.`document_id`
`sp_incoming_document_details`.`file_location`
`sp_incoming_document_receiving`.*
`sp_incoming_document_receiving`.`receiving_no`
`sp_incoming_document_receiving`.`incoming_doc_no`
`sp_incoming_document_receiving`.`date_received`
`sp_incoming_document_receiving`.`time_received`
`sp_incoming_document_receiving`.`received_by`
`sp_incoming_document_receiving`.`department`
`sp_incoming_document_receiving`.`remarks`
`sp_incoming_document_tracking`.*
`sp_incoming_document_tracking`.`sp_doc_id`
`sp_incoming_document_tracking`.`sp_doc_no`
`sp_incoming_document_tracking`.`document_type`
`sp_incoming_document_tracking`.`document_date`
`sp_incoming_document_tracking`.`sender`
`sp_incoming_document_tracking`.`subject`
`sp_incoming_document_tracking`.`remarks`
`sp_incoming_document_tracking`.`received_by`
`sp_incoming_document_tracking`.`date_received`
`sp_incoming_document_tracking`.`time_received`
`sp_incoming_document_tracking`.`file_path`
`sp_law`.*
`sp_law`.`LawNo`
`sp_law`.`EffectivityDate`
`sp_law`.`PlaceHeld`
`sp_law`.`Stat`
`sp_law`.`ReferenceOrdNo`
`sp_law`.`StatusDate`
`sp_law`.`filename`
`sp_law`.`file_Location2`
`sp_law`.`counter_m`
`sp_law`.`file_save_type`
`sp_law`.`title`
`sp_law`.`description`
`sp_memorandum`.*
`sp_memorandum`.`id`
`sp_memorandum`.`term_id`
`sp_memorandum`.`trans_date`
`sp_memorandum`.`agenda`
`sp_memorandum`.`subject`
`sp_memorandum`.`ts`
`sp_memorandum`.`text_content`
`sp_memorandum`.`status`
`sp_memorandum_attach`.*
`sp_memorandum_attach`.`id`
`sp_memorandum_attach`.`memo_id`
`sp_memorandum_attach`.`filename`
`sp_memorandum_attach`.`fileblob`
`sp_memorandum_attach`.`ts`
`sp_memorandum_attach`.`status`
`sp_memorandum_details`.*
`sp_memorandum_details`.`id`
`sp_memorandum_details`.`memo_id`
`sp_memorandum_details`.`pp_code`
`sp_memorandum_details`.`attend`
`sp_memorandum_details`.`mposition`
`sp_minutes`.*
`sp_minutes`.`MinutesNo`
`sp_minutes`.`term_id`
`sp_minutes`.`application_date`
`sp_minutes`.`Session`
`sp_minutes`.`CalltoOrderBy`
`sp_minutes`.`CalltoOrderTime`
`sp_minutes`.`CalltoOrderDate`
`sp_minutes`.`PreviousSessionDate`
`sp_minutes`.`PlaceHeld`
`sp_minutes`.`Invocatedby`
`sp_minutes`.`EndTime`
`sp_minutes`.`Ajournedby`
`sp_minutes`.`filename`
`sp_minutes`.`file_Location2`
`sp_minutes`.`save_date`
`sp_minutes`.`counter_m`
`sp_minutes`.`file_save_type`
`sp_minutes`.`title`
`sp_minutes`.`description`
`sp_minutes`.`content`
`sp_minutes`.`status`
`sp_minutesdetail`.*
`sp_minutesdetail`.`Detail_id`
`sp_minutesdetail`.`MinutesNo`
`sp_minutesdetail`.`filename`
`sp_official_attendance`.*
`sp_official_attendance`.`id`
`sp_official_attendance`.`date_trans`
`sp_official_attendance`.`pp_id`
`sp_official_attendance`.`ts`
`sp_official_name`.*
`sp_official_name`.`id`
`sp_official_name`.`_name`
`sp_official_name`.`ordering`
`sp_official_name`.`ts`
`sp_official_name`.`visible`
`sp_official_password`.*
`sp_official_password`.`id`
`sp_official_password`.`ppid`
`sp_official_password`.`username`
`sp_official_password`.`pwd`
`sp_official_password`.`_image`
`sp_official_setup`.*
`sp_official_setup`.`term_id`
`sp_official_setup`.`termfrom`
`sp_official_setup`.`termto`
`sp_official_setup`.`ts`
`sp_official_setup`.`status`
`sp_official_setup2`.*
`sp_official_setup2`.`id`
`sp_official_setup2`.`term_id`
`sp_official_setup2`.`person_no`
`sp_official_setup2`.`position`
`sp_official_setup2`.`termfrom`
`sp_official_setup2`.`termto`
`sp_official_setup2`.`ts`
`sp_official_setup2`.`ordering`
`sp_official_setup2`.`image`
`sp_official_setup2`.`_position`
`sp_official_setup2`.`status`
`sp_outgoing_document`.*
`sp_outgoing_document`.`document_id`
`sp_outgoing_document`.`document_no`
`sp_outgoing_document`.`document_date`
`sp_outgoing_document`.`title`
`sp_outgoing_document`.`note`
`sp_outgoing_document`.`addressee`
`sp_outgoing_document`.`document_type`
`sp_outgoing_document_details`.*
`sp_outgoing_document_details`.`doc_no`
`sp_outgoing_document_details`.`file_location`
`sp_outgoing_receiving`.*
`sp_outgoing_receiving`.`outgoing_received_no`
`sp_outgoing_receiving`.`doc_int`
`sp_outgoing_receiving`.`received_by`
`sp_outgoing_receiving`.`department_code`
`sp_outgoing_receiving`.`date_received`
`sp_outgoing_receiving`.`time_received`
`sp_outgoing_receiving`.`remarks`
`sp_position`.*
`sp_position`.`id`
`sp_position`.`position_name`
`sp_position`.`status`
`sp_projectsupply`.*
`sp_projectsupply`.`ProjectID`
`sp_projectsupply`.`ProjectName`
`sp_projectsupply`.`Amount`
`sp_projectsupply`.`SourcedFrom`
`sp_projectsupply`.`ModeofProcurement`
`sp_projectsupply`.`ProjectDescription`
`sp_proponents`.*
`sp_proponents`.`ResolutionNo`
`sp_proponents`.`Sponsor`
`sp_proponents`.`CoSponsor`
`sp_proponents`.`LawNo`
`sp_proponents_ms`.*
`sp_proponents_ms`.`ResolutionNo`
`sp_proponents_ms`.`Movant`
`sp_proponents_ms`.`Seconder`
`sp_proponents_ms`.`LawNo`
`sp_quasi`.*
`sp_quasi`.`LawNo`
`sp_quasi`.`EffectivityDate`
`sp_quasi`.`PlaceHeld`
`sp_quasi`.`Stat`
`sp_quasi`.`ReferenceOrdNo`
`sp_quasi`.`StatusDate`
`sp_quasi`.`filename`
`sp_quasi`.`file_Location2`
`sp_quasi`.`counter_m`
`sp_quasi`.`file_save_type`
`sp_quasi`.`title`
`sp_quasi`.`description`
`sp_resolution`.*
`sp_resolution`.`ResolutionNo`
`sp_resolution`.`approved_date`
`sp_resolution`.`trans_date`
`sp_resolution`.`PlaceHeld`
`sp_resolution`.`SessionType`
`sp_resolution`.`EffectivityDate`
`sp_resolution`.`filename`
`sp_resolution`.`file_Location2`
`sp_resolution`.`counter_m`
`sp_resolution`.`file_save_type`
`sp_resolution`.`title_id`
`sp_resolution`.`title`
`sp_resolution`.`title2`
`sp_resolution`.`description`
`sp_resolution`.`ts`
`sp_resolution`.`term_id`
`sp_resolution`.`category_id`
`sp_resolution`.`trans_type`
`sp_resolution`.`mins_id`
`sp_resolution`.`status`
`sp_resolution`.`amended_id`
`sp_resolution`.`resStats`
`sp_resolution`.`dateApproved`
`sp_resolution`.`datePublished`
`sp_resolution_files`.*
`sp_resolution_files`.`ID`
`sp_resolution_files`.`res_id`
`sp_resolution_files`.`filename`
`sp_resolution_files`.`fileblob`
`sp_resolution_files`.`ts`
`sp_resolution_files`.`status`
`sp_session`.*
`sp_session`.`session_id`
`sp_session`.`session_no`
`sp_session`.`session_date`
`sp_session`.`title`
`sp_session`.`description`
`sp_session_details`.*
`sp_session_details`.`session_id`
`sp_session_details`.`file_path`
`sp_session_setup`.*
`sp_session_setup`.`id`
`sp_session_setup`.`term_id`
`sp_session_setup`.`day_name`
`sp_session_setup`.`session_type`
`sp_session_setup`.`ts`
`sp_session_setup`.`status`
`sp_special_date`.*
`sp_special_date`.`id`
`sp_special_date`.`_type`
`sp_special_date`.`agenda`
`sp_special_date`.`_date`
`sp_special_date`.`status`
`sp_special_date`.`_color`
`sp_special_date`.`_isrecurring`
`sp_special_date`.`regid`
`sp_special_date_reg`.*
`sp_special_date_reg`.`id`
`sp_special_date_reg`.`_from`
`sp_special_date_reg`.`_to`
`sp_special_date_reg`.`_dayname`
`sp_special_date_reg`.`status`
`tbl_leaves`.*
`tbl_leaves`.`leave_id`
`tbl_leaves`.`ref_no`
`tbl_leaves`.`asOfDate`
`tbl_leaves`.`sl_bal`
`tbl_leaves`.`vl_bal`
`tbl_leaves`.`applied_date`
`tbl_leaves`.`approved_date`
`tbl_leaves`.`approved_by`
`tbl_leaves`.`by_authority_id`
`tbl_leaves`.`employee_id`
`tbl_leaves`.`contact_person`
`tbl_leaves`.`contact_no`
`tbl_leaves`.`purpose`
`tbl_leaves`.`supervisor_comment`
`tbl_leaves`.`status`
`tbl_leaves`.`tmstamp`
`tbl_leaves`.`dept_id`
`tbl_leaves`.`position_id`
`tbl_leaves`.`commutation`
`tbl_leaves`.`incaseVLPhilCheck`
`tbl_leaves`.`incaseVLPhilText`
`tbl_leaves`.`incaseVLAbroadCheck`
`tbl_leaves`.`incaseVLAbroadText`
`tbl_leaves`.`incaseSLHospitalCheck`
`tbl_leaves`.`incaseSLHospitalText`
`tbl_leaves`.`incaseSLOutPatientCheck`
`tbl_leaves`.`incaseSLOutPatientText`
`tbl_leaves`.`incaseSpecialLeaveWomenText`
`tbl_leaves`.`incaseStudyMastersDegreeCheck`
`tbl_leaves`.`incaseStudyBARBoardCheck`
`tbl_leaves`.`MonetizationLeaveCheck`
`tbl_leaves`.`TerminalLeaveCheck`
`tbl_leaves`.`LeaveRemarks`
`tbl_leaves`.`recommended_by`
`tbl_leaves`.`recommended_date`
`tbl_leaves`.`certify_by`
`tbl_leaves`.`certify_date`
`tbl_leaves`.`wherespent`
`tbl_leaves`.`declined_remarks`
`tbl_leaves`.`declined_remarks_approval`
`tbl_leaves`.`isWebApp`
`tbl_leaves`.`dateSelected`
`tbl_leaves`.`isposted`
`tbl_leaves_dtl`.*
`tbl_leaves_dtl`.`id`
`tbl_leaves_dtl`.`leave_id`
`tbl_leaves_dtl`.`leave_type_id`
`tbl_leaves_dtl`.`leave_date`
`tbl_leaves_dtl`.`leave_dateto`
`tbl_leaves_dtl`.`leave_for`
`tbl_leaves_dtl`.`hrs_leave`
`tbl_leaves_dtl`.`payment_mode`
`tbl_leaves_dtl`.`status`
`tbl_leaves_dtl`.`status_rec`
`tbl_leaves_dtl`.`status_cert`
`tbl_leaves_dtl`.`status_approved`
`tbl_leaves_dtl`.`leave_others`
`tbl_leaves_dtl`.`deductLeave`
`tbl_student_enrolled_assessment`.*
`tbl_student_enrolled_assessment`.`id`
`tbl_student_enrolled_assessment`.`enrolled_id`
`tbl_student_enrolled_assessment`.`payment_setup_id`
`tbl_student_enrolled_assessment`.`amount`
`tbl_student_enrolled_main`.*
`tbl_student_enrolled_main`.`id`
`tbl_student_enrolled_main`.`student_id`
`tbl_student_enrolled_main`.`student_name`
`tbl_student_enrolled_main`.`course_id`
`tbl_student_enrolled_main`.`major`
`tbl_student_enrolled_main`.`semesters`
`tbl_student_enrolled_main`.`academic_year`
`tbl_student_enrolled_main`.`class_year_id`
`tbl_student_enrolled_main`.`stat`
`tbl_student_setup`.*
`tbl_student_setup`.`SysPKID`
`tbl_student_setup`.`pp_person_code`
`tbl_student_setup`.`application_date`
`tbl_student_setup`.`pp_student_no`
`tbl_student_setup`.`pp_prefix`
`tbl_student_setup`.`pp_lastname`
`tbl_student_setup`.`pp_firstname`
`tbl_student_setup`.`pp_middlename`
`tbl_student_setup`.`pp_suffix`
`tbl_student_setup`.`gender`
`tbl_student_setup`.`dob`
`tbl_student_setup`.`civil_stat`
`tbl_student_setup`.`cellno`
`tbl_student_setup`.`phoneno`
`tbl_student_setup`.`nationality`
`tbl_student_setup`.`religion`
`tbl_student_setup`.`spouseOccupation`
`tbl_student_setup`.`spouse`
`tbl_student_setup`.`mother_name`
`tbl_student_setup`.`mother_cellno`
`tbl_student_setup`.`father_name`
`tbl_student_setup`.`father_cellno`
`tbl_student_setup`.`email_add`
`tbl_student_setup`.`purok_id`
`tbl_student_setup`.`barangay_id`
`tbl_student_setup`.`municipal_id`
`tbl_student_setup`.`province_id`
`tbl_student_setup`.`save_by`
`tbl_student_setup`.`update_by`
`tbl_student_setup`.`cancelled_by`
`tbl_student_setup`.`status`
`tbl_student_setup`.`ts`
`tbl_student_study_load`.*
`tbl_student_study_load`.`id`
`tbl_student_study_load`.`enrolled_id`
`tbl_student_study_load`.`subject_id`
`tbl_student_study_load`.`day`
`tbl_student_study_load`.`time_from`
`tbl_student_study_load`.`time_to`
`tbl_student_study_load`.`units`
`tbl_student_study_load_days`.*
`tbl_student_study_load_days`.`id`
`tbl_student_study_load_days`.`study_load_id`
`tbl_student_study_load_days`.`day_name`
`travel`.*
`travel`.`id`
`travel`.`travel_number`
`travel`.`date`
`travel`.`title`
`travel`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`mobile`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`image_path`
`users`.`facility_id`
`users`.`facilityName`
`users`.`approved`
`users`.`cancel`
`users`.`admin`
`users`.`ts`
`class_instructors`.*
`class_instructors`.`id`
`class_instructors`.`prefix`
`class_instructors`.`fname`
`class_instructors`.`lname`
`class_instructors`.`mname`
`class_instructors`.`ext`
`class_instructors`.`bod`
`class_instructors`.`gender`
`class_instructors`.`address`
`class_instructors`.`contact_number`
`class_instructors`.`stat`
`class_section`.*
`class_section`.`id`
`class_section`.`section_name`
`class_section`.`stat`
`class_subject`.*
`class_subject`.`id`
`class_subject`.`class_type_id`
`class_subject`.`class_year_id`
`class_subject`.`subject_abr`
`class_subject`.`subject_name`
`class_subject`.`no_of_units`
`class_subject`.`stat`
`class_subject`.`ts`
`class_type`.*
`class_type`.`id`
`class_type`.`class_type`
`class_type`.`sorting`
`class_type_year`.*
`class_type_year`.`id`
`class_type_year`.`class_type`
`class_type_year`.`class_class`
`class_type_year`.`stat`
`committee_report`.*
`committee_report`.`id`
`committee_report`.`committee_report_no`
`committee_report`.`date`
`committee_report`.`title`
`committee_report`.`committee_description`
`committee_report`.`status`
`doc_attendance`.*
`doc_attendance`.`id`
`doc_attendance`.`attend_No`
`doc_attendance`.`attend_date`
`doc_attendance`.`attend_time`
`doc_attendance`.`category`
`doc_attendance`.`status`
`doc_incoming`.*
`doc_incoming`.`id`
`doc_incoming`.`IncDocs_No`
`doc_incoming`.`title`
`doc_incoming`.`datex`
`doc_incoming`.`status`
`doc_outgoing`.*
`doc_outgoing`.`id`
`doc_outgoing`.`OutcDocs_No`
`doc_outgoing`.`doc_type`
`doc_outgoing`.`datex`
`doc_outgoing`.`status`
`doc_recording`.*
`doc_recording`.`id`
`doc_recording`.`title`
`doc_recording`.`status`
`doc_trainseminar`.*
`doc_trainseminar`.`id`
`doc_trainseminar`.`tAndS_no`
`doc_trainseminar`.`to`
`doc_trainseminar`.`thru`
`doc_trainseminar`.`from`
`doc_trainseminar`.`subject`
`doc_trainseminar`.`tAndS_date`
`doc_trainseminar`.`status`
`doc_transmittal`.*
`doc_transmittal`.`id`
`doc_transmittal`.`transmittal_no`
`doc_transmittal`.`trans_date`
`doc_transmittal`.`recipient`
`doc_transmittal`.`status`
`doc_verbalmotion`.*
`doc_verbalmotion`.`id`
`doc_verbalmotion`.`verMotion_No`
`doc_verbalmotion`.`title`
`doc_verbalmotion`.`term_id`
`doc_verbalmotion`.`description`
`doc_verbalmotion`.`datex`
`doc_verbalmotion`.`status`
`doc_verbalmotion_dtls`.*
`doc_verbalmotion_dtls`.`id`
`doc_verbalmotion_dtls`.`vermotion_id`
`doc_verbalmotion_dtls`.`pp_code`
`doc_verbalmotion_dtls`.`attend`
`doc_verbalmotion_dtls`.`mposition`
`document_financial`.*
`document_financial`.`id`
`document_financial`.`App_No`
`document_financial`.`title`
`document_financial`.`purpose`
`document_financial`.`fund`
`document_financial`.`department`
`document_financial`.`status`
`document_name1`.*
`document_name1`.`id`
`document_name1`.`document_name`
`document_name1`.`status`
`document_setup`.*
`document_setup`.`id`
`document_setup`.`document_name`
`document_setup`.`stats`
`documentmanager`.*
`documentmanager`.`id`
`documentmanager`.`document_type`
`documentmanager`.`documentName`
`documentmanager`.`fileSave`
`documentmanager`.`stats`
`documentmanager_file`.*
`documentmanager_file`.`id`
`documentmanager_file`.`mainID`
`documentmanager_file`.`fileName`
`documentmanager_file`.`filePath`
`documentmanager_file`.`fileSize`
`documentmanager_file`.`transtype`
`documentmanager_file`.`thumbnail_path`
`documentmanager_file`.`uid`
`documentmanager_file`.`ts`
`documentmanager_file`.`status`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`form_user_profile`.`emp_tag_id`
`form_user_profile_tag`.*
`form_user_profile_tag`.`id`
`form_user_profile_tag`.`uid`
`form_user_profile_tag`.`profile_id`
`form_user_profile_tag`.`emp_tag_id`
`hr_emp_leave_type`.*
`hr_emp_leave_type`.`leave_number`
`hr_emp_leave_type`.`leave_type`
`hr_emp_leave_type`.`leave_description`
`hr_emp_leave_type`.`leave_code`
`hr_emp_leave_type`.`withPay`
`hr_emp_leave_type`.`stat`
`hr_emp_leave_type`.`with_credit`
`hr_emp_leave_type`.`leave_limit`
`hr_emp_leave_type`.`isLimited`
`hr_emp_leave_type`.`date_save`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`bank_name`
`lgu_brgy_setup`.`bank_account_no`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_brgy_setup`.`qr_brgy_id`
`lgu_brgy_setup_temp`.*
`lgu_brgy_setup_temp`.`SysPK_Brgy`
`lgu_brgy_setup_temp`.`city_mun_id`
`lgu_brgy_setup_temp`.`brgy_id`
`lgu_brgy_setup_temp`.`brgy_name`
`lgu_brgy_setup_temp`.`checker`
`lgu_brgy_setup_temp`.`brgy_code`
`lgu_brgy_setup_temp`.`URBAN_RURAL`
`lgu_brgy_setup_temp`.`POPULATION`
`lgu_brgy_setup_temp`.`CITY`
`lgu_brgy_setup_temp`.`PROVINCE`
`lgu_brgy_setup_temp`.`REGION`
`lgu_brgy_setup_temp`.`person_code`
`lgu_brgy_setup_temp`.`stat`
`lgu_brgy_setup_temp`.`brgy_code1`
`lgu_city_mun_setup`.*
`lgu_city_mun_setup`.`SysPK_City_mun`
`lgu_city_mun_setup`.`province_id`
`lgu_city_mun_setup`.`zipcode_id`
`lgu_city_mun_setup`.`city_mun_id`
`lgu_city_mun_setup`.`city_mun_name`
`lgu_city_mun_setup`.`status_name`
`lgu_city_mun_setup`.`country`
`lgu_city_mun_setup`.`province_area`
`lgu_city_mun_setup`.`zip_code`
`lgu_city_mun_setup`.`municipal_code`
`lgu_city_mun_setup`.`checker`
`lgu_city_mun_setup`.`citydate`
`lgu_city_mun_setup_temp`.*
`lgu_city_mun_setup_temp`.`SysPK_City_mun`
`lgu_city_mun_setup_temp`.`province_id`
`lgu_city_mun_setup_temp`.`zipcode_id`
`lgu_city_mun_setup_temp`.`city_mun_id`
`lgu_city_mun_setup_temp`.`city_mun_name`
`lgu_city_mun_setup_temp`.`status_name`
`lgu_city_mun_setup_temp`.`country`
`lgu_city_mun_setup_temp`.`province_area`
`lgu_city_mun_setup_temp`.`zip_code`
`lgu_city_mun_setup_temp`.`municipal_code`
`lgu_city_mun_setup_temp`.`checker`
`lgu_province_setup`.*
`lgu_province_setup`.`SysPK_Province`
`lgu_province_setup`.`province_id`
`lgu_province_setup`.`province_name`
`lgu_province_setup`.`province_code`
`lgu_province_setup`.`province_capital`
`lgu_province_setup`.`province_class`
`lgu_province_setup`.`province_area`
`lgu_province_setup`.`province_population`
`lgu_province_setup`.`region_id`
`lgu_province_setup`.`province_code1`
`lgu_province_setup_temp`.*
`lgu_province_setup_temp`.`SysPK_Province`
`lgu_province_setup_temp`.`province_id`
`lgu_province_setup_temp`.`province_name`
`lgu_province_setup_temp`.`province_code`
`lgu_province_setup_temp`.`province_capital`
`lgu_province_setup_temp`.`province_class`
`lgu_province_setup_temp`.`province_area`
`lgu_province_setup_temp`.`province_population`
`lgu_province_setup_temp`.`region_id`
`lgu_province_setup_temp`.`province_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`lgu_region_setup`.*
`lgu_region_setup`.`SysPK_region`
`lgu_region_setup`.`reg_name`
`lgu_region_setup`.`reg_code`
`lgu_region_setup`.`reg_order`
`lgu_region_setup_temp`.*
`lgu_region_setup_temp`.`SysPK_region`
`lgu_region_setup_temp`.`reg_name`
`lgu_region_setup_temp`.`reg_code`
`lgu_region_setup_temp`.`reg_order`
`lgu_zipcode_setup`.*
`lgu_zipcode_setup`.`SysPK_Zipcode`
`lgu_zipcode_setup`.`zipcode_id`
`lgu_zipcode_setup`.`zipcode_country`
`lgu_zipcode_setup`.`zipcode_province`
`lgu_zipcode_setup`.`zipcode_name`
`lgu_zipcode_setup`.`zipcode_location`
`lgu_zipcode_setup_temp`.*
`lgu_zipcode_setup_temp`.`SysPK_Zipcode`
`lgu_zipcode_setup_temp`.`zipcode_id`
`lgu_zipcode_setup_temp`.`zipcode_country`
`lgu_zipcode_setup_temp`.`zipcode_province`
`lgu_zipcode_setup_temp`.`zipcode_name`
`lgu_zipcode_setup_temp`.`zipcode_location`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`p_tbl_section`.*
`p_tbl_section`.`id`
`p_tbl_section`.`section`
`p_tbl_section`.`section_category`
`p_tbl_section`.`section_limit`
`p_tbl_section`.`stats`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payment_setup`.*
`payment_setup`.`id`
`payment_setup`.`payment_name`
`payment_setup`.`initial_amount`
`payment_setup`.`income_account_code`
`payment_setup`.`income_account_description`
`payment_setup`.`stat`
`payment_setup`.`ts`
`setup_day`.*
`setup_day`.`id`
`setup_day`.`dayname`
`setup_day`.`abr`
`sp_aip`.*
`sp_aip`.`SysPK_AIPCode`
`sp_aip`.`aip_id`
`sp_aip`.`aip_cy`
`sp_aip`.`aip_lgutype`
`sp_aip`.`aip_lguname`
`sp_aip`.`aip_reference`
`sp_aip`.`aip_lguactivitydes`
`sp_aip`.`aip_offdep`
`sp_aip`.`aip_startdate`
`sp_aip`.`aip_compdate`
`sp_aip`.`aip_expoutput`
`sp_aip`.`aip_fundsource`
`sp_aip`.`aip_ps`
`sp_aip`.`aip_mooe`
`sp_aip`.`aip_co`
`sp_aip`.`aip_total`
`sp_category`.*
`sp_category`.`ResolutionNo`
`sp_category`.`CategoryID`
`sp_category`.`LawNo`
`sp_commitee_report`.*
`sp_commitee_report`.`commitee_report_no`
`sp_commitee_report`.`sp_member`
`sp_commitee_report`.`session_date`
`sp_commitee_report`.`title`
`sp_commitee_report`.`file_path`
`sp_commitee_report`.`type_of_report`
`sp_committe_setup`.*
`sp_committe_setup`.`id`
`sp_committe_setup`.`committe_name`
`sp_committe_setup`.`status`
`sp_committee_assign`.*
`sp_committee_assign`.`id`
`sp_committee_assign`.`term_id`
`sp_committee_assign`.`pp_code`
`sp_committee_assign`.`commitee_asign`
`sp_committee_assign`.`date_assign`
`sp_committee_assign`.`assign`
`sp_committee_assign`.`status`
`sp_committee_report`.*
`sp_committee_report`.`id`
`sp_committee_report`.`term_id`
`sp_committee_report`.`trans_date`
`sp_committee_report`.`title`
`sp_committee_report`.`report_no`
`sp_committee_report`.`agenda`
`sp_committee_report`.`findings`
`sp_committee_report`.`recommendation`
`sp_committee_report`.`ts`
`sp_committee_report`.`text_content`
`sp_committee_report_attach`.*
`sp_committee_report_attach`.`id`
`sp_committee_report_attach`.`committee_id`
`sp_committee_report_attach`.`filename`
`sp_committee_report_attach`.`fileblob`
`sp_committee_report_attach`.`ts`
`sp_committee_report_details`.*
`sp_committee_report_details`.`id`
`sp_committee_report_details`.`memo_id`
`sp_committee_report_details`.`pp_code`
`sp_committee_report_details`.`attend`
`sp_document_request_form2012`.*
`sp_document_request_form2012`.`sysPK_drf`
`sp_document_request_form2012`.`drf_id`
`sp_document_request_form2012`.`drf_date`
`sp_document_request_form2012`.`drf_name`
`sp_document_request_form2012`.`drf_add`
`sp_document_request_form2012`.`drf_r1`
`sp_document_request_form2012`.`drf_r2`
`sp_document_request_form2012`.`drf_r3`
`sp_document_request_form2012`.`drf_r4`
`sp_document_request_form2012`.`drf_signature`
`sp_document_request_form2012`.`drf_amountpaid`
`sp_document_request_form2012`.`drf_receiptno`
`sp_document_request_form2012`.`drf_releasedby`
`sp_incoming_document_details`.*
`sp_incoming_document_details`.`document_id`
`sp_incoming_document_details`.`file_location`
`sp_incoming_document_receiving`.*
`sp_incoming_document_receiving`.`receiving_no`
`sp_incoming_document_receiving`.`incoming_doc_no`
`sp_incoming_document_receiving`.`date_received`
`sp_incoming_document_receiving`.`time_received`
`sp_incoming_document_receiving`.`received_by`
`sp_incoming_document_receiving`.`department`
`sp_incoming_document_receiving`.`remarks`
`sp_incoming_document_tracking`.*
`sp_incoming_document_tracking`.`sp_doc_id`
`sp_incoming_document_tracking`.`sp_doc_no`
`sp_incoming_document_tracking`.`document_type`
`sp_incoming_document_tracking`.`document_date`
`sp_incoming_document_tracking`.`sender`
`sp_incoming_document_tracking`.`subject`
`sp_incoming_document_tracking`.`remarks`
`sp_incoming_document_tracking`.`received_by`
`sp_incoming_document_tracking`.`date_received`
`sp_incoming_document_tracking`.`time_received`
`sp_incoming_document_tracking`.`file_path`
`sp_law`.*
`sp_law`.`LawNo`
`sp_law`.`EffectivityDate`
`sp_law`.`PlaceHeld`
`sp_law`.`Stat`
`sp_law`.`ReferenceOrdNo`
`sp_law`.`StatusDate`
`sp_law`.`filename`
`sp_law`.`file_Location2`
`sp_law`.`counter_m`
`sp_law`.`file_save_type`
`sp_law`.`title`
`sp_law`.`description`
`sp_memorandum`.*
`sp_memorandum`.`id`
`sp_memorandum`.`term_id`
`sp_memorandum`.`trans_date`
`sp_memorandum`.`agenda`
`sp_memorandum`.`subject`
`sp_memorandum`.`ts`
`sp_memorandum`.`text_content`
`sp_memorandum`.`status`
`sp_memorandum_attach`.*
`sp_memorandum_attach`.`id`
`sp_memorandum_attach`.`memo_id`
`sp_memorandum_attach`.`filename`
`sp_memorandum_attach`.`fileblob`
`sp_memorandum_attach`.`ts`
`sp_memorandum_attach`.`status`
`sp_memorandum_details`.*
`sp_memorandum_details`.`id`
`sp_memorandum_details`.`memo_id`
`sp_memorandum_details`.`pp_code`
`sp_memorandum_details`.`attend`
`sp_memorandum_details`.`mposition`
`sp_minutes`.*
`sp_minutes`.`MinutesNo`
`sp_minutes`.`term_id`
`sp_minutes`.`application_date`
`sp_minutes`.`Session`
`sp_minutes`.`CalltoOrderBy`
`sp_minutes`.`CalltoOrderTime`
`sp_minutes`.`CalltoOrderDate`
`sp_minutes`.`PreviousSessionDate`
`sp_minutes`.`PlaceHeld`
`sp_minutes`.`Invocatedby`
`sp_minutes`.`EndTime`
`sp_minutes`.`Ajournedby`
`sp_minutes`.`filename`
`sp_minutes`.`file_Location2`
`sp_minutes`.`save_date`
`sp_minutes`.`counter_m`
`sp_minutes`.`file_save_type`
`sp_minutes`.`title`
`sp_minutes`.`description`
`sp_minutes`.`content`
`sp_minutes`.`status`
`sp_minutesdetail`.*
`sp_minutesdetail`.`Detail_id`
`sp_minutesdetail`.`MinutesNo`
`sp_minutesdetail`.`filename`
`sp_official_attendance`.*
`sp_official_attendance`.`id`
`sp_official_attendance`.`date_trans`
`sp_official_attendance`.`pp_id`
`sp_official_attendance`.`ts`
`sp_official_name`.*
`sp_official_name`.`id`
`sp_official_name`.`_name`
`sp_official_name`.`ordering`
`sp_official_name`.`ts`
`sp_official_name`.`visible`
`sp_official_password`.*
`sp_official_password`.`id`
`sp_official_password`.`ppid`
`sp_official_password`.`username`
`sp_official_password`.`pwd`
`sp_official_password`.`_image`
`sp_official_setup`.*
`sp_official_setup`.`term_id`
`sp_official_setup`.`termfrom`
`sp_official_setup`.`termto`
`sp_official_setup`.`ts`
`sp_official_setup`.`status`
`sp_official_setup2`.*
`sp_official_setup2`.`id`
`sp_official_setup2`.`term_id`
`sp_official_setup2`.`person_no`
`sp_official_setup2`.`position`
`sp_official_setup2`.`termfrom`
`sp_official_setup2`.`termto`
`sp_official_setup2`.`ts`
`sp_official_setup2`.`ordering`
`sp_official_setup2`.`image`
`sp_official_setup2`.`_position`
`sp_official_setup2`.`status`
`sp_outgoing_document`.*
`sp_outgoing_document`.`document_id`
`sp_outgoing_document`.`document_no`
`sp_outgoing_document`.`document_date`
`sp_outgoing_document`.`title`
`sp_outgoing_document`.`note`
`sp_outgoing_document`.`addressee`
`sp_outgoing_document`.`document_type`
`sp_outgoing_document_details`.*
`sp_outgoing_document_details`.`doc_no`
`sp_outgoing_document_details`.`file_location`
`sp_outgoing_receiving`.*
`sp_outgoing_receiving`.`outgoing_received_no`
`sp_outgoing_receiving`.`doc_int`
`sp_outgoing_receiving`.`received_by`
`sp_outgoing_receiving`.`department_code`
`sp_outgoing_receiving`.`date_received`
`sp_outgoing_receiving`.`time_received`
`sp_outgoing_receiving`.`remarks`
`sp_position`.*
`sp_position`.`id`
`sp_position`.`position_name`
`sp_position`.`status`
`sp_projectsupply`.*
`sp_projectsupply`.`ProjectID`
`sp_projectsupply`.`ProjectName`
`sp_projectsupply`.`Amount`
`sp_projectsupply`.`SourcedFrom`
`sp_projectsupply`.`ModeofProcurement`
`sp_projectsupply`.`ProjectDescription`
`sp_proponents`.*
`sp_proponents`.`ResolutionNo`
`sp_proponents`.`Sponsor`
`sp_proponents`.`CoSponsor`
`sp_proponents`.`LawNo`
`sp_proponents_ms`.*
`sp_proponents_ms`.`ResolutionNo`
`sp_proponents_ms`.`Movant`
`sp_proponents_ms`.`Seconder`
`sp_proponents_ms`.`LawNo`
`sp_quasi`.*
`sp_quasi`.`LawNo`
`sp_quasi`.`EffectivityDate`
`sp_quasi`.`PlaceHeld`
`sp_quasi`.`Stat`
`sp_quasi`.`ReferenceOrdNo`
`sp_quasi`.`StatusDate`
`sp_quasi`.`filename`
`sp_quasi`.`file_Location2`
`sp_quasi`.`counter_m`
`sp_quasi`.`file_save_type`
`sp_quasi`.`title`
`sp_quasi`.`description`
`sp_resolution`.*
`sp_resolution`.`ResolutionNo`
`sp_resolution`.`approved_date`
`sp_resolution`.`trans_date`
`sp_resolution`.`PlaceHeld`
`sp_resolution`.`SessionType`
`sp_resolution`.`EffectivityDate`
`sp_resolution`.`filename`
`sp_resolution`.`file_Location2`
`sp_resolution`.`counter_m`
`sp_resolution`.`file_save_type`
`sp_resolution`.`title_id`
`sp_resolution`.`title`
`sp_resolution`.`title2`
`sp_resolution`.`description`
`sp_resolution`.`ts`
`sp_resolution`.`term_id`
`sp_resolution`.`category_id`
`sp_resolution`.`trans_type`
`sp_resolution`.`mins_id`
`sp_resolution`.`status`
`sp_resolution`.`amended_id`
`sp_resolution`.`resStats`
`sp_resolution`.`dateApproved`
`sp_resolution`.`datePublished`
`sp_resolution_files`.*
`sp_resolution_files`.`ID`
`sp_resolution_files`.`res_id`
`sp_resolution_files`.`filename`
`sp_resolution_files`.`fileblob`
`sp_resolution_files`.`ts`
`sp_resolution_files`.`status`
`sp_session`.*
`sp_session`.`session_id`
`sp_session`.`session_no`
`sp_session`.`session_date`
`sp_session`.`title`
`sp_session`.`description`
`sp_session_details`.*
`sp_session_details`.`session_id`
`sp_session_details`.`file_path`
`sp_session_setup`.*
`sp_session_setup`.`id`
`sp_session_setup`.`term_id`
`sp_session_setup`.`day_name`
`sp_session_setup`.`session_type`
`sp_session_setup`.`ts`
`sp_session_setup`.`status`
`sp_special_date`.*
`sp_special_date`.`id`
`sp_special_date`.`_type`
`sp_special_date`.`agenda`
`sp_special_date`.`_date`
`sp_special_date`.`status`
`sp_special_date`.`_color`
`sp_special_date`.`_isrecurring`
`sp_special_date`.`regid`
`sp_special_date_reg`.*
`sp_special_date_reg`.`id`
`sp_special_date_reg`.`_from`
`sp_special_date_reg`.`_to`
`sp_special_date_reg`.`_dayname`
`sp_special_date_reg`.`status`
`tbl_leaves`.*
`tbl_leaves`.`leave_id`
`tbl_leaves`.`ref_no`
`tbl_leaves`.`asOfDate`
`tbl_leaves`.`sl_bal`
`tbl_leaves`.`vl_bal`
`tbl_leaves`.`applied_date`
`tbl_leaves`.`approved_date`
`tbl_leaves`.`approved_by`
`tbl_leaves`.`by_authority_id`
`tbl_leaves`.`employee_id`
`tbl_leaves`.`contact_person`
`tbl_leaves`.`contact_no`
`tbl_leaves`.`purpose`
`tbl_leaves`.`supervisor_comment`
`tbl_leaves`.`status`
`tbl_leaves`.`tmstamp`
`tbl_leaves`.`dept_id`
`tbl_leaves`.`position_id`
`tbl_leaves`.`commutation`
`tbl_leaves`.`incaseVLPhilCheck`
`tbl_leaves`.`incaseVLPhilText`
`tbl_leaves`.`incaseVLAbroadCheck`
`tbl_leaves`.`incaseVLAbroadText`
`tbl_leaves`.`incaseSLHospitalCheck`
`tbl_leaves`.`incaseSLHospitalText`
`tbl_leaves`.`incaseSLOutPatientCheck`
`tbl_leaves`.`incaseSLOutPatientText`
`tbl_leaves`.`incaseSpecialLeaveWomenText`
`tbl_leaves`.`incaseStudyMastersDegreeCheck`
`tbl_leaves`.`incaseStudyBARBoardCheck`
`tbl_leaves`.`MonetizationLeaveCheck`
`tbl_leaves`.`TerminalLeaveCheck`
`tbl_leaves`.`LeaveRemarks`
`tbl_leaves`.`recommended_by`
`tbl_leaves`.`recommended_date`
`tbl_leaves`.`certify_by`
`tbl_leaves`.`certify_date`
`tbl_leaves`.`wherespent`
`tbl_leaves`.`declined_remarks`
`tbl_leaves`.`declined_remarks_approval`
`tbl_leaves`.`isWebApp`
`tbl_leaves`.`dateSelected`
`tbl_leaves`.`isposted`
`tbl_leaves_dtl`.*
`tbl_leaves_dtl`.`id`
`tbl_leaves_dtl`.`leave_id`
`tbl_leaves_dtl`.`leave_type_id`
`tbl_leaves_dtl`.`leave_date`
`tbl_leaves_dtl`.`leave_dateto`
`tbl_leaves_dtl`.`leave_for`
`tbl_leaves_dtl`.`hrs_leave`
`tbl_leaves_dtl`.`payment_mode`
`tbl_leaves_dtl`.`status`
`tbl_leaves_dtl`.`status_rec`
`tbl_leaves_dtl`.`status_cert`
`tbl_leaves_dtl`.`status_approved`
`tbl_leaves_dtl`.`leave_others`
`tbl_leaves_dtl`.`deductLeave`
`tbl_student_enrolled_assessment`.*
`tbl_student_enrolled_assessment`.`id`
`tbl_student_enrolled_assessment`.`enrolled_id`
`tbl_student_enrolled_assessment`.`payment_setup_id`
`tbl_student_enrolled_assessment`.`amount`
`tbl_student_enrolled_main`.*
`tbl_student_enrolled_main`.`id`
`tbl_student_enrolled_main`.`student_id`
`tbl_student_enrolled_main`.`student_name`
`tbl_student_enrolled_main`.`course_id`
`tbl_student_enrolled_main`.`major`
`tbl_student_enrolled_main`.`semesters`
`tbl_student_enrolled_main`.`academic_year`
`tbl_student_enrolled_main`.`class_year_id`
`tbl_student_enrolled_main`.`stat`
`tbl_student_setup`.*
`tbl_student_setup`.`SysPKID`
`tbl_student_setup`.`pp_person_code`
`tbl_student_setup`.`application_date`
`tbl_student_setup`.`pp_student_no`
`tbl_student_setup`.`pp_prefix`
`tbl_student_setup`.`pp_lastname`
`tbl_student_setup`.`pp_firstname`
`tbl_student_setup`.`pp_middlename`
`tbl_student_setup`.`pp_suffix`
`tbl_student_setup`.`gender`
`tbl_student_setup`.`dob`
`tbl_student_setup`.`civil_stat`
`tbl_student_setup`.`cellno`
`tbl_student_setup`.`phoneno`
`tbl_student_setup`.`nationality`
`tbl_student_setup`.`religion`
`tbl_student_setup`.`spouseOccupation`
`tbl_student_setup`.`spouse`
`tbl_student_setup`.`mother_name`
`tbl_student_setup`.`mother_cellno`
`tbl_student_setup`.`father_name`
`tbl_student_setup`.`father_cellno`
`tbl_student_setup`.`email_add`
`tbl_student_setup`.`purok_id`
`tbl_student_setup`.`barangay_id`
`tbl_student_setup`.`municipal_id`
`tbl_student_setup`.`province_id`
`tbl_student_setup`.`save_by`
`tbl_student_setup`.`update_by`
`tbl_student_setup`.`cancelled_by`
`tbl_student_setup`.`status`
`tbl_student_setup`.`ts`
`tbl_student_study_load`.*
`tbl_student_study_load`.`id`
`tbl_student_study_load`.`enrolled_id`
`tbl_student_study_load`.`subject_id`
`tbl_student_study_load`.`day`
`tbl_student_study_load`.`time_from`
`tbl_student_study_load`.`time_to`
`tbl_student_study_load`.`units`
`tbl_student_study_load_days`.*
`tbl_student_study_load_days`.`id`
`tbl_student_study_load_days`.`study_load_id`
`tbl_student_study_load_days`.`day_name`
`travel`.*
`travel`.`id`
`travel`.`travel_number`
`travel`.`date`
`travel`.`title`
`travel`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`mobile`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`image_path`
`users`.`facility_id`
`users`.`facilityName`
`users`.`approved`
`users`.`cancel`
`users`.`admin`
`users`.`ts`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
class_instructors
class_section
class_subject
class_type
class_type_year
committee_report
doc_attendance
doc_incoming
doc_outgoing
doc_recording
doc_trainseminar
doc_transmittal
doc_verbalmotion
doc_verbalmotion_dtls
document_financial
document_name1
document_setup
documentmanager
documentmanager_file
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
p_tbl_section
password_resets
payment_setup
setup_day
sp_aip
sp_category
sp_commitee_report
sp_committe_setup
sp_committee_assign
sp_committee_report
sp_committee_report_attach
sp_committee_report_details
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
user_logs
users
SQL query on database
online_hr
:
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.