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 |