EFACS Browser

Read-only structure and broad data-source overview from efacdb_full.

This screen must never write to EFACS. Hide/show preferences are stored locally in Monolith only; the EFACS data and structure are not changed.

Objects

438

Showing

203

Hidden by default/rule

228

Database

efacdb_full

Tables and Views

Schema-first broad sweep; open a table for columns/indexes/status counts.

Object	Category	Rows est.	Size	Updated	Notes
orderitems_20260303 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	646,563	550.42 MB	2026-02-27 15:18:27	-
zNWD_Snapshot_BOM BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	277,680	255.67 MB	2026-04-03 12:39:27	-
worksorders_20260303 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	253,260	160.94 MB	-	-
bom_snapshot_20260213133332 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	635,364	149.70 MB	-	-
bom_old BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	634,572	148.34 MB	-	-
bom_snapshot_20260213134340 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	640,190	148.34 MB	-	-
bom_live_backup_20260213133959 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	596,857	138.30 MB	-	-
bom_pre_bomserial_dedup_20260320_115252 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	634,863	108.16 MB	-	-
orders_20260303 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	214,494	107.84 MB	2026-02-27 15:03:53	-
bom_DELETEME_T BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	619,808	96.64 MB	-	-
bom_archive_20260213120103 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	643,939	96.64 MB	-	-
bom_archive_20260213120121 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	639,313	96.64 MB	-	-
bom_backup_20260507_112924 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	637,306	96.64 MB	2026-05-07 10:34:50	-
bom_pre_dedup_20260320_114818 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	637,359	96.64 MB	2026-03-20 11:20:28	-
allpartmaster_deleted_20260317_092156 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	68,820	72.64 MB	-	-
allpartmaster_deleted_20260317_092442 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	68,820	72.64 MB	-	-
stockbatches_before_replace_20260501_121643 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	125,388	71.75 MB	-	-
routingoperations_snapshot_20260213134340 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	96,693	55.66 MB	-	-
routingoperations_live_backup_20260213133959 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	96,588	34.61 MB	-	-
routingoperations_prededup_20260507_123357 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	97,920	34.08 MB	-	-
zNWD_Snapshot_AllPartMaster BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,508	32.25 MB	2026-04-03 12:39:19	-
routingoperations_backup_20260507_123109 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	96,764	28.56 MB	2026-05-07 09:13:12	-
routingoperations_archive_20260213120121 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	97,863	27.56 MB	-	-
zNWD_Snapshot_Routing BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	86,340	25.63 MB	2026-04-03 12:39:28	-
routingoperations_snapshot_20260213133332 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	96,842	23.56 MB	-	-
bommethods_snapshot_20260213133332 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	124,459	17.55 MB	-	-
zCMP_CostRollup_toMatchCRU_20260109 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	89,736	12.52 MB	-	-
bommethods_archive_20260213120103 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	126,211	11.52 MB	-	-
bommethods_archive_20260213120121 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	124,449	11.52 MB	-	-
bommethods_snapshot_20260213133834 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	129,813	11.52 MB	-	-
bommethods_snapshot_20260213134340 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	126,390	11.52 MB	-	-
zCMP_output_PricesForAPI_20260109 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,773	10.52 MB	-	-
zCMP_output_PricesForAPI_20260109_bkp_20260317_112202 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,043	10.52 MB	-	-
zCMP_output_PricesForAPI_20260109_bkp_20260318_110637 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,694	10.52 MB	-	-
zCMP_output_PricesForAPI_20260109_bkp_20260318_112147 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,598	10.52 MB	-	-
zCMP_output_PricesForAPI_20260109_bkp_20260319_183359 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,376	10.52 MB	2026-03-19 18:34:02	-
zCMP_output_PricesForAPI_20260109_bkp_20260319_183420 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	94,043	10.52 MB	2026-03-19 18:34:23	-
zCMP_output_PricesForAPI_20260109_bkp_20260319_184526 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,408	10.52 MB	2026-03-19 18:45:29	-
zCMP_output_PricesForAPI_20260109_bkp_20260319_185143 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,948	10.52 MB	2026-03-19 18:51:46	-
zCMP_output_PricesForAPI_20260109_bkp_20260319_185643 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,075	10.52 MB	2026-03-19 18:56:46	-
zCMP_output_PricesForAPI_bkp_20260317_110851 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,092	10.52 MB	-	-
zCMP_output_PricesForAPI_bkp_20260317_112202 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,156	10.52 MB	-	-
zCMP_output_PricesForAPI_bkp_20260318_110637 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,073	10.52 MB	-	-
zCMP_output_PricesForAPI_bkp_20260318_112147 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,073	10.52 MB	-	-
zCMP_output_PricesForAPI_bkp_20260319_183359 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,396	10.52 MB	2026-03-19 18:34:00	-
zCMP_output_PricesForAPI_bkp_20260319_183420 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,332	10.52 MB	2026-03-19 18:34:21	-
zCMP_output_PricesForAPI_bkp_20260319_184526 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,751	10.52 MB	2026-03-19 18:45:27	-
zCMP_output_PricesForAPI_bkp_20260319_185143 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,751	10.52 MB	2026-03-19 18:51:44	-
zCMP_output_PricesForAPI_bkp_20260319_185643 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,331	10.52 MB	2026-03-19 18:56:44	-
zCMP_output_PricesForAPI_shockguard_20260318_114609 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,751	10.52 MB	2026-03-18 11:46:11	-
zCMP_output_PricesForAPI_shockguard_bkp_20260319_183420_cfc1eb52 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,622	10.52 MB	2026-03-19 18:34:24	-
zCMP_output_PricesForAPI_shockguard_bkp_20260319_184526_7d223ea8 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,815	10.52 MB	2026-03-19 18:45:30	-
zCMP_output_PricesForAPI_shockguard_bkp_20260319_185143_9b2e70ba BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,267	10.52 MB	2026-03-19 18:51:47	-
zCMP_output_PricesForAPI_shockguard_bkp_20260319_185643_6f4446f7 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,073	10.52 MB	2026-03-19 18:56:47	-
zCRT_output_PricesForAPI_bkp_20260317_110851 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,381	10.52 MB	-	-
zCRT_output_PricesForAPI_bkp_20260317_112202 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,866	10.52 MB	-	-
zCRT_output_PricesForAPI_bkp_20260318_110637 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,768	10.52 MB	-	-
zCRT_output_PricesForAPI_bkp_20260318_112147 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,428	10.52 MB	-	-
zCRT_output_PricesForAPI_bkp_20260319_183420 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,460	10.52 MB	2026-03-19 18:34:25	-
zCRT_output_PricesForAPI_bkp_20260319_184526 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,203	10.52 MB	2026-03-19 18:45:30	-
zCRT_output_PricesForAPI_bkp_20260319_185143 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,590	10.52 MB	2026-03-19 18:51:48	-
zCRT_output_PricesForAPI_bkp_20260319_185643 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,073	10.52 MB	2026-03-19 18:56:48	-
zCRT_output_PricesForAPI_shockguard_20260318_114609 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,977	10.52 MB	2026-03-18 11:46:10	-
zCRT_output_PricesForAPI_shockguard_bkp_20260319_183420_17433e79 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	95,202	10.52 MB	2026-03-19 18:34:25	-
zCRT_output_PricesForAPI_shockguard_bkp_20260319_184526_5ebed402 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,428	10.52 MB	2026-03-19 18:45:32	-
zCRT_output_PricesForAPI_shockguard_bkp_20260319_185143_e33e17fc BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,944	10.52 MB	2026-03-19 18:51:49	-
zCRT_output_PricesForAPI_shockguard_bkp_20260319_185643_0a3b5598 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,299	10.52 MB	2026-03-19 18:56:49	-
zCMP_output_PricesForAPI_20251203_bkp_20260317_112202 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,202	9.52 MB	-	-
zCMP_output_PricesForAPI_20251203_bkp_20260318_110637 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,687	9.52 MB	-	-
zCMP_output_PricesForAPI_20251203_bkp_20260318_112147 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,597	9.52 MB	-	-
zCMP_output_PricesForAPI_20251203_bkp_20260319_183359 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	90,387	9.52 MB	2026-03-19 18:34:01	-
zCMP_output_PricesForAPI_20251203_bkp_20260319_183420 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,141	9.52 MB	2026-03-19 18:34:22	-
zCMP_output_PricesForAPI_20251203_bkp_20260319_184526 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,232	9.52 MB	2026-03-19 18:45:28	-
zCMP_output_PricesForAPI_20251203_bkp_20260319_185143 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91,748	9.52 MB	2026-03-19 18:51:45	-
zCMP_output_PricesForAPI_20251203_bkp_20260319_185643 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,655	9.52 MB	2026-03-19 18:56:45	-
zCMP_output_PricesForAPI_archive BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	92,406	8.52 MB	-	-
routingmethods_archive_20260213120121 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93,239	7.52 MB	-	-
stockbatches_deleted_20260317_092156 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	8,740	2.52 MB	-	-
routingoperations_badstate_20260507_123357 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3,414	1.80 MB	2026-05-07 12:31:10	-
stockbatches_deleted_20260319_151726 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	290	0.25 MB	2026-03-19 15:17:28	-
shipmentitems_composite_deleted_20260420_071826 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	69	0.22 MB	-	-
stockbatches_deleted_20260420_071759 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	97	0.22 MB	-	-
stockbatches_deleted_20260430_065829 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	94	0.22 MB	-	-
stockbatches_deleted_20260604_144159 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	109	0.22 MB	-	-
stockbatches_deleted_20260325_093345 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	91	0.20 MB	-	-
stockbatches_deleted_20260401_065116 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	95	0.20 MB	-	-
stockbatches_deleted_20260427_092004 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	89	0.20 MB	-	-
stockbatches_deleted_20260507_074125 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	82	0.20 MB	-	-
stockbatches_deleted_20260519_071523 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	66	0.20 MB	-	-
stockbatches_deleted_20260601_155017 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	93	0.20 MB	2026-06-01 15:51:20	-
shipmentitems_composite_deleted_20260326_074807 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	7	0.19 MB	-	-
shipmentitems_composite_deleted_20260331_063842 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.19 MB	-	-
shipmentitems_composite_deleted_20260415_100818 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.19 MB	-	-
shipmentitems_composite_deleted_20260416_112734 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	42	0.19 MB	-	-
shipmentitems_composite_deleted_20260421_062207 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	49	0.19 MB	-	-
shipmentitems_composite_deleted_20260422_064543 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	16	0.19 MB	-	-
shipmentitems_composite_deleted_20260423_064544 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.19 MB	-	-
shipmentitems_composite_deleted_20260512_151634 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.19 MB	-	-
shipmentitems_composite_deleted_20260515_124017 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.19 MB	-	-
shipmentitems_composite_deleted_20260529_073955 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	19	0.19 MB	-	-
stockbatches_deleted_20260320_112028 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	43	0.17 MB	2026-03-20 11:21:04	-
stockbatches_deleted_20260323_095134 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	52	0.17 MB	-	-
stockbatches_deleted_20260326_074738 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	38	0.17 MB	-	-
stockbatches_deleted_20260327_072141 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	30	0.17 MB	-	-
stockbatches_deleted_20260330_075526 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	66	0.17 MB	-	-
stockbatches_deleted_20260331_063807 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	35	0.17 MB	-	-
stockbatches_deleted_20260402_064826 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	32	0.17 MB	2026-04-02 06:48:45	-
stockbatches_deleted_20260408_063644 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	47	0.17 MB	-	-
stockbatches_deleted_20260409_111636 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	36	0.17 MB	-	-
stockbatches_deleted_20260410_152148 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	32	0.17 MB	-	-
stockbatches_deleted_20260413_135436 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	29	0.17 MB	-	-
stockbatches_deleted_20260415_100745 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	32	0.17 MB	-	-
stockbatches_deleted_20260416_112704 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	32	0.17 MB	-	-
stockbatches_deleted_20260421_062136 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	18	0.17 MB	-	-
stockbatches_deleted_20260422_064509 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	26	0.17 MB	-	-
stockbatches_deleted_20260423_064511 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	29	0.17 MB	-	-
stockbatches_deleted_20260424_062245 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	54	0.17 MB	-	-
stockbatches_deleted_20260428_063351 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	12	0.17 MB	-	-
stockbatches_deleted_20260429_063440 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	57	0.17 MB	-	-
stockbatches_deleted_20260501_061852 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	20	0.17 MB	-	-
stockbatches_deleted_20260501_110513 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.17 MB	-	-
stockbatches_deleted_20260505_131214 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	10	0.17 MB	-	-
stockbatches_deleted_20260506_062704 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	10	0.17 MB	-	-
stockbatches_deleted_20260508_062245 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	5	0.17 MB	-	-
stockbatches_deleted_20260512_151528 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	18	0.17 MB	-	-
stockbatches_deleted_20260515_123910 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	10	0.17 MB	-	-
stockbatches_deleted_20260518_072354 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	5	0.17 MB	-	-
stockbatches_deleted_20260520_062001 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	48	0.17 MB	-	-
stockbatches_deleted_20260521_062120 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	16	0.17 MB	-	-
stockbatches_deleted_20260522_063053 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.17 MB	-	-
stockbatches_deleted_20260526_064606 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	45	0.17 MB	-	-
stockbatches_deleted_20260527_062730 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	54	0.17 MB	-	-
stockbatches_deleted_20260528_091647 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	49	0.17 MB	2026-05-28 09:17:08	-
orderitems_composite_deleted_20260413_135459 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	223	0.14 MB	-	-
staff-availability-snapshot-days BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	52	0.14 MB	-	-
orderitems_composite_deleted_20260323_102239 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	113	0.09 MB	-	-
orderitems_composite_deleted_20260421_062155 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	129	0.09 MB	-	-
orderitems_composite_deleted_20260408_063709 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	58	0.06 MB	-	-
allpartmaster_deleted_20260512_151519 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	21	0.05 MB	-	-
orderitems_composite_deleted_20260420_071817 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	41	0.05 MB	-	-
orderitems_composite_deleted_20260428_063410 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	39	0.05 MB	-	-
orderitems_composite_deleted_20260501_061915 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	45	0.05 MB	-	-
orderitems_composite_deleted_20260505_131234 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	43	0.05 MB	-	-
zNWD_Snapshot BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.05 MB	2026-04-03 12:39:28	-
bom_deleted_20260521_062114 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	-	-
invoiceitems_deleted_20260319_145807 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.03 MB	-	-
invoiceitems_deleted_20260319_151535 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.03 MB	-	-
invoiceitems_deleted_20260428_063407 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.03 MB	-	-
invoiceitems_deleted_20260501_061913 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	-	-
invoiceitems_deleted_20260604_144237 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	-	-
staff-availability-snapshots BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	2026-05-09 21:56:10	-
stockedparts_deleted_20260508_062248 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	-	-
zBIPmodel3_core_snapshots BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.03 MB	2026-06-03 08:43:27	-
allpartmaster_deleted_20260317_104740 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	8	0.02 MB	-	-
allpartmaster_deleted_20260522_063045 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bom_deleted_20260424_062216 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	100	0.02 MB	-	-
bom_deleted_20260507_074112 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	12	0.02 MB	-	-
bommethods_snapshot_20260213133536 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133551 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133603 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133617 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133635 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133736 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
bommethods_snapshot_20260213133751 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
orderitems_composite_deleted_20260317_092156 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
orderitems_composite_deleted_20260325_093408 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	6	0.02 MB	-	-
orderitems_composite_deleted_20260326_074759 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	4	0.02 MB	-	-
orderitems_composite_deleted_20260327_072202 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	10	0.02 MB	-	-
orderitems_composite_deleted_20260330_075546 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	7	0.02 MB	-	-
orderitems_composite_deleted_20260409_111701 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	16	0.02 MB	-	-
orderitems_composite_deleted_20260410_152212 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	20	0.02 MB	-	-
orderitems_composite_deleted_20260415_100809 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	24	0.02 MB	-	-
orderitems_composite_deleted_20260416_112723 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	15	0.02 MB	-	-
orderitems_composite_deleted_20260422_064529 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	15	0.02 MB	-	-
orderitems_composite_deleted_20260424_062304 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	18	0.02 MB	-	-
orderitems_composite_deleted_20260427_092023 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	16	0.02 MB	-	-
orderitems_composite_deleted_20260429_063458 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	6	0.02 MB	-	-
orderitems_composite_deleted_20260507_074213 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	17	0.02 MB	-	-
orderitems_composite_deleted_20260520_062052 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.02 MB	2026-05-20 06:21:05	-
orderitems_composite_deleted_20260521_062210 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
orderitems_composite_deleted_20260529_073943 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
proformas_backup_20260508_135039 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	30	0.02 MB	-	-
traders_deleted_20260317_092156 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	36	0.02 MB	-	-
worksorders_composite_deleted_20260317_104740 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	5	0.02 MB	-	-
worksorders_composite_deleted_20260319_182809 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	6	0.02 MB	2026-03-19 18:28:10	-
worksorders_composite_deleted_20260323_102315 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260325_093405 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.02 MB	-	-
worksorders_composite_deleted_20260327_072159 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260330_075543 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.02 MB	-	-
worksorders_composite_deleted_20260401_065136 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.02 MB	-	-
worksorders_composite_deleted_20260402_064846 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.02 MB	2026-04-02 06:49:02	-
worksorders_composite_deleted_20260408_063704 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260416_112718 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	2	0.02 MB	-	-
worksorders_composite_deleted_20260421_062150 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.02 MB	-	-
worksorders_composite_deleted_20260429_063453 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260430_065847 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260501_061910 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260505_131230 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260508_062308 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	3	0.02 MB	-	-
worksorders_composite_deleted_20260512_151551 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260518_072415 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260521_062141 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	-	-
worksorders_composite_deleted_20260528_091708 BASE TABLE · InnoDB	Backups, snapshots and deleted-row stores	0	0.02 MB	2026-05-28 09:17:50	-

Category Counts

Category	Objects	MB
Live EFACS mirror	32	1716.7
Live/compatibility views	12	0.0
Useful derived outputs	6	291.7
Custom/model/helper tables	158	3617.5
Source/staging extracts	12	13.8
Backups, snapshots and deleted-row stores	203	3293.2
App/admin miscellany	13	34.0
Unclassified	2	191.3

Useful Join Map

traders.id + traders.tradertype -> orders/invoices/shipments traderid + tradertype

Customers and suppliers both live in traders. C = customer, S = supplier.

traders -> tradersaddresses

Addresses are keyed by traderid, tradertype and addressid with invoice/delivery/main flags.

traderscontacts -> contactcommunications

Email and phone values are stored as communication method rows, not fixed columns.

allpartmaster.partnum -> bom/bom_viewtouse bomparent and bomchild

Part master to BOM parent/child relationships.

allpartmaster.partnum -> routingoperations.partid

Part master to routing operations.

orders_composite.id + ordertype -> orderitems_composite.orderid + ordertype

Order headers to order lines.

invoices.id + invoicetype -> invoiceitems.invoiceid + invoicetype

Invoice headers to invoice lines.

shipments.id + shipmenttype -> shipmentitems.shipmentid + shipmenttype

Shipment headers to shipment lines.