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	Visibility
bom_incSK BASE TABLE · InnoDB	Unclassified	656,347	99.64 MB	-	-
allpartmaster_incSK BASE TABLE · InnoDB	Unclassified	87,756	91.66 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.