sync_state


Description

{“what”:“Key-value store for per-target synchronization progress.”,“why”:“Without it, sync state is lost, forcing full re-syncs or missed updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:02.987158465+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
key text 2147483647 null

{“what”:“Unique text identifier for a sync target or resource.”,“why”:“Without it, multiple sync states cannot be distinguished or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:03.176822981+00:00”}

value text 2147483647 √ null

{“what”:“Serialized state payload, e.g. last sync timestamp or cursor.”,“why”:“Without it, the sync state is unknown, so resuming or validating sync is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:03.284995021+00:00”}

Indexes

Constraint Name Type Sort Column(s)
sync_state_pkey Primary key Asc key

Relationships