pinned_constraints


Description

{“what”:“Pinned constraint definitions with metadata for categorization, priority, and activation.”,“why”:“Without it, the system cannot know which constraints are pinned and their priority for enforcement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.623629579+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“UUID unique identifier for the constraint row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.635541530+00:00”}

label text 2147483647 null

{“what”:“Short human-readable name for the constraint, used in UI and logs.”,“why”:“Without it, there is no concise way to refer to the constraint in user-facing messages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.649009834+00:00”}

content text 2147483647 null

{“what”:“The constraint rule or expression in the system’s constraint language.”,“why”:“Without it, the constraint cannot be evaluated or enforced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.665585911+00:00”}

category text 2147483647 'safety'::text

{“what”:“Categorization of the constraint, defaulting to ‘safety’.”,“why”:“Without it, constraints cannot be grouped or filtered by domain, making it hard to apply selective policies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.697428022+00:00”}

priority int4 10 100

{“what”:“Numeric priority for ordering or conflict resolution; default 100.”,“why”:“Without it, the order of enforcement among conflicting constraints is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.713273857+00:00”}

active bool 1 true

{“what”:“Flag indicating whether the constraint is currently enforced; default true.”,“why”:“Without it, there is no way to disable a constraint without deleting it, losing its configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.733727521+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp of row creation, with timezone.”,“why”:“Without it, audit trails and ordering by creation time are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.751333858+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of last update to the row, with timezone.”,“why”:“Without it, there is no way to detect stale or recently modified constraints.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.764566702+00:00”}

Indexes

Constraint Name Type Sort Column(s)
pinned_constraints_pkey Primary key Asc id
idx_pins_active Performance Asc active

Relationships