preflight_runs


Description

{“what”:“Records of preflight checks for service builds before deployment.”,“why”:“Without it, no audit trail of preflight attempts and outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:36.754098584+00:00”}

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

Relationships