digi-gov.com / 127.0.0.1 / qpsii_waterworks

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.

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
cto_water_applicant_classification		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
cto_water_rates		Browse	Structure	Search	Insert	Empty	Drop	23	InnoDB	latin1_swedish_ci	16.0 KiB	-
jay_list_consumer_view		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
lgu_book		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
lgu_consumer_type		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
lgu_zone		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	latin1_swedish_ci	16.0 KiB	-
lib_books		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
lib_brand		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
lib_meters		Browse	Structure	Search	Insert	Empty	Drop	3,451	InnoDB	latin1_swedish_ci	336.0 KiB	-
lib_sizes		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
reading_migration		Browse	Structure	Search	Insert	Empty	Drop	2,218	InnoDB	latin1_swedish_ci	160.0 KiB	-
setup_formtype		Browse	Structure	Search	Insert	Empty	Drop	123	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_signatory		Browse	Structure	Search	Insert	Empty	Drop	67	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_signatorytype		Browse	Structure	Search	Insert	Empty	Drop	14	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_restrict_print		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
temp_tbl_aging_account		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	latin1_swedish_ci	16.0 KiB	-
temp_tbl_aging_account_summary		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_account_setup		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_adjustments_setup		Browse	Structure	Search	Insert	Empty	Drop	13	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_aging_no_days		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_area_setup		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_billing_adjustment		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
ww_billing_adjustment_admin_tool		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_billing_adjustment_detail		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	48.0 KiB	-
ww_change_class		Browse	Structure	Search	Insert	Empty	Drop	359	InnoDB	latin1_swedish_ci	48.0 KiB	-
ww_change_meter		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_complaint_billing		Browse	Structure	Search	Insert	Empty	Drop	862	InnoDB	latin1_swedish_ci	80.0 KiB	-
ww_complaint_setup		Browse	Structure	Search	Insert	Empty	Drop	473	InnoDB	latin1_swedish_ci	64.0 KiB	-
ww_customer_application		Browse	Structure	Search	Insert	Empty	Drop	3,147	InnoDB	latin1_swedish_ci	1.6 MiB	-
ww_customer_application_details		Browse	Structure	Search	Insert	Empty	Drop	3,292	InnoDB	latin1_swedish_ci	576.0 KiB	-
ww_customer_meter_details		Browse	Structure	Search	Insert	Empty	Drop	3,281	InnoDB	latin1_swedish_ci	1.5 MiB	-
ww_customer_profile		Browse	Structure	Search	Insert	Empty	Drop	3,430	InnoDB	latin1_swedish_ci	448.0 KiB	-
ww_desc_work		Browse	Structure	Search	Insert	Empty	Drop	25	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_employee_withbenefit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_guaranty_deposit		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_guaranty_deposit_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_inspectors		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_maintenance_order		Browse	Structure	Search	Insert	Empty	Drop	87	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_maintenance_order_details		Browse	Structure	Search	Insert	Empty	Drop	87	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_offset		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_offset_details		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_offset_details_admin_tool		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_other_charges		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	64.0 KiB	-
ww_other_charges_admin_tool		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_other_charges_temp		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_payments_employee		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_payment_employee_dtl		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_payment_order		Browse	Structure	Search	Insert	Empty	Drop	138	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_payment_order_detail		Browse	Structure	Search	Insert	Empty	Drop	154	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_penalty_list		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_penalty_setup		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_plumberaccomplishmenttarget		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_plumbersetup		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_promissory		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_rating_scale_setup		Browse	Structure	Search	Insert	Empty	Drop	15	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_reconnection		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_senior_citizen_discount		Browse	Structure	Search	Insert	Empty	Drop	844	InnoDB	latin1_swedish_ci	112.0 KiB	-
ww_senior_citizen_discount_logs		Browse	Structure	Search	Insert	Empty	Drop	893	InnoDB	latin1_swedish_ci	112.0 KiB	-
ww_transfer		Browse	Structure	Search	Insert	Empty	Drop	242	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_type		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_water_billing		Browse	Structure	Search	Insert	Empty	Drop	10,257	InnoDB	latin1_swedish_ci	4.2 MiB	-
ww_water_billing_assgn_reader		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	latin1_swedish_ci	16.0 KiB	-
ww_water_billing_assgn_reader_dtl		Browse	Structure	Search	Insert	Empty	Drop	4,073	InnoDB	latin1_swedish_ci	304.0 KiB	-
ww_ww_cust_list_old		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
64 tables	Sum							~37,669	InnoDB	utf8_general_ci	10.3 MiB	0 B

Check all

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.