transform_job


Description

{“what”:“A job that runs a data transformation on a target entity.”,“why”:“Without it, transformation jobs cannot be scheduled, executed, or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.661975200+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
transform_job_transform_tag.job_id fk_transform_job_transform_tag_job_id C

{“what”:“Unique integer identifier for the job.”,“why”:“Without it, no stable reference exists for job operations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.673693836+00:00”}

name text 2147483647 null

{“what”:“Text label for the job, used in UI and logs.”,“why”:“Without it, jobs are only identifiable by ID, making UI and debugging ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.687045343+00:00”}

description text 2147483647 √ null

{“what”:“Free-form details about the job’s purpose or behavior.”,“why”:“Without it, the job’s intent is undocumented, hindering maintenance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.698698349+00:00”}

schedule text 2147483647 null

{“what”:“Cron expression or raw schedule string, e.g., ‘0 0 * * *’.”,“why”:“Without it, the job has no trigger time and cannot run automatically.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.710878133+00:00”}

entity_id bpchar 21 √ null

{“what”:“String identifier of the entity this job operates on.”,“why”:“Without it, the job’s target is unknown, so execution cannot be scoped.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.721983718+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp of job creation.”,“why”:“Without it, the job’s age and creation order are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.733379649+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“UTC timestamp of the last modification to the job.”,“why”:“Without it, stale job definitions cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.746077684+00:00”}

built_in_type varchar 255 √ null

{“what”:“Name of a built-in transformation template, if used.”,“why”:“Without it, the job’s execution engine cannot be determined for built-in jobs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.762148413+00:00”}

ui_display_type varchar 32 'cron/raw'::character varying

{“what”:“UI widget type for schedule editing, defaulting to ‘cron/raw’.”,“why”:“Without it, the frontend does not know how to render the schedule editor.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.779148646+00:00”}

Indexes

Constraint Name Type Sort Column(s)
transform_job_pkey Primary key Asc id
transform_job_entity_id_key Must be unique Asc entity_id

Relationships