remote_sync_task


Description

{“what”:“A record of a single remote synchronization operation.”,“why”:“Without it, sync attempts and their outcomes cannot be tracked or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:24.905711597+00:00”}

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
core_user.id fk_remote_sync_task_initiated_by N

{“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

Relationships