Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Unique numeric identifier for each preflight run.”,“why”:“Without it, runs cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.777680968+00:00”} |
|
| build_id | text | 2147483647 | null |
|
|
{“what”:“External build identifier from CI, e.g. Jenkins build number.”,“why”:“Without it, cannot correlate a run to the originating build.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.793194070+00:00”} |
||
| service | text | 2147483647 | null |
|
|
{“what”:“Name of the service being preflighted, e.g. ‘api’.”,“why”:“Without it, runs from different services are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.815644983+00:00”} |
||
| phase | text | 2147483647 | 'building'::text |
|
|
{“what”:“Current stage of the run: building, signing, verifying, etc.”,“why”:“Without it, cannot know which step a run is in or resume after failure.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.842855186+00:00”} |
||
| binary_path | text | 2147483647 | √ | null |
|
|
{“what”:“Filesystem path to the built binary artifact.”,“why”:“Without it, the artifact cannot be located for signing or deployment.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.859497035+00:00”} |
|
| signed_path | text | 2147483647 | √ | null |
|
|
{“what”:“Filesystem path to the signed binary after signing.”,“why”:“Without it, the signed artifact cannot be found for deployment.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.884948570+00:00”} |
|
| signed_identifier | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier of the signed artifact, e.g. UUID or signing cert serial.”,“why”:“Without it, the signed version cannot be traced back to its signature.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.918231722+00:00”} |
|
| binary_hash | text | 2147483647 | √ | null |
|
|
{“what”:“SHA-256 hash of the binary content.”,“why”:“Without it, integrity of the artifact cannot be verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.986678354+00:00”} |
|
| version | text | 2147483647 | √ | null |
|
|
{“what”:“Semantic version string of the service being preflighted.”,“why”:“Without it, cannot map a run to a release version.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.006874755+00:00”} |
|
| mac0_verdict | text | 2147483647 | √ | null |
|
|
{“what”:“Verdict from macOS 0 verification, e.g. ‘pass’ or ‘fail’.”,“why”:“Without it, the outcome of the first macOS check is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.020574342+00:00”} |
|
| mac1_deployed | bool | 1 | false |
|
|
{“what”:“Whether the artifact was deployed to the second macOS environment.”,“why”:“Without it, cannot know if the deployment step completed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.033730459+00:00”} |
||
| preflight_id | text | 2147483647 | √ | null |
|
|
{“what”:“External preflight request identifier from the orchestrator.”,“why”:“Without it, cannot correlate this run to the orchestrator’s request.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.066551720+00:00”} |
|
| rollback_snapshot | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON snapshot of the previous state for rollback.”,“why”:“Without it, a failed deployment cannot be reverted to the prior state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.077627346+00:00”} |
|
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message if the run failed.”,“why”:“Without it, failure reasons are lost and debugging is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.098214498+00:00”} |
|
| callback_url | text | 2147483647 | √ | null |
|
|
{“what”:“URL to notify when the run finishes.”,“why”:“Without it, the caller cannot be informed of completion asynchronously.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.127155333+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the run was created.”,“why”:“Without it, cannot order runs or compute age.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.139618940+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to the run.”,“why”:“Without it, cannot detect stale runs or track progress.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.160647425+00:00”} |
||
| finished_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the run finished, null if still running.”,“why”:“Without it, cannot compute duration or know if run completed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:37.175121698+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| preflight_runs_pkey | Primary key | Asc | id |
| idx_preflight_runs_phase | Performance | Asc | phase |
| idx_preflight_runs_service | Performance | Asc/Desc | service + created_at |
| preflight_runs_build_id_key | Must be unique | Asc | build_id |