materiel.uk / 127.0.0.1 / materiel / fleet_component_retirement_archive

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 :

Browse mode

Customise browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (12103 total, Query took 0.0637 seconds.) [archived_at: 2026-07-18 17:36:12... - 2026-07-18 17:36:12...]

SELECT * FROM `fleet_component_retirement_archive` ORDER BY `archived_at` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	archive_key	retirement_key	record_type	source_table	source_pk	kenderaan_id	canonical_component_id	canonical_component_ids_json	record_payload_json	payload_sha256	archived_at 1
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8192	8192	8d5ca552c8e0f7ebfe4b0d8ee8184340c5acd400ca77711f58...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	3	6	NULL	[766]	{"ID": 3, "kenderaan_id": 6, "kategori_bateri": nu...	20475119ecde8b16890d6069753f33d6b4fcae399fbcffbf35...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8448	8448	81153f46af0a3dd9239b025e0d004e2896eeecdfde49ca586d...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	336	616	NULL	[3735]	{"ID": 336, "kenderaan_id": 616, "kategori_bateri"...	22d547d0092f67069a6aa2dbd94e5cd5ef61eee627d82bcb84...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8704	8704	b595743b83e837fccb964e2825daf95972b1a3c9b424139c34...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	674	919	NULL	[8475]	{"ID": 674, "kenderaan_id": 919, "kategori_bateri"...	ae92573cc0835f0602e2c36450689e842fff3139fdabfc2999...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 9216	9216	6e861381d9fc5e3f370b55af26fa41967ba3a78d19fccb7e74...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_wiper	5	7	NULL	[1022,1277,1532]	{"ID": 5, "kenderaan_id": 7, "saiz_front_left": "2...	921505304be4b50cf522b64e4199e5179fffd95de01b0b0241...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 9472	9472	5a44effb29b7c3dc88fbb7c9b5df1e45663f629ad77f0e7d71...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_wiper	311	598	NULL	[3501,3502,3503]	{"ID": 311, "kenderaan_id": 598, "saiz_front_left"...	57bf744b7723d471035f10fb42d8208acc131b3af86f7b3972...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 9728	9728	c7c76581087a977ec7a82df7129fb8acd9f122d557bcae942a...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_wiper	575	929	NULL	[8759,8760]	{"ID": 575, "kenderaan_id": 929, "saiz_front_left"...	d7fd092f13fe71282a211bc017d4b915da3fd1ddd66c75ff84...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 10240	10240	4ac37fb0058e15808bb8a9fde1d303cbf90b52557da123380e...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_kanopi	14	58	NULL	[1660]	{"ID": 14, "kenderaan_id": 58, "Jenis": "KELABU", ...	6d8adfc8810241547114ee7593379417ec5071e4e2bf3bc00e...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 10496	10496	1e78a75d05c59230eebd695771a263e0bc327d14f89b246f80...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_filter	327	96	NULL	[8920]	{"id": 327, "kenderaan_id": 96, "kategori_filter":...	c23b89d9f76578661e49daf1fc84f1a736967892e17855a1c8...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 10752	10752	2f2a6d5a367a439d760a6045f39c5eaee4e1a90fe0d6c9fe7e...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_filter	739	199	NULL	[9176]	{"id": 739, "kenderaan_id": 199, "kategori_filter"...	25cf6caa53083f7bb1ffd39f16548a3161006b9c2eb2d98d88...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 11008	11008	1b3ff496eb90b0fe1bfffc7b75a0588caae548145864a5dce6...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_filter	1119	559	NULL	[2957]	{"id": 1119, "kenderaan_id": 559, "kategori_filter...	b19e443d665c467625dd93354a797243b1599e343dc112fd4e...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 11264	11264	49a575b5f9738c7f8be29ef37b3427c5abc6d2386fb6839052...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_filter	1446	695	NULL	[4913]	{"id": 1446, "kenderaan_id": 695, "kategori_filter...	8f4ed4c05b91ddb987365057c2b5d77338cbf52ef26cea1f1e...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 11520	11520	674a32e0142640b5eb720de6d5e323be4d33d5a624f6119407...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_filter	1764	830	NULL	[7059]	{"id": 1764, "kenderaan_id": 830, "kategori_filter...	5311f4e3dba810f79cd2cc9521766c2d80e1b5d8702ee1e8ba...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 12544	12544	4a21c98429fe4b036a14722ff9438bfe0cb16130beefd0bbb0...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_belting	179	28	NULL	[9435]	{"ID": 179, "kenderaan_id": 28, "kategori_belt": n...	c98aca4741eaf1f5fb94fb3d9faacf4fdc66233e68b2926817...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 12800	12800	8d006e4a758b9140a0f9b3629b260e416379b03da47366fe04...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_belting	589	534	NULL	[2643]	{"ID": 589, "kenderaan_id": 534, "kategori_belt": ...	97dc6d2d049a337dad5069906fb3a1a1b853b2efcadc4a48f5...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 13056	13056	c679c9c6fcb646fb4da59b54e711491659708f326193fcbac4...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_belting	906	790	NULL	[6145]	{"ID": 906, "kenderaan_id": 790, "kategori_belt": ...	1760620b059237ddf26198f00b7e069eb2871279faf72f1abc...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 13568	13568	e17f20211e334e19d4455a80709684e8c1a7ac62538f92b7c1...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	344	72	NULL	[9691]	{"ID": 344, "kenderaan_id": 72, "kategori_pmp": "O...	7f948894ec869dfb16e6865000aafc9d31a72d79cdbd48adcc...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 13824	13824	5ac31bee22eec1f705eff857b720fd941bdb2aad36aaa64d2e...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	743	193	NULL	[9947]	{"ID": 743, "kenderaan_id": 193, "kategori_pmp": "...	a0ab1df6806af5142132fc662eed53e7e86179744ddf86a232...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 14080	14080	6f878ad77bb901151c49d5b723251a3cd66a632ee75614adea...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	1157	434	NULL	[2503]	{"ID": 1157, "kenderaan_id": 434, "kategori_pmp": ...	56d265523ab6d9765a72297d8678f603ff71c2c8de9a243a84...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 14336	14336	d7e5728ea21186f86937448484481a859fe765bbc200cbb517...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	1471	630	NULL	[3937]	{"ID": 1471, "kenderaan_id": 630, "kategori_pmp": ...	5a33303d9a919a3853e327b56e645f2791e8535fc396aaab51...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 14592	14592	47866f4790f8a34f5a9a68d893d195bab08ccf54c711dd418f...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	1815	753	NULL	[5523]	{"ID": 1815, "kenderaan_id": 753, "kategori_pmp": ...	d738a0eac11a4d7cda7d3c09ff7a42d72675171f08448b09af...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 14848	14848	c1f12dc82ec4f50d38a2448806579e300824a2a4dc7869a4c3...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	2178	845	NULL	[7293]	{"ID": 2178, "kenderaan_id": 845, "kategori_pmp": ...	afd307ff6cd47719d0e513ac5a4eded6223adb79246a223ec9...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 15104	15104	6c1c57cfc1671e9e91d0db42052e965533ff78f4f955e27a3d...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_pmp	2500	933	NULL	[8850]	{"ID": 2500, "kenderaan_id": 933, "kategori_pmp": ...	207aae6ca27d9f1a6da442d8b7cdc27a988ae6658ac1e999c2...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8193	8193	72e9a67393a4c8bfd72ee40705efb26dd31155c01fb78d4fb0...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	4	7	NULL	[767]	{"ID": 4, "kenderaan_id": 7, "kategori_bateri": nu...	e8e472a00d461bea4fdfd44fb80e1a298e627391195fecd25a...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8449	8449	b435d423c2fd32659c887f5caeba73136e2b6d1cc6a4ecd0dc...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	337	617	NULL	[3749]	{"ID": 337, "kenderaan_id": 617, "kategori_bateri"...	fadf086b4fbe8e8dda5c016735124d542aa82b1960a2895b9f...	2026-07-18 17:36:12
Edit	Copy	Delete DELETE FROM fleet_component_retirement_archive WHERE `fleet_component_retirement_archive`.`id` = 8705	8705	8f2c4d2c148d56bbfaddbcf6731278b44520d5fe4fb558b91f...	2026_07_17_001_component_framework_full_cutover	LEGACY_ROW	fleet_component_bateri	675	920	NULL	[8492]	{"ID": 675, "kenderaan_id": 920, "kategori_bateri"...	a578d01785604561825f4b4e0de599db5dda36b98421b75047...	2026-07-18 17:36:12

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view