Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“what”:“Unique room slug used as primary key.”,“why”:“Ensures each room has exactly one verdict record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.786621306+00:00”} |
||
| passed | bool | 1 | null |
|
|
{“what”:“True if all checks passed, false otherwise.”,“why”:“Allows quick filtering of failing rooms without parsing checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.829716094+00:00”} |
||
| checks | jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object mapping check names to pass/fail status.”,“why”:“Records which specific checks failed, enabling targeted debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.844152078+00:00”} |
||
| detail | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Optional JSON with error details for failed checks.”,“why”:“Provides context like error messages for failed checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.879393425+00:00”} |
|
| screenshot_path | text | 2147483647 | √ | null |
|
|
{“what”:“Filesystem path to a screenshot of the rendered room.”,“why”:“Lets engineers visually inspect the render when a check fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.929435122+00:00”} |
|
| verified_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the verdict was recorded, in UTC.”,“why”:“Tracks when the check ran to correlate with code changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:15.992662815+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| room_render_verdicts_pkey | Primary key | Asc | slug |