Production Line

Overview

Manufacturing execution system (MES) schema for discrete manufacturing. Models the complete production lifecycle from raw material procurement through quality inspection to finished goods inventory.

Key Design Decisions

• BOM Hierarchy: Multi-level bill of materials with quantity and unit tracking
• Work Order Stages: Stage-gate production workflow with completion tracking
• Quality Gates: Inspection criteria per stage with pass/fail/rework outcomes
• Inventory Transactions: Full material movement audit trail (receive, issue, transfer, scrap)

Tables

12-15 tables covering products, product categories, bill of materials, BOM items, work orders, production stages, stage completions, quality inspections, inspection criteria, raw materials, inventory transactions, suppliers, and defect reports.