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
linode_data_transfer_log BASE TABLE · InnoDB	App/admin miscellany	580,610	33.56 MB	2026-06-08 13:17:53	-
receiving_sessions BASE TABLE · InnoDB	App/admin miscellany	14	0.06 MB	-	-
staff-availability-planning-resources BASE TABLE · InnoDB	App/admin miscellany	1	0.06 MB	-	-
efacs_proc_runs BASE TABLE · InnoDB	App/admin miscellany	2	0.05 MB	2026-03-31 19:21:19	-
staff-availability-day-adjustments BASE TABLE · InnoDB	App/admin miscellany	0	0.05 MB	-	-
staff-availability-skill-events BASE TABLE · InnoDB	App/admin miscellany	0	0.05 MB	-	-
staff-availability-target-commands BASE TABLE · InnoDB	App/admin miscellany	0	0.05 MB	-	-
staff-availability-training-event-participants BASE TABLE · InnoDB	App/admin miscellany	2	0.05 MB	2026-05-09 21:57:25	-
staff-availability-training-events BASE TABLE · InnoDB	App/admin miscellany	0	0.03 MB	2026-05-09 21:57:25	-
__samples BASE TABLE · InnoDB	App/admin miscellany	0	0.02 MB	-	-
active_sessions BASE TABLE · InnoDB	App/admin miscellany	2	0.02 MB	-	-
receiving_completions BASE TABLE · InnoDB	App/admin miscellany	2	0.02 MB	-	-
staff-availability-assumptions BASE TABLE · InnoDB	App/admin miscellany	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.