MES
256
Source rows at Day-0
32
Populated tables
44
Exported tables
Collections
Machines1
Shop-floor machines and the ERP asset each names.
Work Orders3
Production execution against an ERP production order.
Operations6
Operations within work orders. Execution events appear inside each.
Material Consumption4
Material consumed by operations.
Work Centers2
The production work centers machines and operations belong to.
Quality Inspections1
In-process inspections of production lots, with each check's recorded result.
Quality Holds3
Work orders held on the shop floor.
Downtime4
Machine downtime, recorded manually or raised from IoT.
Execution Events11
Operation starts, pauses and completions.
Representative records
What these records become
Production Execution ×3 · Asset ×1
Canonical records projected from MES source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 44 exported tables in mes_src
- approval0
- audit_event75
- batch_parameter_record0
- dispatch_queue6
- document_sequence2
- downtime_event4
- downtime_reason5
- execution_event11
- idempotency_key74
- item_ref2
- line_performance0
- lot2
- lot_genealogy0
- machine_ref1
- machine_state_event2
- material_consumption4
- material_issue1
- material_requirement0
- material_return0
- nonconformance0
- oee_snapshot0
- operation_ref2
- operator_ref1
- outbox_event16
- plant_ref1
- production_count2
- production_line1
- quality_check_def3
- quality_hold3
- quality_inspection1
- quality_result2
- rework_event0
- role6
- routing_ref1
- scrap_event2
- serial_trace0
- shift_definition3
- shift_summary0
- user_account6
- user_role6
- work_center2
- work_instruction0
- work_order3
- work_order_operation6