Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for this run record.”,“why”:“Without it, runs cannot be referenced or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.938653412+00:00”} |
||||
| transform_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the transform definition this run belongs to.”,“why”:“Without it, you cannot tell which transform was executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.964632937+00:00”} |
||||
| run_method | varchar | 255 | null |
|
|
{“what”:“Method used to trigger the run, e.g. manual, scheduled, API.”,“why”:“Without it, you cannot distinguish automated from manual runs for auditing or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.982643620+00:00”} |
|||||
| status | varchar | 50 | null |
|
|
{“what”:“Current state of the run, e.g. running, succeeded, failed.”,“why”:“Without it, you cannot know if the run completed successfully or is still in progress.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.001137707+00:00”} |
|||||
| is_active | bool | 1 | √ | null |
|
|
{“what”:“Flag indicating whether this run is the latest active one for its transform.”,“why”:“Without it, you cannot filter to the current run when multiple runs exist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.018592618+00:00”} |
||||
| start_time | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the run started, in UTC with timezone.”,“why”:“Without it, you cannot measure run duration or order runs chronologically.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.042197140+00:00”} |
|||||
| end_time | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the run finished, null if still running.”,“why”:“Without it, you cannot compute duration or know if the run completed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.063393005+00:00”} |
||||
| message | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text log or error message from the run.”,“why”:“Without it, you lose diagnostic details needed to debug failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.081639644+00:00”} |
||||
| user_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user who triggered the run, if any.”,“why”:“Without it, you cannot attribute runs to users for audit or access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.104709023+00:00”} |
||||
| transform_name | varchar | 254 | √ | null |
|
|
{“what”:“Snapshot of the transform’s name at run time.”,“why”:“Without it, the run’s meaning is lost if the transform is later renamed or deleted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.122183008+00:00”} |
||||
| transform_entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Identifier of the entity the transform operates on, as a character string.”,“why”:“Without it, you cannot know which data entity was processed by this run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.136956440+00:00”} |
||||
| checkpoint_filter_field_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the field used as the checkpoint filter for incremental runs.”,“why”:“Without it, you cannot know which field determined the incremental range.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.149072700+00:00”} |
||||
| checkpoint_lo_value | text | 2147483647 | √ | null |
|
|
{“what”:“Lower bound value of the checkpoint filter range, as text.”,“why”:“Without it, the start of the processed data range is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.162012388+00:00”} |
||||
| checkpoint_hi_value | text | 2147483647 | √ | null |
|
|
{“what”:“Upper bound value of the checkpoint filter range, as text.”,“why”:“Without it, the end of the processed data range is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.186152135+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| transform_run_pkey | Primary key | Asc | id |
| idx_transform_run_active_runs | Performance | Asc/Asc | is_active + transform_id |
| idx_transform_run_last_run_idx | Performance | Asc/Desc | transform_id + start_time |
| idx_transform_run_user_id | Performance | Asc | user_id |
| idx_unique_active_transform_run | Must be unique | Asc/Asc | transform_id + is_active |