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

circle-info

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

Last updated