Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this run; primary key.”,“why”:“Without it, runs cannot be referenced individually, breaking updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.521465623+00:00”} |
|
| job_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the transform job that this run belongs to.”,“why”:“Without it, a run cannot be linked to its parent job, so per-job history is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.575665593+00:00”} |
||
| run_method | varchar | 255 | null |
|
|
{“what”:“Text label indicating how the run was initiated, e.g., manual or scheduled.”,“why”:“Without it, you cannot distinguish runs by trigger source, so auditing or filtering by method is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.617738005+00:00”} |
||
| status | varchar | 50 | null |
|
|
{“what”:“Text label for the run’s state, such as running, succeeded, or failed.”,“why”:“Without it, you cannot know if a run completed successfully, so error handling and monitoring break.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.636529817+00:00”} |
||
| is_active | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag indicating whether this run is active; null if not set.”,“why”:“Without it, the notion of an active run is undefined, so any logic relying on it breaks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.659951810+00:00”} |
|
| start_time | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone marking the start of the run; defaults to now.”,“why”:“Without it, you cannot measure run duration or know when a run began, so performance analysis fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.851425420+00:00”} |
||
| end_time | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp with time zone marking the end of the run; null if still running.”,“why”:“Without it, you cannot know if a run finished or how long it took, so completion status and duration are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.872146872+00:00”} |
|
| message | text | 2147483647 | √ | null |
|
|
{“what”:“Text field for additional information about the run, such as error details.”,“why”:“Without it, error details or run output are lost, making debugging difficult.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.884421323+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the run record was created; defaults to now.”,“why”:“Without it, you cannot know when the record was inserted, so audit trails and ordering are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.896093728+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to this run record; defaults to now.”,“why”:“Without it, you cannot know when the run’s status or other fields changed, so change tracking is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.912329206+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| transform_job_run_pkey | Primary key | Asc | id |