Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each sync task.”,“why”:“Without it, tasks cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.003536761+00:00”} |
||||
| sync_task_type | varchar | 24 | null |
|
|
{“what”:“Type of sync operation, e.g., ‘push’ or ‘pull’.”,“why”:“Without it, the correct sync handler cannot be selected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.135315657+00:00”} |
|||||
| progress | float8 | 17,17 | √ | null |
|
|
{“what”:“Completion ratio from 0.0 to 1.0, or NULL if unknown.”,“why”:“Without it, progress cannot be displayed or estimated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.174446478+00:00”} |
||||
| cancelled | bool | 1 | false |
|
|
{“what”:“Boolean flag: true if cancelled, false otherwise.”,“why”:“Without it, cancelled tasks would appear active or failed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.208880073+00:00”} |
|||||
| started_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when the task started.”,“why”:“Without it, task duration and scheduling are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.267535201+00:00”} |
|||||
| ended_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“UTC timestamp when the task finished, or NULL if running.”,“why”:“Without it, completion time and duration are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.329086141+00:00”} |
||||
| last_progress_report_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp of the most recent progress update.”,“why”:“Without it, stale tasks cannot be detected or timed out.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.426273885+00:00”} |
|||||
| initiated_by | int4 | 10 | √ | null |
|
|
{“what”:“User ID that started the task, or NULL if system.”,“why”:“Without it, the task’s origin is unknown, complicating audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.529744814+00:00”} |
||||
| error_message | text | 2147483647 | √ | null |
|
|
{“what”:“Full error text if the task failed, or NULL if none.”,“why”:“Without it, failure reasons are lost, making debugging impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.709498206+00:00”} |
||||
| version | varchar | 50 | √ | null |
|
|
{“what”:“Version identifier of the synced data or client.”,“why”:“Without it, version mismatches cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.955455250+00:00”} |
||||
| conflicts | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized list of conflicts encountered during sync.”,“why”:“Without it, conflicting changes cannot be reviewed or resolved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.981819823+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| remote_sync_task_pkey | Primary key | Asc | id |
| idx_remote_sync_task_current | Performance | Desc/Desc | started_at + id |
| idx_remote_sync_task_initiated_by | Performance | Asc | initiated_by |
| idx_remote_sync_task_progress_report | Performance | Asc | last_progress_report_at |