transform_job_run


Description

{“what”:“A single execution attempt of a transform job, with method, status, and timing.”,“why”:“Without it, there is no history of job executions, so debugging failures or auditing runs becomes impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.436615464+00:00”}

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

Relationships