Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |