Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID value; primary key of the row.”,“why”:“Without it, duplicate guidelines cannot be distinguished and updates/deletes become ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.635687032+00:00”} |
||
| version | int4 | 10 | 1 |
|
|
{“what”:“Integer version number; default 1, used to distinguish revisions.”,“why”:“Without it, multiple revisions of the same guideline cannot be ordered or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.735609403+00:00”} |
||
| domain | text | 2147483647 | 'general'::text |
|
|
{“what”:“Text label for the domain or area the guideline applies to; default ‘general’.”,“why”:“Without it, guidelines cannot be filtered by domain, and mixed-scope rules become ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.890673909+00:00”} |
||
| content | text | 2147483647 | null |
|
|
{“what”:“The body text of the guideline; the rule or instruction itself.”,“why”:“Without it, the guideline has no substance and cannot be enforced or displayed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.990136890+00:00”} |
||
| source | text | 2147483647 | 'manual'::text |
|
|
{“what”:“Text label for the origin of the guideline, e.g., ‘manual’ or ‘imported’; default ‘manual’.”,“why”:“Without it, the provenance of a guideline is unknown, making audits and trust decisions impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:48.036185905+00:00”} |
||
| active | bool | 1 | true |
|
|
{“what”:“Boolean flag; true means the guideline is currently enforced, false means it should be ignored.”,“why”:“Without it, inactive guidelines would still be applied, causing incorrect behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:48.066623282+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone; the moment the guideline row was created.”,“why”:“Without it, the age of a guideline is unknown, and audit trails or ordering by creation time become impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:48.087423574+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| guidelines_pkey | Primary key | Asc | id |
| idx_guidelines_active | Performance | Asc/Asc | domain + active |