cloud_migration


Description

{“what”:“A record of a single cloud migration job with its lifecycle state.”,“why”:“Without it, there is no way to track or manage ongoing migrations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.566687406+00:00”}

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

Relationships