CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Robotics

🤖 Robotics · Database ERD

Robot Work Cell Production Schema

Tables for tracking a collaborative robot (cobot) work cell: robots, programs, jobs, cycles, faults and maintenance.

More Robotics templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Each job runs a specific program version
  • Every cycle records time and result
  • Faults and maintenance are linked to the robot

Prompt used

Robot work cell database: robots belong to work cells; programs have versions; production jobs run a program version on a robot for a part number; each cycle records start, duration and pass/fail; faults record error codes; maintenance records preventive and corrective work.

Mermaid code
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
  }

Inside this diagram

An entity relationship diagram with 8 tables, 30 columns and 7 relationships.

Tables and their columns

  • WORK_CELL: id (PK), name, line
  • ROBOT: id (PK), cell_id (FK), model, serial_no
  • PROGRAM: id (PK), name
  • PROGRAM_VERSION: id (PK), program_id (FK), version, released_on
  • JOB: id (PK), robot_id (FK), program_version_id (FK), part_no
  • CYCLE: id (PK), job_id (FK), started_at, seconds, result
  • FAULT: id (PK), robot_id (FK), error_code, at
  • MAINTENANCE: id (PK), robot_id (FK), type, done_on

Relationships

  • WORK_CELL contains ROBOT: each WORK_CELL has one or more ROBOT, each ROBOT belongs to exactly one WORK_CELL
  • PROGRAM versions PROGRAM_VERSION: each PROGRAM has one or more PROGRAM_VERSION, each PROGRAM_VERSION belongs to exactly one PROGRAM
  • ROBOT runs JOB: each ROBOT has zero or more JOB, each JOB belongs to exactly one ROBOT
  • PROGRAM_VERSION used by JOB: each PROGRAM_VERSION has zero or more JOB, each JOB belongs to exactly one PROGRAM_VERSION
  • JOB records CYCLE: each JOB has zero or more CYCLE, each CYCLE belongs to exactly one JOB
  • ROBOT raises FAULT: each ROBOT has zero or more FAULT, each FAULT belongs to exactly one ROBOT
  • ROBOT receives MAINTENANCE: each ROBOT has zero or more MAINTENANCE, each MAINTENANCE belongs to exactly one ROBOT

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

C4 ArchitectureProRobotics

Warehouse Robot Fleet Management

The software that runs a fleet of warehouse robots: order intake from the WMS, task allocation, traffic control, charging and the operator dashboard.

State MachineRobotics

Robot Task State Machine

The states of an autonomous mobile robot doing pick tasks: idle, navigating, picking, delivering, charging, and recovering from faults and blocked paths.

FlowchartRobotics

ROS 2 Mobile Robot Architecture

The software nodes inside a ROS 2 autonomous mobile robot: sensors, localisation, mapping, planning, control and the fleet connection.

SequenceRobotics

Robot Pick-and-Place Sequence

How a robot arm picks items from a bin with vision guidance: detection, grasp planning, motion, placement and error handling.

NetworkRobotics

Robotic Work Cell Network

The network inside a robotic work cell: robot controllers, PLC, safety systems, vision and the connection to the plant network.

GanttRobotics

Warehouse Robot Rollout Plan

A project plan for introducing autonomous robots into a warehouse: site survey, mapping, integration, pilot, training and scale-up.