guidelines


Description

{“what”:“A set of versioned guideline rules, each with a domain, content, and activation status.”,“why”:“Without it, there is no central place to store and retrieve guidelines for enforcement or reference.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.566487368+00:00”}

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

Relationships