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
source_shipmentitems BASE TABLE · InnoDB	Source/staging extracts	23,587	8.55 MB	-	-
source_allpartmaster BASE TABLE · InnoDB	Source/staging extracts	1,111	2.52 MB	-	-
source_routingoperations BASE TABLE · InnoDB	Source/staging extracts	1,316	1.52 MB	-	-
source_stockbatches BASE TABLE · InnoDB	Source/staging extracts	1,241	0.45 MB	-	-
source_bommethods BASE TABLE · InnoDB	Source/staging extracts	3,138	0.42 MB	-	-
source_routingmethods BASE TABLE · InnoDB	Source/staging extracts	1,370	0.17 MB	-	-
source_traders BASE TABLE · InnoDB	Source/staging extracts	131	0.09 MB	-	-
source_bom BASE TABLE · InnoDB	Source/staging extracts	0	0.02 MB	-	-
source_orderitems BASE TABLE · InnoDB	Source/staging extracts	0	0.02 MB	-	-
source_orders BASE TABLE · InnoDB	Source/staging extracts	0	0.02 MB	-	-
source_shipments BASE TABLE · InnoDB	Source/staging extracts	0	0.02 MB	-	-
source_worksorders BASE TABLE · InnoDB	Source/staging extracts	0	0.02 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.