Recent
`performance_schema`.`socket_summary_by_instance`
`accounting`.`division_setup`
`documenttracker`.`it_preventive_maintenance`
`documenttracker`.`documenttrackerdetails_return`
`documenttracker`.`actuaflowmembers`
`performance_schema`.`setup_actors`
`general`.`setup_code`
`general`.`setup_signatory`
`general`.`systemroleprofile`
`humanresource`.`appointments`
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: dbfederation
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
Query window
*
id
org_id
trans_date
end_date
session_name
agenda_name
user_id
stataus
*
id
agenda_id
user_id
org_id
attend
ts
*
id
agenda_id
agenda
ts
*
id
agenda_id
uid
ts
*
id
agenda_id
minutes_id
file_name
path_name
stat
*
id
agenda_id
ref_no
trans_date
start
end
held
call_order_uid
invocated_uid
adjourned_uid
status
docs
*
id
agenda_id
res_id
uid
att
sponsor
co_sponsor
trans_type
*
id
agenda_id
file_name
path_name
trans_type
*
id
agenda_id
ref_no
trans_date
effective_date
approved_date
place_held
title
trans_type
status
docs
*
id
connection
queue
payload
exception
failed_at
*
id
agenda_id
*
id
migration
batch
*
permission_id
model_type
model_id
*
role_id
model_type
model_id
*
id
user_id
client_id
name
scopes
revoked
created_at
updated_at
expires_at
*
id
user_id
client_id
scopes
revoked
expires_at
*
id
user_id
name
secret
redirect
personal_access_client
password_client
revoked
created_at
updated_at
*
id
client_id
created_at
updated_at
*
id
access_token_id
revoked
expires_at
*
email
token
created_at
*
id
name
guard_name
created_at
updated_at
*
id
tokenable_type
tokenable_id
name
token
abilities
last_used_at
created_at
updated_at
*
id
brgyCode
brgyDesc
regCode
provCode
citymunCode
*
id
psgcCode
citymunDesc
regDesc
provCode
citymunCode
*
id
psgcCode
provDesc
regCode
provCode
*
id
psgcCode
regDesc
regCode
*
id
name
guard_name
created_at
updated_at
*
permission_id
role_id
*
id
transDate
groupType
description
remarks
transStat
created_at
updated_at
*
SysPK_Brgy
city_mun_id
brgy_id
brgy_name
checker
brgy_code
URBAN_RURAL
POPULATION
CITY
PROVINCE
REGION
person_code
stat
brgy_code1
*
id
education
trans_stat
created_at
updated_at
*
id
pkID
educ_type
school_name
school_addr
inclusive_yr
grad_type
honors_received
degree_received
title_received
trans_stat
created_at
updated_at
*
id
graduate
trans_stat
created_at
updated_at
*
id
trans_no
trans_date
pkID
orgID
org_name
chapter
posID
position
year_affiliated
memberID
sector_id
dateSigned
dateReceived
dateRegistered
trans_stat
created_at
updated_at
*
id
posID
position
orgID
organization
pkID
personName
termFrom
termTo
effectivity
trans_stat
created_at
updated_at
*
id
org_prof_id
org_adv_dtl_id
*
id
main_id
description
type
*
id
description
type
*
id
org_prof_id
level_setup_id
*
id
description
*
id
org_prof_id
major_class_setup_id
*
id
description
*
id
organization_name
chapter
registered_members
date_registration
date_estatblished
room_floor
block_lot
street
barangay
city_mun_town
provice
zip_code
mobile_no
tel_no
office_email_add
office_mailing_add
description_remarks
vision_statement
mission_statement
status
save_date
*
id
emp_id
brgy_id
postion_id
barangay_name
name
position
priority
*
id
org_prof_id
sub_class_setup_id
*
id
description
*
id
pkID
orgID
org_name
chapter
posID
position
year_affiliated
trans_stat
created_at
updated_at
*
id
pkID
lastName
middleName
firstName
fullname
relation
occupation
mobileNo
trans_stat
*
pkID
user_id
prefix
fname
mname
lname
suffix
nickname
dob
pob
gender
civilStatus
citizenship
height
weight
religion
occupation
bloodType
address1
address2
street
barangay_id
barangay
cityMun_id
cityMun
province_id
province
region
zipcode
address1_
address2_
street_
barangay_id_
barangay_
cityMun_id_
cityMun_
province_id_
province_
region_
zipcode_
telNo
cellNo
emailAdd
facebook
twitter
instagram
trans_stat
created_at
updated_at
*
id
orgID
posID
pos_count
position
remarks
effectivity
transStat
created_at
updated_at
*
id
description
remarks
*
id
relation
trans_stat
created_at
updated_at
*
id
name
email
email_verified_at
password
verified
Employee_id
remember_token
status
created_at
updated_at
image_path
*
user_id
token
created_at
updated_at
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
agenda
agenda_attend
agenda_minutes_agenda
agenda_minutes_attendance
agenda_minutes_docs
agenda_minutes_main
agenda_resolution_ord_details
agenda_resolution_ord_docs
agenda_resolution_ord_main
failed_jobs
menutes_main
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
roles
role_has_permissions
setup
tbl_brgy_setup
tbl_education
tbl_educ_info
tbl_graduate
tbl_member_info
tbl_official_info
tbl_organization_advocacies
tbl_organization_advocacies_dtls_setup
tbl_organization_advocacies_setup
tbl_organization_level
tbl_organization_level_setup
tbl_organization_major_class
tbl_organization_major_class_setup
tbl_organization_profile
tbl_organization_structure
tbl_organization_sub_class
tbl_organization_sub_class_setup
tbl_org_info
tbl_other_info
tbl_person_setup
tbl_position_info
tbl_postion_setup
tbl_relation
users
verify_users
.
select column
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.