preflight_transitions


Description

{“what”:“Chronological log of phase changes for preflight builds.”,“why”:“Without it, there is no record of how a build moved through preflight phases, so debugging and auditing become impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.844593907+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null

{“what”:“Unique numeric identifier for each transition row.”,“why”:“Without it, rows cannot be uniquely referenced, breaking foreign keys and deduplication.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.861946079+00:00”}

build_id text 2147483647 null

{“what”:“Identifier of the build that changed phase; format is opaque text.”,“why”:“Without it, transitions cannot be attributed to a specific build, so per-build history is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.876100838+00:00”}

from_phase text 2147483647 null

{“what”:“Text label of the phase the build was in before the change.”,“why”:“Without it, the previous state is unknown, so the transition cannot be reconstructed or validated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.886720196+00:00”}

to_phase text 2147483647 null

{“what”:“Text label of the phase the build entered after the change.”,“why”:“Without it, the new state is unknown, so the transition’s outcome is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.915128050+00:00”}

detail jsonb 2147483647 √ null

{“what”:“Optional JSON object with additional transition-specific data; schema not enforced.”,“why”:“Without it, any extra context (e.g., failure reason, timing details) is lost, making debugging harder.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.935612211+00:00”}

transitioned_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of the transition event; defaults to current time.”,“why”:“Without it, the order of transitions is unknown, so the sequence of phases cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:15.954012869+00:00”}

Indexes

Constraint Name Type Sort Column(s)
preflight_transitions_pkey Primary key Asc id
idx_preflight_transitions_build Performance Asc/Asc build_id + transitioned_at

Relationships