Station Product Standards
Station Product Standards are per-product production expectations for a specific Station. Stations are represented by oee_equipment rows with node_type = 'station', so station standards use the same oee_product_equipment_config table as equipment standards.
Database Table: oee_product_equipment_config
| Column | Type | Description |
|---|---|---|
id | UUID (PK) | Auto-generated |
product_id | UUID (FK) | References Product |
equipment_id | UUID (FK) | References the station row in oee_equipment |
standard_hours | NUMERIC(10,2) | Station-specific standard hours |
Unique constraint: (product_id, equipment_id) — one standard per product-station combination.
Use Case
A product “Widget Assembly” might have:
- Station “Cutting”: standard_hours = 0.5
- Station “Assembly”: standard_hours = 1.5
- Station “QC”: standard_hours = 0.25
This granularity enables accurate per-station efficiency analysis.
Relationship to Product-Level Standard Hours
Products carry their own standard_hours field (see Product). Station standards provide additional granularity for station-specific efficiency calculations, allowing the same product to have different expectations depending on where in the process flow it is being worked.
Codebase Paths
- Table:
database/sql_scripts/tables/oee_product_equipment_config.sql - Functions:
database/sql_scripts/functions/ops/ops_product_equipment_config_functions.sql - Frontend:
frontend/src/app/features/oee-dashboard/components/equipment-editor-dialog/