This system connects shop-floor events to a structured MySQL database, providing inventory visibility and lot-level traceability through Ignition dashboards.
Inventory Management and Lot Tracking System
Ignition + MySQL system for inventory visibility, lot tracking, and production traceability.
Key Reminders
- Explain the data model that ties inventory to lots and process steps.
- Discuss how operators interact with the system on the floor.
- Highlight data integrity checks and audit trails.
Technologies
System Overview
Built an inventory and lot tracking workflow to connect production events with serialized material records for traceability.
Data Architecture
Ignition interfaces capture production events and write to a MySQL database, enabling queries for lot history and compliance reporting.
sql code
Code example forthcoming
Lot genealogy and traceability query.
HMI and Workflows
Operator screens support inventory updates, batch closes, and exception handling with minimal disruption to production flow.
Testing and Validation
Validated data integrity, transaction timing, and audit trails under realistic batch scenarios.
Demo and Next Steps
Future work includes automated alerts for inventory thresholds and real-time performance dashboards.