materiel.uk / 127.0.0.1 / materiel_cf_v1_verify_20260716b

There are no favourite tables.

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise 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 :

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark Query failed Database : Queried time :

Switch to visual builder

Saved bookmarked search:

Column:

Alias:

Show:

Sort:

Sort order:

Criteria:

Ins:	And:
Del:	Or:

Modify:

Or: And:
Ins Del

Ins Del

Add/Delete criteria rows:

Add/Delete columns:

Use tables

audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_document_highlights
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_reads
mh_document_versions
mh_document_view_sessions
mh_documents
mh_faq
mh_notifications
mh_question_likes
mh_questions
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_data_deduplication_map
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migration_execution_log
sys_migrations
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference