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 |