Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“Unique identifier for a validation verdict; UUID format.”,“why”:“Without it, individual verdicts cannot be referenced or joined to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.145173055+00:00”} |
|||||
| job_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the job that this validation verdict belongs to.”,“why”:“Without it, verdicts cannot be linked to the specific job they validate, so per-job analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.157951959+00:00”} |
|||||
| intent_preserved | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag: true if intent was preserved, false if not, null if not evaluated.”,“why”:“Without it, we cannot know whether the output deviated from the intended meaning, so quality checks fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.169451763+00:00”} |
||||
| facts_preserved | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag: true if factual claims were preserved, false if not, null if not evaluated.”,“why”:“Without it, factual accuracy of the output cannot be verified, so misinformation goes undetected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.184442204+00:00”} |
||||
| constraints_preserved | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag: true if all constraints were respected, false if not, null if not evaluated.”,“why”:“Without it, compliance with specified constraints is unknown, so rule violations are missed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.216486461+00:00”} |
||||
| drift_score | float4 | 8,8 | √ | null |
|
|
{“what”:“Floating-point score quantifying overall deviation from the original; higher values mean more drift.”,“why”:“Without it, there is no quantitative measure to compare verdicts or set thresholds for acceptance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.266112516+00:00”} |
||||
| judge_rationale | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text explanation from the judge model justifying the verdict flags and score.”,“why”:“Without it, the reasoning behind a verdict is opaque, so debugging false positives/negatives is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.290233328+00:00”} |
||||
| latency_ms | int4 | 10 | √ | null |
|
|
{“what”:“Time taken to produce the verdict, in milliseconds.”,“why”:“Without it, performance of the validation step cannot be monitored or optimized.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.301135619+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with timezone) when the verdict was recorded; defaults to current time.”,“why”:“Without it, the temporal order of verdicts is unknown, so time-based analysis or auditing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.313643133+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| validation_verdicts_pkey | Primary key | Asc | id |
| idx_verdicts_job | Performance | Asc | job_id |