Recent
`qpsii_lguprocurement`.`inspectioncategory`
`qpsii_lguprocurement`.`gso_signatories_per_user`
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: qpsii_lguprocurement
Table: inspectioncategory
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
CATEGORY
ID
PERSONNELID
PERSONNELNAME
STATUS
+ 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
acquisitionanddisposal
adjustment_main
advances
advancesdtls
appointments
approvalcomments
approvalprofile
approval_process
assetare
assetarehistory
assetareitems
assetborrower
assetfundcluster
assethistory
assetinventory
assetissuance
assetissuance_details
assetpropertyrequest
assetpropertyrequestdtls
assetpropertyreturndetails
assetpropertyreturnmain
assetpropertytransfer
assetpropertytransfer_items
assetreservationdetails
assetreservationmain
assetreturned
assetreturned_details
asset_eu_accessories
asset_eu_breaksystem
asset_eu_cushion
asset_eu_differentialassy
asset_eu_electrical
asset_eu_engine
asset_eu_finaldrive
asset_eu_gauges
asset_eu_main
asset_eu_profellershaftassy
asset_eu_steeringsystem
asset_eu_suspensions
asset_eu_undercarriages
asset_eu_wheels
asset_iirupitem
asset_iirupmain
asset_ptc
asset_ptc_dtl
attachemnt_location
bacc_1pre
bacc_2invitationtobid
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_commite_tag
bacc_invitation_prebid
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_docs
bacprocurementprocess
bacprocurementprocessactual
bac_document_receiver_seq
bac_process_checklist
bac_procurement_process
bac_project_monitor
business_terms
business_type
checklist
currencylist
delivery_inspection
documents
doc_tracking
fuel_slip
gso_acknowledgementreceiptforequipment
gso_acknowledgementreceiptforequipment_details
gso_forms
gso_itemsetup
gso_item_sub_details
gso_signatories
gso_signatories_list
gso_signatories_list_eng
gso_signatories_per_user
gso_signatories_position
gso_signatories_value
gso_signatories_value_eng
hr_person_profile
iarprocess
ics_details
ics_main
infra_canvass_details
infra_canvass_main
infra_canvass_signatory
infra_po_details
infra_po_main
infra_po_signatory
infra_pr_details
infra_pr_main
infra_pr_signatory
infra_rr_details
infra_rr_main
infra_rr_signatory
inspectioncategory
inspection_and_acceptance_detail
inspection_and_acceptance_main
inspection_and_acceptance_signatory
inventory
inventory_category
inventory_custodial_slip
inventory_details
inventory_lgu
inventory_main
inventory_master
inventory_physical
inventory_transfer
inventory_transfer_dtls
issuance
issuancetype
issuance_detail
issuance_signatory
item_assembly
item_maincategory
item_return
item_return_detail
item_return_signatory
item_specifications
item_subcategory
jobout_repair
jtbl_accomplishmententry
jtbl_accomplishmententry_details
jtbl_activity
jtbl_ahdp
jtbl_ahdp_details
jtbl_category
jtbl_category_details
jtbl_facility
jtbl_facilitysetup
jtbl_facilitysetup_details
jtbl_garbage_disposal
jtbl_garbage_pickup
jtbl_garbage_pickup_details
jtbl_garbage_truck
jtbl_livebirthregistry
jtbl_location
jtbl_maintenancework_boqdetails
jtbl_maintenancework_main
jtbl_marriage
jtbl_mcs
jtbl_periodic_maintenance
jtbl_periodic_maintenance_details
jtbl_projects
jtbl_repairmaintenance_request
jtbl_repairmaintenance_request_detail
jtbl_requestforrepair_boqdetails
jtbl_requestforrepair_main
jtbl_requestmaterial
jtbl_requestmaterial_details
jtbl_routinary_functions
jtbl_routinary_functions_details
jtbl_routinary_others
jtbl_routinary_others_details
jtbl_section
jtbl_section_members
jtbl_waste_type
jtbl_water_delivery
jtbl_water_delivery_details
lookandfeel
material_request
modeimplementation
motorpool_component_setup
motorpool_drivers_trip_ticket
motorpool_driver_setup
motorpool_equipment_setup
motorpool_fuel_purchase
motorpool_fuel_purchase_items
motorpool_fuel_type
motorpool_lubricant_type
motorpool_natureofrequest
motorpool_repair_inspection
motorpool_repair_inspection_detail
motorpool_request_repair
motorpool_request_repair_detail
motorpool_request_repair_main
motorpool_serviceactivity_setup
motorpool_service_setup
motorpool_vehiclesetup
motorpool_vehicle_details
motorpool_vehicle_group
motorpool_vehicle_logs
motorpool_vehicle_maintenance
motorpool_vehicle_maintenance_detail
motorpool_vehicle_master
motorpool_vehicle_reservation_details
motorpool_vehicle_reservation_main
motorpool_vehicle_setup
motorpool_vehicle_type
motorpool_weeklyvehiclecheck_external
motorpool_weeklyvehiclecheck_external_detail
motorpool_weeklyvehiclecheck_fluids
motorpool_weeklyvehiclecheck_fluids_detail
motorpool_weeklyvehiclecheck_internal
motorpool_weeklyvehiclecheck_internal_detail
motorpool_weeklyvehiclecheck_light
motorpool_weeklyvehiclecheck_lights_detail
motorpool_weekly_vehicle_check_main
notifications
numberformat
ordinal_number
ors_details
ors_main
pms_inspection
pms_item
pms_main
pms_maintenance
post_inspection_detail
post_inspection_main
post_inspection_signatory
powinfrahaulage
powinfraitems
powinframain
powinframateriallabor
powinfrarental
powinfrasignatories
powinfrasof
powinfrasummary
pow_activity_items
pow_activity_main
pow_breakdown_list
pow_details_dtl
pow_details_dtl_
pow_detail_individual
pow_detail_type
pow_dupa_equipment
pow_dupa_item
pow_dupa_item_dtl
pow_dupa_labor
pow_equipment_required
pow_equip_person
pow_main_individual
pow_main_individual_attachemnt
pow_main_individual_signatory
pow_personnel_required
pow_processes
pow_requirements
pow_sof_detail
po_receive_form
ppacustom_table5109
ppacustom_table5110
ppa_band
ppa_columns
ppa_reportheader
ppa_signatory1
ppa_tables
ppa_tables_transactions
pre_details_dtl
pre_inspection_detail
pre_inspection_main
pre_inspection_report_approve_status
pre_inspection_signatory
print_settings
program_of_work
program_of_work_detail
program_of_work_signatory
proj_prog_act
propertycard
propertycarddtls
propertycarddtls_biological
propertycarddtls_other
propertycard_other
pr_mode_request
pr_sof_detail
purchase_order_pod
purchase_request2
purchase_request2_dtl
purchase_request2_signatory
related_to_type
requestforinspection
requestforinspectionconcern
requestforinspectiondtl
request_for_inspectiontype_detail
request_for_inspection_detail
request_for_inspection_main
request_for_inspection_type
request_for_quotation_detail
request_for_quotation_docs
request_for_quotation_docs_copy
request_for_quotation_docs_dummy
request_for_quotation_main
request_for_quotation_supplier
resources
rfq_report_signatory
semiexpandablecard
semiexpandablecarddtls
setup_brand
setup_delivery_term
setup_group
setup_group_detail
setup_group_detail_copy
setup_group_type
setup_group_wh
setup_item_supplier_default
setup_payment_term
setup_project_registration_attachemnt
setup_project_registration_breakdown
setup_project_registration_breakdown_default
setup_project_registration_breakdown_list
setup_project_registration_equip_person
setup_project_registration_funds
setup_project_registration_items
setup_project_registration_sub_breakdown
setup_qty_packing
setup_sof
sp_resolution
sp_resolution_img
sp_resolution_pre
sp_resolution_pre_img
suppliesinquiry
suppliesinquiry_dtls
system_settings
tbl_canvass_approve_status
tbl_canvass_detail
tbl_canvass_documnets
tbl_canvass_main
tbl_canvass_signatory
tbl_canvass_supplier
tbl_cicro_complain_concern
tbl_cicro_service_beneficiary_docx
tbl_cicro_service_beneficiary_list
tbl_cicro_service_caravan
tbl_cicro_service_caravan_brgy
tbl_cicro_service_caravan_dept
tbl_cicro_service_caravan_no_bene
tbl_cicro_service_caravan_setup
tbl_documents_setup
tbl_dps_accomplishement_entry
tbl_dps_accomplishement_entry_dtl
tbl_dps_facility_area_setup
tbl_dps_facility_area_setup_dtl
tbl_dps_facility_setup
tbl_dps_facility_setup_dtl_area
tbl_dps_facility_setup_dtl_material
tbl_dps_request_material
tbl_dps_request_material_dtl
tbl_eceo_dupa_equipment
tbl_eceo_dupa_equipment_dummy
tbl_eceo_dupa_item
tbl_eceo_dupa_item_dtl
tbl_eceo_dupa_item_dtl_dummy
tbl_eceo_dupa_item_dummy
tbl_eceo_dupa_labor
tbl_eceo_dupa_labor_dummy
tbl_eceo_svp_record
tbl_form_setup_series
tbl_gso_signatories
tbl_item_type
tbl_po_detail
tbl_po_main
tbl_po_signatory
tbl_prerepair_generate_percentage
tbl_progress_billing
tbl_prog_bill_setup
tbl_project_category
tbl_pr_detail
tbl_pr_main
tbl_pr_project_item
tbl_pr_signatory
tbl_pr_status
tbl_reasons
tbl_repair_signatory
tbl_rfq_signatory
tbl_supplier
tbl_supplier_type_setup
tbl_supplier___
tbl_transaction_signatory
tbl_uom
tbl_uom_conversion
tbl_user_form
tbl_user_form_copy
tb_po_approve_status
transaction_logs
tripticket
tripticketdtl
tripticketmain
type_of_road
unserviceableequipment
unserviceableequipmentchecklist
vehicle_reservation_calendar
vehicle_reservation_calendar_resources
vendor_type
voucher_computation_dtls
waste_material
waste_material_certifications
waste_material_certification_detail
waste_material_details
waste_material_signatory
withdrawal
withdrawal_details
withdrawal_signatory
_temp_canvass_supplier
_temp_canvass_supplier_infra
+ 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.