Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for the migration record.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.596392339+00:00”} |
|
| external_id | text | 2147483647 | null |
|
|
{“what”:“Identifier from the external system that initiated the migration.”,“why”:“Without it, the originating request cannot be correlated back to its source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.669637440+00:00”} |
||
| upload_url | text | 2147483647 | null |
|
|
{“what”:“Pre-signed URL where the migration data is uploaded.”,“why”:“Without it, the client does not know where to send the data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.723426792+00:00”} |
||
| state | varchar | 32 | 'init'::character varying |
|
|
{“what”:“Current lifecycle stage, e.g. init, uploading, done.”,“why”:“Without it, the system cannot decide which actions are valid or resume progress.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.762006398+00:00”} |
||
| progress | int4 | 10 | 0 |
|
|
{“what”:“Percentage of migration completed, from 0 to 100.”,“why”:“Without it, users cannot see how far along the migration is.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.810231837+00:00”} |
||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the migration record was created.”,“why”:“Without it, there is no way to order or age migrations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.854648735+00:00”} |
||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last update to the migration record.”,“why”:“Without it, stale or stuck migrations cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.891997983+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cloud_migration_pkey | Primary key | Asc | id |