Equipment and Workstations

Views for equipment hierarchy, workstations, labels, material type associations, and equipment-workstation mappings.

These views document the asset context in Maecos. Equipment represents machines, lines, or any physical asset. Workstations are operator work locations that may be linked to equipment. Both can carry labels for grouping and filtering, and both are referenced throughout other views (issues, checks, actions) to provide asset context.

---

reporting.equipment

The list of equipment (machines, lines, assets) defined in the system. Supports hierarchical relationships via parent_equipment_id.

Field	Type	Description
equipment_id	uuid	Unique identifier of the equipment
name	text	Name of the equipment
created_at	timestamp	When the equipment was created
created_by	uuid	User who created the record
updated_at	timestamp	Last modification timestamp
updated_by	uuid	User who last modified the record
deleted_at	timestamp	Soft delete timestamp (null if active)
deleted_by	uuid	User who deleted the record
parent_equipment_id	uuid	Parent equipment for hierarchical structures

This view includes soft-deleted equipment. Filter with WHERE deleted_at IS NULL if you only want active equipment.

Joins: Join with equipment_labels for categorization. Join with equipment_material_types to see which material types can run on this equipment. Self-join on parent_equipment_id = equipment_id for hierarchy traversal.

---

reporting.equipment_labels

Labels attached to equipment, inherited down the equipment hierarchy. Used for grouping by area, line, asset type, or any custom categorization.

Field	Type	Description
equipment_id	uuid	The equipment being labeled
label_category	text	Category of the label (e.g., area, asset type)
label_value	text	The label value

---

reporting.equipment_material_types

Maps equipment to the material types it can process.

Field	Type	Description
equipment_id	uuid	The equipment
material_type_id	uuid	The material type

Joins: Join with equipment on equipment_id. Join with material_types on material_type_id.

---

reporting.workstations

Operator work locations. May be linked to equipment or used independently.

Field	Type	Description
workstation_id	uuid	Unique identifier of the workstation
name	text	Name or code of the workstation
created_at	timestamp	When the workstation was created
created_by	uuid	User who created the record
updated_at	timestamp	Last modification timestamp
updated_by	uuid	User who last modified the record

This view already filters out deleted workstations.

---

reporting.workstations_labels

Labels attached to workstations for grouping and filtering.

Field	Type	Description
workstation_id	uuid	The workstation being labeled
label_category	text	Label category
label_value	text	Label value

---

reporting.workstations_equipment

Maps workstations to the equipment they are associated with.

Field	Type	Description
equipment_id	uuid	The equipment
workstation_id	uuid	The workstation
created_at	timestamp	When the association was created
created_by	uuid	User who created the association

Joins: Join with equipment on equipment_id. Join with workstations on workstation_id.

---

Example queries

Equipment hierarchy — list equipment with parent name

SELECT
    e.name AS equipment,
    p.name AS parent_equipment
FROM reporting.equipment e
LEFT JOIN reporting.equipment e_parent
    ON e.parent_equipment_id = e_parent.equipment_id
WHERE e.deleted_at IS NULL
ORDER BY p.name NULLS FIRST, e.name;

Workstations with their equipment and area labels

SELECT
    w.name AS workstation,
    e.name AS equipment,
    el.label_value AS area
FROM reporting.workstations w
JOIN reporting.workstations_equipment we USING (workstation_id)
JOIN reporting.equipment e USING (equipment_id)
LEFT JOIN reporting.equipment_labels el
    ON e.equipment_id = el.equipment_id
    AND el.label_category = 'Area'
ORDER BY area, workstation;