digi-gov.com / 127.0.0.1 / qpsii_lgusystem

There are no recent tables.

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
queue
repository
service_request_db

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`).
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.

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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

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 :

Database structure

Choose which details to show in the database structure (list of tables).

Database structure

Show table charset Show or hide a column displaying the charset for all tables.
Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Page number: > >>

Filters

Containing the word:

Table	Action							Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11.	Type	Collation	Size	Overhead
accounting_debit_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
accounting_enter_receipt		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
accounts_payable_entry		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
account_classification		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
account_ledger		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
account_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
account_per_department		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
account_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	112.0 KiB	-
account_setup_default		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	112.0 KiB	-
account_setup_dtl		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
account_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
addappointment		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
adddeposit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
addfiles		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
additionalinfo		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
addmedicalhistory		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
addnewmedicine		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
addnewpres		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
addpayment		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin2_apppointments		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin2_incoming_document_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin2_incoming_document_receiving		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin2_incoming_document_tracking		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin2_outgoing_document		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin2_outgoing_document_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin2_outgoing_receiving		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_actionplan		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_actionplanactivity		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_actionplanproj		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_actionplanspecout		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_actionplansub		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_ambulance_trip_record		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_anti_rabies		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_application_for_cash_incentives_for_senior_citizens		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_application_for_leave		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_appli_fisherman_gear_license		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_appointment_label		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_appointment_status		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_apppointments		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_avian_pest		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_barangay_fiesta		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_barangay_share_on_community_tax		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_brngy_share_of_community_tax		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_certificate_of_elegibility		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_certificate_of_elegibility2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_certification_detail		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_compliance_monitoring_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_conference_room_scheduling		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_confirmation_letter		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_consolidated_report		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_control_and_monitoring_equipment_status		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_directory		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_document_tracking		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_document_tracking_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_drivers_dailytrip_ticket		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_elderly_budget		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_elderly_certificate_of_elegibility		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_elderly_elegibility_details		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_emp_bday		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_entrance_of_goods		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_equipment_maintenance_index_card		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_executive_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_executive_order_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_expected_output		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_fisherfolk		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_fishers_license		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_free_gym_usage		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_fuel_budget		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_fuel_budget_balance		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_fuel_monitoring		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_important_documents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_important_document_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_incoming_document_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_incoming_document_receiving		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_incoming_document_tracking		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_information_sheet		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_intake		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_intake_dependents		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_intake_form2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_intake_services		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_isdap_budget		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_isdap_elegibility_details		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_isdap_petty_cash_budget		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_isdap_petty_cash_detail		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_lead_bc_form_no		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_list_of_fishers_applied_for_license		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_locator_slip		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_materials_spareparts_withdrawal_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_material_and_part_survey_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_material_spareparts_receiving_reports		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_mayor_account		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_membership_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_memorandom		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_memorandum_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_monitoring_report_fish		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_monitoring_report_meat		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_monthly_accomplishment_report		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_monthly_assessment_property_classification		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_motorpool_division_repair_and_maintenance_work_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_motor_material_slip		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_motor_repair_maintenance_work_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_motor_repair_maintenance_work_order_manpower		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
admin_motor_repair_maintenance_work_order_recommendation		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
admin_motor_repair_maintenance_work_order_vehicle_data		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
admin_office_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_office_order_2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_oplan_deworming		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_oplan_hemosep		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_outgoing_document		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_outgoing_document_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_outgoing_receiving		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_overtime_request_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_plant_equipment_2012_detail		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_plant_equipment_2012_main		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_plan_of_action		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_property_plant_equipment2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_registry_of_municipal_fisherfolk		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_report		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_request_dispatch_trick_ticket_2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_request_for_issuance_permit_of_city_gym_rental		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_request_for_repair_and_services		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_rice_farmer_master_list		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_session_hall_scheduler		Browse	Structure	Search	Insert	Empty	Drop	0	MyISAM	latin1_swedish_ci	1.0 KiB	-
admin_signature_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
admin_slaughtered_animal		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_trip_ticket_2012		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_vaccine_report		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_violence_against_woman_and_their_children		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_zinc_new		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
admin_zinc_sulfate		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
advances_from_customer		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
advance_to_supplier		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
aging_basedate		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64.0 KiB	-
agri_association		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_cropping_season		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
agri_detail_enrollment_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_enrollment_form_sub_header		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
agri_farmers_name		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_header_enrollment_form		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_irrigated_rainfed		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
agri_non_cluster_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_non_cluster_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
agri_rice_program		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
agri_seed_class		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
appointmentrequest		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
appointments		Browse	Structure	Search	Insert	Empty	Drop	27	InnoDB	utf8_general_ci	32.0 KiB	-
appointments_resources		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	latin1_swedish_ci	16.0 KiB	-
appointmentuser		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
appointment_facility		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	latin1_swedish_ci	16.0 KiB	-
appointment_resources		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
approved_employee_ot		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
approved_ot		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
approved_performance_target		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
apps		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
apv_number		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
arp_no_setup		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
askpermision		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_barangay_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_city_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_owner_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_owner_details_copy		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_print_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_province_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_rptmast		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_section_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
assessor_url_path		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
association_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
associaton_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
atc_tax_rate		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
audit_trail		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
authorize_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
auth_access_role		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	32.0 KiB	-
b4_del_jmain		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bank_branch_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bank_recon_records		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bank_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bank_setup_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bank_transactions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
barangay		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
barangays		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
beginning_temp		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bfps_conveyance_permit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bfps_electrical_permit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bfps_fsec		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bfps_fsic		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bfps_inspection_order		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
billingrecord		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
billingrecord_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
billing_monitoring		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
billing_others		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bill_series		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bisligpetty		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bislig_petty_liquidate		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bislig_system		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
board_directors		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
boq_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
boq_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
bplo_boss_priority_number		Browse	Structure	Search	Insert	Empty	Drop	383	InnoDB	latin1_swedish_ci	16.0 KiB	-
bplo_certification_dtls		Browse	Structure	Search	Insert	Empty	Drop	14,589	InnoDB	latin1_swedish_ci	1.5 MiB	-
bplo_certification_trans		Browse	Structure	Search	Insert	Empty	Drop	7,110	InnoDB	latin1_swedish_ci	2.5 MiB	-
bplo_closure_trans		Browse	Structure	Search	Insert	Empty	Drop	67	InnoDB	latin1_swedish_ci	64.0 KiB	-
bplo_inspectorate_report		Browse	Structure	Search	Insert	Empty	Drop	503	InnoDB	latin1_swedish_ci	144.0 KiB	-
bplo_inspectorate_report_departmental		Browse	Structure	Search	Insert	Empty	Drop	1,602	InnoDB	latin1_swedish_ci	384.0 KiB	-
bplo_inspectorate_report_departmental_bkp		Browse	Structure	Search	Insert	Empty	Drop	1,385	InnoDB	latin1_swedish_ci	336.0 KiB	-
bplo_inspectorate_report_departmental_dtl		Browse	Structure	Search	Insert	Empty	Drop	16,408	InnoDB	latin1_swedish_ci	1.5 MiB	-
bplo_inspectorate_report_departmental_dtl_bkp		Browse	Structure	Search	Insert	Empty	Drop	20,350	InnoDB	latin1_swedish_ci	1.5 MiB	-
bplo_issue_signatories		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
bplo_mapping_brgy_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_accounting_history		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_account_receivable		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_account_receivable_dtl		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_assets		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_certifiedby		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_charofaccounts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_clearances		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_coa_account		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_coa_class		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_coa_classification_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_coa_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	48.0 KiB	-
brgy_coa_subclass		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_coa_sub_classification_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_coa_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_coa_type_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
brgy_dummy_id		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_entry_table		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_equity		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_equity_account		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_expense		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_fs_monitoring		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_genfun_depp_amaster		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
brgy_genfun_depp_bdetails		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
brgy_genfun_depp_yearly		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_income		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_jev_dtl_table		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_jev_main		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_jev_table		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_jev_table_delete		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_journal_entry_voucher		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	48.0 KiB	-
brgy_journal_entry_voucher_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	48.0 KiB	-
brgy_liabilities		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_particular		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_registry_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_registry_type_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_status		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
brgy_subsidiaryledger_table		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_subsidiary_account		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	32.0 KiB	-
brgy_subsidiary_ledger		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	32.0 KiB	-
brgy_subsidiary_subaccount		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8_general_ci	32.0 KiB	-
brgy_subsidiary_sub_account		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
brgy_subsidiary_sub_dtls		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
250 tables	Sum							62,466	InnoDB	latin1_swedish_ci	13.1 MiB	0 B

Check all

Page number: > >>

Data dictionary

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.