Robot Work Cell Production Schema

erDiagram
  WORK_CELL ||--|{ ROBOT : contains
  PROGRAM ||--|{ PROGRAM_VERSION : versions
  ROBOT ||--o{ JOB : runs
  PROGRAM_VERSION ||--o{ JOB : "used by"
  JOB ||--o{ CYCLE : records
  ROBOT ||--o{ FAULT : raises
  ROBOT ||--o{ MAINTENANCE : receives
  WORK_CELL {
    int id PK
    string name
    string line
  }
  ROBOT {
    int id PK
    int cell_id FK
    string model
    string serial_no
  }
  PROGRAM {
    int id PK
    string name
  }
  PROGRAM_VERSION {
    int id PK
    int program_id FK
    string version
    date released_on
  }
  JOB {
    int id PK
    int robot_id FK
    int program_version_id FK
    string part_no
  }
  CYCLE {
    int id PK
    int job_id FK
    datetime started_at
    decimal seconds
    string result
  }
  FAULT {
    int id PK
    int robot_id FK
    string error_code
    datetime at
  }
  MAINTENANCE {
    int id PK
    int robot_id FK
    string type
    date done_on
  }