Recent
`humanresource`.`appointmentdocument`
`general`.`transaction_logs`
`humanresource`.`activation_status`
`humanresource`.`dummy_t`
`service_request_db`.`app_systems`
`accounting`.`documentmanager`
`general`.`patchcreation`
`general`.`setup_system`
`general`.`setup_title`
`performance_schema`.`cond_instances`
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
Table: appointmentdocument
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Triggers
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
Table structure
Relation view
Foreign key constraints
Actions
Constraint properties
Column
Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.
Foreign key constraint (INNODB)
Database
Table
Column
ON DELETE
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
CASCADE
SET NULL
NO ACTION
RESTRICT
AppGUID
DocumentName
DocumentType
ID
_Data
+ Add column
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance_management
performance_schema
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip2
payslip_copy
payslip_dole
payslip_dtr
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
+ Add constraint
Loading
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.