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

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
zCRU_BOM_Flat BASE TABLE · InnoDB	Useful derived outputs	2,240,169	221.30 MB	2026-04-03 13:51:11	Derived flattened BOM for fast where-used/explosion queries.
zCRT_retained_FinalApiPriceSnapshot BASE TABLE · InnoDB	Useful derived outputs	92,932	21.66 MB	2026-04-03 14:55:20	-
zCRU_CostRollup BASE TABLE · InnoDB	Useful derived outputs	92,620	20.06 MB	2026-04-03 13:52:14	Derived rolled-up part costing output. Not raw EFACS source data.
zefacs_part_family_flags BASE TABLE · InnoDB	Useful derived outputs	67,916	18.06 MB	2026-03-25 16:30:33	-
zCMP_output_PricesForAPI BASE TABLE · InnoDB	Useful derived outputs	93,146	10.52 MB	2026-04-03 14:26:47	Derived price output used by pricing tools. Not raw EFACS source data.
zCMP_workings_RecentNettpriceFromEfacs_saved BASE TABLE · InnoDB	Useful derived outputs	1,697	0.11 MB	-	-

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

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.