digi-gov.com / 127.0.0.1 / general

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
activation_status		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
activitylog		Browse	Structure	Search	Insert	Empty	Drop	743	InnoDB	latin1_swedish_ci	160.0 KiB	-
application_ot		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
approval_process		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
audit_logs		Browse	Structure	Search	Insert	Empty	Drop	43,576	InnoDB	latin1_swedish_ci	7.5 MiB	-
audit_logs_exlude		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
authorize_setup		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
businessaddresses		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	32.0 KiB	-
businesscontacts		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
db_configuration		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
deposit_attachment		Browse	Structure	Search	Insert	Empty	Drop	1,279	InnoDB	latin1_swedish_ci	876.5 MiB	-
filezillaaccounts		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
form_color		Browse	Structure	Search	Insert	Empty	Drop	252	InnoDB	latin1_swedish_ci	16.0 KiB	-
form_name		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
form_properties		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
lgu_city_mun_setup		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
lgu_city_mun_setup_temp		Browse	Structure	Search	Insert	Empty	Drop	2,319	MyISAM	latin1_swedish_ci	195.1 KiB	-
lgu_signatory		Browse	Structure	Search	Insert	Empty	Drop	31	InnoDB	latin1_swedish_ci	16.0 KiB	-
messages		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
patchcreation		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8_general_ci	16.0 KiB	-
patch_tracker		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
permissionobject		Browse	Structure	Search	Insert	Empty	Drop	6,715	InnoDB	latin1_swedish_ci	1.8 MiB	-
permissionobject_defaults		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
permissionroleobject		Browse	Structure	Search	Insert	Empty	Drop	17,915	InnoDB	latin1_swedish_ci	5.0 MiB	-
permissionroleobject_copy		Browse	Structure	Search	Insert	Empty	Drop	67	InnoDB	latin1_swedish_ci	16.0 KiB	-
projectacquisition		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
project_title		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
role		Browse	Structure	Search	Insert	Empty	Drop	533	InnoDB	latin1_swedish_ci	64.0 KiB	-
setup_code		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_company		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8_general_ci	16.0 KiB	-
setup_logs		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_project		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	64.0 KiB	-
setup_project_area		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_project_detail		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_project_office		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_security		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_security_dtl		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_signatory		Browse	Structure	Search	Insert	Empty	Drop	114	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_signatorytype		Browse	Structure	Search	Insert	Empty	Drop	31	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_status		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_system		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_title		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
setup_user		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
signatories		Browse	Structure	Search	Insert	Empty	Drop	40	InnoDB	latin1_swedish_ci	16.0 KiB	-
signatories_form_type		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
signatories_type		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
signatory_logs		Browse	Structure	Search	Insert	Empty	Drop	7,195	InnoDB	latin1_swedish_ci	2.0 MiB	-
signatory_setup		Browse	Structure	Search	Insert	Empty	Drop	20	InnoDB	latin1_swedish_ci	16.0 KiB	-
sigtype		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
specialaccess		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
specialaccesspermission		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
sso		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
systemformproperties		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
systemforms		Browse	Structure	Search	Insert	Empty	Drop	7,946	InnoDB	latin1_swedish_ci	3.3 MiB	-
systemprofile		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
systemprofileforms		Browse	Structure	Search	Insert	Empty	Drop	447	InnoDB	utf8_general_ci	96.0 KiB	-
systemprofileorders		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
systemreportingmanager		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	48.0 KiB	-
systemroleprofile		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8_general_ci	16.0 KiB	-
systemuserroleprofile		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	utf8_general_ci	48.0 KiB	-
system_themes		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8_general_ci	16.0 KiB	-
tbl_connection		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_councilor_setup		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_form_setup_series		Browse	Structure	Search	Insert	Empty	Drop	4,260	InnoDB	latin1_swedish_ci	240.0 KiB	-
tbl_general_elected_counselors		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_general_elected_officials		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_general_header_setup		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_general_location		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_general_setting		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_detail		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_details		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_entry_details		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_entry_main		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_main		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_rating		Browse	Structure	Search	Insert	Empty	Drop	25	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_rating_numerical		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_rating_scale		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_evaluation_title		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_main		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_rating_matrix		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_rating_matrix_details_quality		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_rating_matrix_details_system		Browse	Structure	Search	Insert	Empty	Drop	30	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_rating_scale		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_scalling		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_ipcr_work_category		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_opcr_detail		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_hr_opcr_main		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_ipcr_reviewed		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_issuance		Browse	Structure	Search	Insert	Empty	Drop	8,576	InnoDB	latin1_swedish_ci	2.1 MiB	-
tbl_login_logs		Browse	Structure	Search	Insert	Empty	Drop	52	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_order_personnel		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_signatoryform		Browse	Structure	Search	Insert	Empty	Drop	18	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_signatorymain		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_signatorypass		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_signatoryrank		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_signatorytype		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_form		Browse	Structure	Search	Insert	Empty	Drop	2,108	InnoDB	latin1_swedish_ci	352.0 KiB	-
tbl_user_form_copy		Browse	Structure	Search	Insert	Empty	Drop	1,612	InnoDB	latin1_swedish_ci	288.0 KiB	-
tbl_user_notif_access		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_notif_access_setup		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_restrictions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_restrictions_check		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_restrictions_journal		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	latin1_swedish_ci	16.0 KiB	-
tbl_user_security_alter		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
timelogs		Browse	Structure	Search	Insert	Empty	Drop	~146,318	InnoDB	latin1_swedish_ci	13.5 MiB	-
transaction_logs		Browse	Structure	Search	Insert	Empty	Drop	11,984	InnoDB	latin1_swedish_ci	1.5 MiB	-
userdepartment		Browse	Structure	Search	Insert	Empty	Drop	366	InnoDB	latin1_swedish_ci	16.0 KiB	-
useroverideaccess		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	latin1_swedish_ci	16.0 KiB	-
userprofiledefaultsettings		Browse	Structure	Search	Insert	Empty	Drop	1,261	InnoDB	latin1_swedish_ci	112.0 KiB	-
userprofilelist		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	latin1_swedish_ci	16.0 KiB	-
userrole		Browse	Structure	Search	Insert	Empty	Drop	197	InnoDB	latin1_swedish_ci	32.0 KiB	-
users		Browse	Structure	Search	Insert	Empty	Drop	63	InnoDB	latin1_swedish_ci	16.0 KiB	-
usersactivitylog		Browse	Structure	Search	Insert	Empty	Drop	3,857	InnoDB	latin1_swedish_ci	1.8 MiB	-
users_activities		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	latin1_swedish_ci	16.0 KiB	-
user_employee		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	latin1_swedish_ci	64.0 KiB	-
user_type		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	latin1_swedish_ci	16.0 KiB	-
version_no		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	latin1_swedish_ci	16.0 KiB	-
117 tables	Sum							~270,268	InnoDB	latin1_swedish_ci	918.4 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.