Labels and Cross-references

Global label registry and generic object-label mappings for cross-entity filtering and analysis.

These views provide access to the global labeling system in Maecos. While most entity-specific label views (e.g., equipment_labels, users_labels) are more convenient for everyday use, these global views are useful when you need to query labels across entity types or work with the label master data.

---

reporting.labels

The global label registry. Every label value used anywhere in the system is defined here.

Field	Type	Description
label_id	uuid	Unique identifier of the label
name	text	Label value
category_id	uuid	Category this label belongs to
category_name	text	Category name
created_at	timestamp	When the label was created
created_by	uuid	User who created the label
updated_at	timestamp	Last modification timestamp
updated_by	uuid	User who last modified the label
deleted_at	timestamp	Soft delete timestamp
deleted_by	uuid	User who deleted the label

---

reporting.object_labels

Generic mapping of labels to objects across all entity types. Each row links one object to one label.

Field	Type	Description
object_type	text	Type of object: 'bos', 'procedure', 'checklist_definition', 'equipment', 'user', 'action', 'workstation', etc.
object_id	uuid	ID of the labeled object
label_id	uuid	The label applied

For most reporting purposes, use the entity-specific label views (e.g., equipment_labels, users_labels). The object_labels view is mainly useful for cross-entity label analysis or when building generic label-based filters.

Joins: Join with labels on label_id to get the label name and category.

---

Example queries

All label categories and their values

SELECT
    category_name,
    name AS label_value,
    label_id
FROM reporting.labels
WHERE deleted_at IS NULL
ORDER BY category_name, name;

Count of labeled objects per entity type

SELECT
    object_type,
    COUNT(DISTINCT object_id) AS labeled_objects,
    COUNT(DISTINCT label_id) AS distinct_labels
FROM reporting.object_labels
GROUP BY object_type
ORDER BY labeled_objects DESC;