[M-05]

MACHINE REPOSITORY

Centralized heavy equipment registry — full maintenance history, GPS-linked positions, wear gradient visualization, and optional 3D model viewer.

// OPS_COMPANION FIELD MANUAL

The Machine Repository is the authoritative record of every asset in your fleet. It is the relational hub that all other modules reference: work orders are assigned to machines, GPS events are attributed to machines, parts are consumed by machines, inspections are performed on machines, and quotes are issued for machine service.

Every machine record is a living document — updated continuously by operational events from the field. The repository is not a static inventory form; it is an accumulating record of the machine's operational life.

Machine Record Structure

IDENTITY

Make, model, year, serial number, internal asset ID, client link, and purchase date

LOCATION

Last known GPS position, current geofence zone assignment, site designation

MECHANICAL STATE

Engine hours, odometer (km), current wear gradient level, last service date

SERVICE HISTORY

Complete chronological log of all work orders, inspections, and parts replacements

TELEMETRY

Live and historical sensor readings: pressure, temperature, fuel, battery, RPM

DOCUMENTS

Linked inspection reports, delivery confirmations, compliance certificates, photos

3D MODEL

Optional: interactive 3D part explosion view for parts identification and ordering

Unified Architecture (Jour 01)

The Machine Repository is the practical expression of the Jour 01 architectural breakthrough: a single SQL query can extract the complete operational and financial history of any asset. No intermediate APIs, no JOIN limitations — the 54-table relational model is designed so that every relevant fact about a machine is reachable from the assets table in a single traversal.

-- Everything about one machine in one query

SELECT

a.*,

json_agg(DISTINCT wo.*) AS work_orders,

json_agg(DISTINCT ge.* ORDER BY ge.recorded_at DESC) AS gps_trail,

json_agg(DISTINCT ins.*) AS inspections,

json_agg(DISTINCT pc.*) AS parts_consumed,

json_agg(DISTINCT te.*) AS telemetry_latest

FROM assets a

LEFT JOIN work_orders wo ON wo.asset_id = a.id

LEFT JOIN gps_events ge ON ge.asset_id = a.id

LEFT JOIN inspections ins ON ins.asset_id = a.id

LEFT JOIN parts_consumed pc ON pc.asset_id = a.id

LEFT JOIN telemetry_events te ON te.asset_id = a.id

WHERE a.id = $1

GROUP BY a.id;

3D Model Viewer (Add-On)

The optional 3D Viewer add-on renders an interactive exploded-view 3D model of the machine. Parts are selectable — clicking a part shows its inventory stock level, part number, and a direct-order button. This is used by the Parts role for identification and by Sales for client demonstrations.

PART EXPLOSION VIEW

Full interactive 3D disassembly of any machine model

REAL-TIME STOCK

Inventory level shown on 3D part hover — pulled live from warehouse data

DIRECT ORDER

Parts ordered from within the 3D interface — creates purchase order automatically

SALES DEMO MODE

Client-facing mode with branding and simplified navigation

ADD-ON PRICING

The 3D Viewer is available as a paid add-on. It is available on all plans. Contact support for pricing.

Wear Gradient & Predictive State

Each machine's mechanical state is computed continuously from its engine hours, odometer, last service event, and telemetric sensor readings. The wear gradient is not a manual field — it is a derived value, recalculated on every relevant event. It feeds directly into the 3D Map pin color (Jour 09) and the Tech Support Phantom Fault Detector (Jour 14).

When a machine's wear state crosses a threshold, the system generates a preventive maintenance recommendation in the work order queue — without waiting for the technician to notice. This is the core of OPS Companion's shift from reactive to predictive maintenance.