Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| domain | text | 2147483647 | null |
|
|
{“what”:“The website domain (e.g., example.com) that was scanned.”,“why”:“Identifies which site each run belongs to; without it runs are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.723511318+00:00”} |
||
| ran_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when the run started, set to current time by default.”,“why”:“Provides chronological ordering and allows auditing when each discovery happened.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.761807071+00:00”} |
||
| n_content_layouts | int4 | 10 | null |
|
|
{“what”:“Number of distinct content layouts found during the run.”,“why”:“Quantifies the result of the run; without it the run’s outcome is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.788504253+00:00”} |
||
| tier | text | 2147483647 | √ | null |
|
|
{“what”:“Optional classification of the run, e.g., ‘full’ or ‘incremental’.”,“why”:“Distinguishes run types; without it all runs are treated equally, losing context for filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.884337175+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_discovery_runs | Performance | Asc/Desc | domain + ran_at |