Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | null |
|
|
{“what”:“Unique opaque key for this smoke test record.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.944587750+00:00”} |
||
| build_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the build this test ran against.”,“why”:“Without it, test results cannot be linked to a specific build.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.956112924+00:00”} |
||
| repo | text | 2147483647 | null |
|
|
{“what”:“Repository name (e.g., ‘org/repo’) that the build belongs to.”,“why”:“Without it, results cannot be grouped by repository.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.968312067+00:00”} |
||
| phase | text | 2147483647 | null |
|
|
{“what”:“Pipeline phase in which the smoke test ran.”,“why”:“Without it, it is unclear which stage the test result applies to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.983566985+00:00”} |
||
| verdict | text | 2147483647 | null |
|
|
{“what”:“Outcome of the test, e.g., ‘pass’ or ‘fail’.”,“why”:“Without it, the success or failure of the test is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:27.997838811+00:00”} |
||
| issues_json | text | 2147483647 | √ | null |
|
|
{“what”:“JSON array of issue objects found during the test.”,“why”:“Without it, failure details cannot be inspected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:28.017232298+00:00”} |
|
| summary | text | 2147483647 | √ | null |
|
|
{“what”:“Human-readable summary of the test result.”,“why”:“Without it, users cannot see a concise result without parsing JSON.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:28.038039841+00:00”} |
|
| callback_url | text | 2147483647 | √ | null |
|
|
{“what”:“URL to notify when the test completes.”,“why”:“Without it, external systems cannot be notified of completion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:28.097491828+00:00”} |
|
| callback_sent | int4 | 10 | √ | 0 |
|
|
{“what”:“Flag (0 or 1) indicating whether the callback was sent.”,“why”:“Without it, it is unknown if the callback was already delivered, risking duplicate notifications.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:28.109040523+00:00”} |
|
| created_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Timestamp of when the record was created, as text.”,“why”:“Without it, the order and age of test runs cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:28.130580933+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| smoke_tests_pkey | Primary key | Asc | id |
| idx_smoke_repo | Performance | Asc | repo |