System
A System (oee_systems) is a top-level organizational container in the OEE hierarchy. Systems group stations together into logical production units — for example, “Sterilization Line”, “Packaging Line”, or “Assembly Area”. The full hierarchy is:
System → Station → Machine/Person/Job
Systems belong to a Site and represent a named, logical grouping of stations that form stages of a production process.
Database Table: oee_systems
| Column | Type | Description |
|---|---|---|
id | UUID (PK) | Auto-generated |
site_id | UUID (FK) | References Site (oee_sites.id), cascades on delete |
asset_id | BIGINT (FK, nullable) | References assets.id, set null on delete |
code | VARCHAR(50) | Short identifier (e.g., “SYS-01”), unique per site |
name | VARCHAR(255) | Display name (e.g., “Sterilization Line”) |
description | TEXT | Optional description |
is_active | BOOLEAN | Active flag (default TRUE) |
created_at / updated_at | TIMESTAMPTZ | Audit timestamps |
Constraints: Unique on (site_id, code) — system codes are unique within a site.
Relationships
- Belongs to a Site (
oee_sites) viasite_id - Contains one or more stations (
ops_stations.system_idreferences this table) - Stations within a system form the stages of a process flow
- Optionally linked to an asset record via
asset_id
UI: Process Flow View
In the process flow view, a system’s stations are displayed as the stages of a process. Selecting a system shows its stations arranged in their connected sequence (defined by ops_station_connections), visualizing how jobs move through the production line.
Codebase Paths
- Table definition:
database/sql_scripts/tables/oee_systems.sql