Source map
Where the data actually lives
4 source systems behind Caldera Logistics, holding 8 tables, with 2 reporting tools built on top.
0 of 8
Zero enforced foreign keys across the entire estate.
All 8 cross-table links —
are by naming convention only. Nothing in the databases guarantees a row points at a real parent.
1 already have orphaned rows.
Every join in every report is a handshake, not a contract.
Operational systems
systems of record · these hold the 8 tablesTMS
Transportation mgmt — orders, shipments, scans
shipment_events10,613 shipments5,416 orders5,000 exceptions157 carriers12
Billing / ERP
Invoices, credits, AR
invoices4,695
WMS
Warehouse throughput
facilities8
CRM
Customer master
customers60
Reporting & BI tools
where the numbers get recomputed · 5 reports across 2 toolsPower BI
Excel