utcsheffield/lean_manufacturing

Raspberry Pi / & web browser based game, simulating Lean Manufacture & and databases in manufacturing.

lean_manufacturing

Raspberry Pi / & web browser based game, simulating Lean Manufacture & and the use of databases in manufacturing

lean_manufacturing's Issues

Define Production Line buttons

My suggestion -

• Task Finished
• Problem on Section
• Manager Arrived
• Problem Cleared

Is that about right? Are they shown conditionally (Problem Cleared only appears after the manager arrives).

Test socket.io

Looks like it would be ideal but need to try it.

Manfacturing database - Sqlite

Web server

Provides

• Process Buttons on Web page for each stage.
• API for buttons to Database
  • process finished
  • Problem encountered
  • Manager arrived
  • Problem cleared
• Plays alarm noises when
  • time up
  • Problem encountered
  • Problem cleared
• QA checks entered into DB
• Statistical Process Control
• Reports

Table Design

Product

• Product ID
• Product Name
• QA Target Type
• QA Target Value

Production Line

• Line ID
• Line Name

Station

• Station ID
• Line ID
• Station Name

Event Types

• Event Type ID
• Event Name

Event Alarms

• Event Alarm ID
• Event Type ID
• Line ID
• File Name

Production Run

• Run ID
• Line ID
• Start Time
• Running
• Production Target

Events

• Event ID
• Event Type ID
• Run ID
• Station ID
• Time
• QA Value ?????

Build tests for messages and state changes