Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this sync record.”,“why”:“Without it, updates and deletes would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.854957269+00:00”} |
|
| model_type | varchar | 32 | null |
|
|
{“what”:“Name of the source model class, e.g. ‘User’ or ‘Post’.”,“why”:“Without it, the polymorphic reference to model_id is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.872558346+00:00”} |
||
| model_id | int4 | 10 | null |
|
|
{“what”:“Primary key of the source model instance.”,“why”:“Without it, cannot identify which specific object to sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.885937223+00:00”} |
||
| status | varchar | 32 | null |
|
|
{“what”:“Current sync state: pending, synced, failed, etc.”,“why”:“Without it, cannot know which objects need retry or are out of sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.906331560+00:00”} |
||
| status_changed_at | timestamptz | 35,6 | null |
|
|
{“what”:“UTC timestamp of last status change.”,“why”:“Without it, cannot order or age sync attempts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.920225424+00:00”} |
||
| model_name | varchar | 255 | null |
|
|
{“what”:“The remote system’s model name for this object.”,“why”:“Without it, remote system cannot map to its own model name.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.933104961+00:00”} |
||
| model_collection_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the remote collection this object belongs to.”,“why”:“Without it, remote system cannot place the object in the correct collection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.945265651+00:00”} |
|
| model_display | varchar | 50 | √ | null |
|
|
{“what”:“Human-readable label for the object, e.g. ‘John Doe’.”,“why”:“Without it, remote system lacks a display name for the object.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.962628584+00:00”} |
|
| model_table_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the target table in the remote system.”,“why”:“Without it, remote system cannot determine which table to write to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.976766613+00:00”} |
|
| model_table_name | varchar | 255 | √ | null |
|
|
{“what”:“The remote system’s table name for this object.”,“why”:“Without it, remote system cannot resolve the table name for writes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.990460406+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| remote_sync_object_pkey | Primary key | Asc | id |
| idx_remote_sync_object_model_lookup | Performance | Asc/Asc | model_type + model_id |