materiel.uk / 127.0.0.1 / materiel

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 :

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.

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
audit_log		Browse	Structure	Search	Insert	Empty	Drop	3,925	InnoDB	utf8mb4_general_ci	912.0 KiB	-
audit_log_archive		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	112.0 KiB	-
audit_trail		Browse	Structure	Search	Insert	Empty	Drop	18,209	InnoDB	utf8mb4_general_ci	16.4 MiB	-
audit_trail_archive		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	128.0 KiB	-
core_agama		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_general_ci	64.0 KiB	-
core_bangsa		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	64.0 KiB	-
core_kepakaran		Browse	Structure	Search	Insert	Empty	Drop	29	InnoDB	utf8mb4_general_ci	48.0 KiB	-
core_kepakaran_tred_rank		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_general_ci	32.0 KiB	-
core_login_attempts		Browse	Structure	Search	Insert	Empty	Drop	1,592	InnoDB	utf8mb4_general_ci	624.0 KiB	-
core_no_tentera		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	16.0 KiB	-
core_pangkat		Browse	Structure	Search	Insert	Empty	Drop	24	InnoDB	utf8mb4_general_ci	128.0 KiB	-
core_profile_picture_backup		Browse	Structure	Search	Insert	Empty	Drop	20	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
core_profile_posting_history		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	48.0 KiB	-
core_profile_posting_postponement		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	32.0 KiB	-
core_profile_rank_history		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
core_user		Browse	Structure	Search	Insert	Empty	Drop	206	InnoDB	utf8mb4_general_ci	384.0 KiB	-
core_user_roles		Browse	Structure	Search	Insert	Empty	Drop	15	InnoDB	utf8mb4_general_ci	160.0 KiB	-
core_user_roles_archive		Browse	Structure	Search	Insert	Empty	Drop	43,577	InnoDB	utf8mb4_unicode_ci	9.5 MiB	-
fleet_component_category		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	80.0 KiB	-
fleet_component_field_definition		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_general_ci	48.0 KiB	-
fleet_component_field_value		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
fleet_component_master		Browse	Structure	Search	Insert	Empty	Drop	7,362	InnoDB	utf8mb4_general_ci	7.7 MiB	-
fleet_component_recovery_archive		Browse	Structure	Search	Insert	Empty	Drop	660	InnoDB	utf8mb4_general_ci	512.0 KiB	-
fleet_component_retirement_archive		Browse	Structure	Search	Insert	Empty	Drop	12,103	InnoDB	utf8mb4_general_ci	14.2 MiB	-
fleet_kenderaan		Browse	Structure	Search	Insert	Empty	Drop	875	InnoDB	utf8mb4_general_ci	528.0 KiB	-
fleet_maintenance_status		Browse	Structure	Search	Insert	Empty	Drop	290	InnoDB	utf8mb4_general_ci	208.0 KiB	-
fleet_rekod_pegangan		Browse	Structure	Search	Insert	Empty	Drop	34	InnoDB	utf8mb4_general_ci	64.0 KiB	-
fleet_rekod_pegangan_detail		Browse	Structure	Search	Insert	Empty	Drop	92	InnoDB	utf8mb4_general_ci	48.0 KiB	-
fleet_repair		Browse	Structure	Search	Insert	Empty	Drop	21	InnoDB	utf8mb4_general_ci	160.0 KiB	-
fleet_repair_kewpa10		Browse	Structure	Search	Insert	Empty	Drop	22	InnoDB	utf8mb4_general_ci	64.0 KiB	-
fleet_repair_vehicle_snapshot		Browse	Structure	Search	Insert	Empty	Drop	20	InnoDB	utf8mb4_general_ci	64.0 KiB	-
jawatan_authority_map		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	128.0 KiB	-
jawatan_authority_map_archive		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
jawatan_authority_tag		Browse	Structure	Search	Insert	Empty	Drop	11	InnoDB	utf8mb4_general_ci	96.0 KiB	-
jawatan_authority_tag_archive		Browse	Structure	Search	Insert	Empty	Drop	5,291	InnoDB	utf8mb4_unicode_ci	1.8 MiB	-
jawatan_conflict_log		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	112.0 KiB	-
jawatan_master		Browse	Structure	Search	Insert	Empty	Drop	65	InnoDB	utf8mb4_general_ci	112.0 KiB	-
jawatan_merge_log		Browse	Structure	Search	Insert	Empty	Drop	5	InnoDB	utf8mb4_general_ci	48.0 KiB	-
jawatan_scope		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	144.0 KiB	-
jawatan_user_assignment		Browse	Structure	Search	Insert	Empty	Drop	120	InnoDB	utf8mb4_general_ci	160.0 KiB	-
mh_ai_feedback		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
mh_answers		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
mh_bookmarks		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
mh_broadcasts		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_clarifications		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
mh_comments		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_contributor_points		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_documents		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_general_ci	112.0 KiB	-
mh_document_highlights		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_document_reads		Browse	Structure	Search	Insert	Empty	Drop	19	InnoDB	utf8mb4_general_ci	80.0 KiB	-
mh_document_read_events		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
mh_document_read_pages		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
mh_document_read_reminders		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
mh_document_versions		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_document_view_sessions		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_faq		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_notifications		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_questions		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	112.0 KiB	-
mh_question_likes		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
mh_search_logs		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_sharing		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
mh_verification_history		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pakaian_audit_access_window		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
pakaian_item		Browse	Structure	Search	Insert	Empty	Drop	35	InnoDB	utf8mb4_general_ci	96.0 KiB	-
pakaian_item_component		Browse	Structure	Search	Insert	Empty	Drop	41	InnoDB	utf8mb4_general_ci	96.0 KiB	-
pakaian_kategori		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pakaian_maklumat_audit_log		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pakaian_maklumat_user		Browse	Structure	Search	Insert	Empty	Drop	7	InnoDB	utf8mb4_general_ci	80.0 KiB	-
pakaian_permohonan		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	176.0 KiB	-
pakaian_permohonan_attachment		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pakaian_permohonan_item		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	80.0 KiB	-
pakaian_permohonan_item_component		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	128.0 KiB	-
pakaian_permohonan_reason		Browse	Structure	Search	Insert	Empty	Drop	8	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pakaian_permohonan_timeline		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_general_ci	48.0 KiB	-
pakaian_perolehan_allocation		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	96.0 KiB	-
pakaian_perolehan_batch		Browse	Structure	Search	Insert	Empty	Drop	1	InnoDB	utf8mb4_general_ci	128.0 KiB	-
pakaian_perolehan_transaksi		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_general_ci	128.0 KiB	-
pakaian_running_number		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	32.0 KiB	-
pakaian_stock_forecast		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	32.0 KiB	-
pakaian_stok_lokasi		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	80.0 KiB	-
pakaian_stok_lokasi_allocation		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	176.0 KiB	-
pakaian_wakil_authorization		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	80.0 KiB	-
pemandu		Browse	Structure	Search	Insert	Empty	Drop	83	InnoDB	utf8mb4_general_ci	176.0 KiB	-
pemandu_bat_b3017		Browse	Structure	Search	Insert	Empty	Drop	39	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pemandu_bat_d41		Browse	Structure	Search	Insert	Empty	Drop	78	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pemandu_kemahiran_khas		Browse	Structure	Search	Insert	Empty	Drop	43	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pemandu_lesen_awam		Browse	Structure	Search	Insert	Empty	Drop	39	InnoDB	utf8mb4_general_ci	64.0 KiB	-
pemandu_spanco		Browse	Structure	Search	Insert	Empty	Drop	39	InnoDB	utf8mb4_general_ci	80.0 KiB	-
pemandu_unit_admin		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	80.0 KiB	-
ref_jenis_kenderaan		Browse	Structure	Search	Insert	Empty	Drop	45	InnoDB	utf8mb4_general_ci	48.0 KiB	-
ref_jenis_tayar		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	16.0 KiB	-
ref_kategori_filter		Browse	Structure	Search	Insert	Empty	Drop	3	InnoDB	utf8mb4_general_ci	32.0 KiB	-
ref_kategori_kenderaan		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_general_ci	16.0 KiB	-
ref_kategori_komponen		Browse	Structure	Search	Insert	Empty	Drop	56	InnoDB	utf8mb4_general_ci	64.0 KiB	-
ref_kategori_pmp		Browse	Structure	Search	Insert	Empty	Drop	10	InnoDB	utf8mb4_general_ci	16.0 KiB	-
ref_model_kenderaan_spanco		Browse	Structure	Search	Insert	Empty	Drop	9	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sys_audit_lifecycle_policy		Browse	Structure	Search	Insert	Empty	Drop	2	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
sys_dashboard_cache		Browse	Structure	Search	Insert	Empty	Drop	4	InnoDB	utf8mb4_general_ci	144.0 KiB	-
sys_dashboard_cache_archive		Browse	Structure	Search	Insert	Empty	Drop	0	InnoDB	utf8mb4_general_ci	48.0 KiB	-
sys_database_integrity_issues		Browse	Structure	Search	Insert	Empty	Drop	6	InnoDB	utf8mb4_general_ci	32.0 KiB	-
sys_database_relationship_contract		Browse	Structure	Search	Insert	Empty	Drop	105	InnoDB	utf8mb4_unicode_ci	128.0 KiB	-
sys_database_relationship_validation_snapshot		Browse	Structure	Search	Insert	Empty	Drop	212	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
sys_data_deduplication_map		Browse	Structure	Search	Insert	Empty	Drop	38,636	InnoDB	utf8mb4_unicode_ci	15.1 MiB	-
sys_master_data_cleanup_log		Browse	Structure	Search	Insert	Empty	Drop	757	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
sys_master_delete_guard_contract		Browse	Structure	Search	Insert	Empty	Drop	17	InnoDB	utf8mb4_unicode_ci	80.0 KiB	-
sys_migrations		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8mb4_unicode_ci	32.0 KiB	-
sys_migration_execution_log		Browse	Structure	Search	Insert	Empty	Drop	26	InnoDB	utf8mb4_unicode_ci	64.0 KiB	-
unit		Browse	Structure	Search	Insert	Empty	Drop	44	InnoDB	utf8mb4_general_ci	224.0 KiB	-
unit_branch		Browse	Structure	Search	Insert	Empty	Drop	49	InnoDB	utf8mb4_general_ci	160.0 KiB	-
unit_branch_archive		Browse	Structure	Search	Insert	Empty	Drop	61	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
unit_relationship		Browse	Structure	Search	Insert	Empty	Drop	55	InnoDB	utf8mb4_general_ci	144.0 KiB	-
unit_relationship_archive		Browse	Structure	Search	Insert	Empty	Drop	33,225	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
unit_section		Browse	Structure	Search	Insert	Empty	Drop	12	InnoDB	utf8mb4_general_ci	128.0 KiB	-
unit_section_archive		Browse	Structure	Search	Insert	Empty	Drop	62	InnoDB	utf8mb4_unicode_ci	48.0 KiB	-
vw_database_integrity_orphans		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_database_relationship_blocker_detail		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_database_relationship_blocker_queue		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_database_relationship_readiness		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_database_relationship_validation		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_database_relationship_validation_summary		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_fleet_component_framework_health		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_core_user_roles_user		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_fleet_repair		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_mh_answers_question		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_mh_document_reads		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_mh_read_pages		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_pakaian_item_component		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_pakaian_permohonan_item		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_pemandu_kemahiran		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_pemandu_lesen_awam		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_pemandu_spanco		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_unit_branch_unit		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_unit_relationship_child		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_unit_relationship_parent		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_integrity_orphan_unit_section_branch		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
vw_kenderaan_reference		Browse	Structure	Search	Insert	Edit	Drop	~0 This view has at least this number of rows. Please refer to documentation.	View	---	-	-
136 tables	Sum							~168,567	InnoDB	utf8mb4_unicode_ci	75.4 MiB	0 B

Check all

Data dictionary