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: humanresource
Structure
(current)
SQL
Search
Query
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
Database structure
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:
1
2
3
>
>>
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_setup
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
acctg_action
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
activation_status
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
adjustment_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
agendasetup
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
allowances
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
utf8_general_ci
16.0
KiB
-
allowances_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
allowances_fixed
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
allowances_jo
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
applicants
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
32.0
KiB
-
applicant_skills
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
application_ot
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
appointmentdocument
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
appointmentparticipant
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
appointments
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
utf8_general_ci
16.0
KiB
-
approved_email_logs
Browse
Structure
Search
Insert
Empty
Drop
286
InnoDB
latin1_swedish_ci
16.0
KiB
-
approved_employee_ot
Browse
Structure
Search
Insert
Empty
Drop
4,257
InnoDB
latin1_swedish_ci
384.0
KiB
-
approved_ot
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
bank_setup
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
barangay
Browse
Structure
Search
Insert
Empty
Drop
28
InnoDB
latin1_swedish_ci
16.0
KiB
-
billing
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
bio_employees
Browse
Structure
Search
Insert
Empty
Drop
764
InnoDB
latin1_swedish_ci
80.0
KiB
-
bplo_attatchment
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
2.5
MiB
-
budget_controller
Browse
Structure
Search
Insert
Empty
Drop
46
InnoDB
latin1_swedish_ci
16.0
KiB
-
budget_controller_jo
Browse
Structure
Search
Insert
Empty
Drop
37
InnoDB
latin1_swedish_ci
16.0
KiB
-
caldays
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
calendar
Browse
Structure
Search
Insert
Empty
Drop
144
InnoDB
latin1_swedish_ci
16.0
KiB
-
cao_business_list
Browse
Structure
Search
Insert
Empty
Drop
686
InnoDB
latin1_swedish_ci
256.0
KiB
-
cao_business_list_main
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashadvacewalkin
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashliquidation
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashliquidation_detail
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cash_advances
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
cash_advances_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
cash_advance_payed
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
clearance_attachments
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
clearance_comment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
committeecreatedminutes
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
committeemembers
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
committeeminutetemplates
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
committees
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
committee_agenda
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
committee_attachmentlinks
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
committee_attendees
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_rpt_payments_advance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
currency
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
32.0
KiB
-
dash_assistance_survey
Browse
Structure
Search
Insert
Empty
Drop
24
InnoDB
latin1_swedish_ci
16.0
KiB
-
dash_assistance_survey_setup
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
dash_rating
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
deduction
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
deductions_status_employee
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
latin1_swedish_ci
16.0
KiB
-
deductionto_atm_amount
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
deductiontype
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
deduction_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
deduction_pause
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
deduction_schedule
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
department
Browse
Structure
Search
Insert
Empty
Drop
29
InnoDB
latin1_swedish_ci
16.0
KiB
-
department_division
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
department_pmd
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
department_pmdbkp
Browse
Structure
Search
Insert
Empty
Drop
202
InnoDB
latin1_swedish_ci
80.0
KiB
-
department_shift
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
developer
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
disbursement
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
disbursement_dtls
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
division
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
division_setup
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
dmmy
Browse
Structure
Search
Insert
Empty
Drop
22
InnoDB
latin1_swedish_ci
16.0
KiB
-
drivers_equipment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
dtr
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
dtr_approved_head
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
32.0
KiB
-
dtr_approved_head_setup
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
dtr_approved_payrollmaker
Browse
Structure
Search
Insert
Empty
Drop
1,659
InnoDB
latin1_swedish_ci
144.0
KiB
-
dtr_rules_setup
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
dummy_date
Browse
Structure
Search
Insert
Empty
Drop
122
InnoDB
latin1_swedish_ci
16.0
KiB
-
dummy_employee
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
dummy_t
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
duplicate_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
ebplo_other_certificates_form
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
ebplo_other_certificates_type
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
ecswd_travel_order
Browse
Structure
Search
Insert
Empty
Drop
40
InnoDB
latin1_swedish_ci
32.0
KiB
-
ecswd_travel_order_dtail
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
ecswd_travel_order_purpose
Browse
Structure
Search
Insert
Empty
Drop
78
InnoDB
latin1_swedish_ci
16.0
KiB
-
employeedepartment
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employees
Browse
Structure
Search
Insert
Empty
Drop
1,040
InnoDB
latin1_swedish_ci
640.0
KiB
-
employees_allowances
Browse
Structure
Search
Insert
Empty
Drop
125
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_assignment
Browse
Structure
Search
Insert
Empty
Drop
59
InnoDB
latin1_swedish_ci
32.0
KiB
-
employees_bkp
Browse
Structure
Search
Insert
Empty
Drop
1,454
InnoDB
latin1_swedish_ci
1.8
MiB
-
employees_change_timeshift
Browse
Structure
Search
Insert
Empty
Drop
117
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_civilserviceeligibility
Browse
Structure
Search
Insert
Empty
Drop
73
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_copy
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
112.0
KiB
-
employees_copy_copy
Browse
Structure
Search
Insert
Empty
Drop
1,114
InnoDB
latin1_swedish_ci
608.0
KiB
-
employees_dependent
Browse
Structure
Search
Insert
Empty
Drop
154
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_designation_history
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_eduback
Browse
Structure
Search
Insert
Empty
Drop
753
InnoDB
latin1_swedish_ci
112.0
KiB
-
employees_familybackground
Browse
Structure
Search
Insert
Empty
Drop
1,044
InnoDB
latin1_swedish_ci
96.0
KiB
-
employees_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
employees_leave_credits
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_limit
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_otherinfos
Browse
Structure
Search
Insert
Empty
Drop
1,044
InnoDB
latin1_swedish_ci
128.0
KiB
-
employees_position
Browse
Structure
Search
Insert
Empty
Drop
530
InnoDB
latin1_swedish_ci
96.0
KiB
-
employees_premiums
Browse
Structure
Search
Insert
Empty
Drop
430
InnoDB
latin1_swedish_ci
80.0
KiB
-
employees_rate
Browse
Structure
Search
Insert
Empty
Drop
929
InnoDB
latin1_swedish_ci
192.0
KiB
-
employees_rate_bkp
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_reference
Browse
Structure
Search
Insert
Empty
Drop
43
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_section
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_skillshobbies
Browse
Structure
Search
Insert
Empty
Drop
39
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_timeshift
Browse
Structure
Search
Insert
Empty
Drop
146
InnoDB
latin1_swedish_ci
80.0
KiB
-
employees_timeshift_copy
Browse
Structure
Search
Insert
Empty
Drop
43
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_trainingprogram
Browse
Structure
Search
Insert
Empty
Drop
1,564
InnoDB
latin1_swedish_ci
240.0
KiB
-
employees_trainingprogram1
Browse
Structure
Search
Insert
Empty
Drop
111
InnoDB
latin1_swedish_ci
48.0
KiB
-
employees_voluntarilywork
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
employees_workexperience
Browse
Structure
Search
Insert
Empty
Drop
312
InnoDB
latin1_swedish_ci
64.0
KiB
-
employees_work_history_ledger
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_attachment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_attachments
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
employee_blocked
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_blocked_byhr
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_bloodtype
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_clearance
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_deduction_status
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_eduback
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_hiring_entity
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_information
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_information1
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_information2
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_information3
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_information4
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_information5
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_informationupdated
Browse
Structure
Search
Insert
Edit
Drop
~0
This view has at least this number of rows. Please refer to
documentation
.
View
---
-
-
employee_medicalreport
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_medical_laboratoryresult
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_medical_pastillness
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_medical_pe_findings
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_medical_physicalexamination
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_medical_status
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_otherinfo
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_profile_pic
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
employee_references
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_sal_type
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_signatory
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_skills
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_skillsandreference
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_skillset
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_status
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_type
Browse
Structure
Search
Insert
Empty
Drop
14
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_workexperience
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
emp_service_record
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
emp_transfer_dept_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
emp_transfer_dept_history_detail
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
equip
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
eventcalendarrange
Browse
Structure
Search
Insert
Empty
Drop
137
InnoDB
latin1_swedish_ci
16.0
KiB
-
finger_logs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
fixed_other_allowances
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
gender
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
groups
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
history_active_inactive
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
history_blocked_byhr
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
history_position
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_action
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_ara_form_a
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_ara_form_d
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_ara_form_e
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_ara_form_e_setup
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_biometric_logs
Browse
Structure
Search
Insert
Empty
Drop
~1,352,234
InnoDB
latin1_swedish_ci
238.5
MiB
-
hr_biometric_logs_dummy
Browse
Structure
Search
Insert
Empty
Drop
2,379
InnoDB
latin1_swedish_ci
224.0
KiB
-
hr_biometric_logs_history
Browse
Structure
Search
Insert
Empty
Drop
269
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_biometric_logs_history_transcient
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_biometric_logs_transcient
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_biometric_terminal
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_biometric_user_data
Browse
Structure
Search
Insert
Empty
Drop
665
InnoDB
latin1_swedish_ci
1.5
MiB
-
hr_biometric_user_info
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_certificate_data
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
96.0
KiB
-
hr_certificate_data_details
Browse
Structure
Search
Insert
Empty
Drop
70
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_certificate_setup
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_certificate_table_template
Browse
Structure
Search
Insert
Empty
Drop
14
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_cert_of_appearance
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_agenda
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_agenda_attendee
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_metting
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_metting_attendance
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_resolution
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_setup
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_committee_setup_member
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_employee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
80.0
KiB
-
hr_emp_afingerprint
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_assigning_projectsite
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_attendance
Browse
Structure
Search
Insert
Empty
Drop
18,596
InnoDB
utf8_general_ci
3.0
MiB
-
hr_emp_attendance_copy
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
hr_emp_attendance_jo
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
hr_emp_attendance_manualentry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
hr_emp_attendance_othersite
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
hr_emp_empltype
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_leaves
Browse
Structure
Search
Insert
Empty
Drop
525
InnoDB
latin1_swedish_ci
64.0
KiB
-
hr_emp_leave_accumulatation
Browse
Structure
Search
Insert
Empty
Drop
322
InnoDB
latin1_swedish_ci
64.0
KiB
-
hr_emp_leave_accumulatation_history
Browse
Structure
Search
Insert
Empty
Drop
347
InnoDB
latin1_swedish_ci
64.0
KiB
-
hr_emp_leave_accumulate_ranz
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_leave_credits
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_emp_leave_type
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_private_leavecredit
Browse
Structure
Search
Insert
Empty
Drop
320
InnoDB
latin1_swedish_ci
64.0
KiB
-
hr_emp_projectsite
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_service_records
Browse
Structure
Search
Insert
Empty
Drop
3,213
InnoDB
latin1_swedish_ci
336.0
KiB
-
hr_emp_shift
Browse
Structure
Search
Insert
Empty
Drop
611
InnoDB
latin1_swedish_ci
80.0
KiB
-
hr_holidays
Browse
Structure
Search
Insert
Empty
Drop
89
InnoDB
utf8_general_ci
32.0
KiB
-
hr_holidays_special
Browse
Structure
Search
Insert
Empty
Drop
24
InnoDB
utf8_general_ci
32.0
KiB
-
hr_job_status
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_leave_type
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_dependents
Browse
Structure
Search
Insert
Empty
Drop
18
InnoDB
utf8_general_ci
16.0
KiB
-
hr_person_educational_bg
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_eligibility
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_family_bg
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_person_other_info
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_profile
Browse
Structure
Search
Insert
Empty
Drop
18
InnoDB
utf8_general_ci
16.0
KiB
-
hr_person_reference
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
hr_person_skills
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_training
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_voluntary_work
Browse
Structure
Search
Insert
Empty
Drop
32
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_person_work_exp
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_best_department
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_best_employee
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_clearance
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_computation_amnt_setup
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_computation_terminal_leave
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_drugselectionlist
Browse
Structure
Search
Insert
Empty
Drop
292
InnoDB
latin1_swedish_ci
80.0
KiB
-
hr_tbl_emp_update_logs
Browse
Structure
Search
Insert
Empty
Drop
23
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_exit_interview
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_increment_sched
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_loyalty_bonus
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_loyalty_setup
Browse
Structure
Search
Insert
Empty
Drop
21
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_memos_and_violations_dtl
Browse
Structure
Search
Insert
Empty
Drop
58
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_memos_and_violations_main
Browse
Structure
Search
Insert
Empty
Drop
22
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_offenses
Browse
Structure
Search
Insert
Empty
Drop
55
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_offenses_type
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_offense_category
Browse
Structure
Search
Insert
Empty
Drop
16
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_organizational_setup
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_perfect_attendance
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_pre_retirement
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_rating_setup
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_rating_setup_details
Browse
Structure
Search
Insert
Empty
Drop
25
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_retirement_setup
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_retire_separate_logs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_salary_adjustment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_salary_adjustment_bkp
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_salary_adjustment_copy
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_section_setup
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_separation
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_tbl_setup_rated
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
ielts_detail
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
inactive_active_history
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
incentives
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
32.0
KiB
-
incident_report
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
250 tables
Sum
~1,400,377
InnoDB
latin1_swedish_ci
255.5 MiB
0 B
Check all
With selected:
Copy table
Show create
Export
Empty
Drop
Analyze table
Check table
Checksum table
Optimize table
Repair table
Add prefix to table
Replace table prefix
Copy table with prefix
Page number:
1
2
3
>
>>
Print
Data dictionary
Create new table
Table name
Number of columns
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.