_sqlx_migrations

{“what”:“Migration version number, unique identifier for each migration.”,“why”:“Ensures each migration is applied exactly once; lookup key for applied set.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.642705391+00:00”}

{“what”:“Human-readable description of the migration, e.g., ‘create users table’.”,“why”:“Provides context for operators debugging which change a version corresponds to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.673908691+00:00”}

{“what”:“Timestamp when the migration was successfully applied.”,“why”:“Shows when schema changes happened; useful for auditing and rollback decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.689504490+00:00”}

{“what”:“Whether the migration completed successfully (true) or failed (false).”,“why”:“Distinguishes applied from failed attempts; sqlx uses it to decide if a version is safe to re-run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.710649514+00:00”}

{“what”:“Binary checksum of the migration file content.”,“why”:“Detects if a migration file was modified after being applied, preventing silent drift.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.739725408+00:00”}

{“what”:“Duration of migration execution in milliseconds.”,“why”:“Helps identify slow migrations that may need optimization or cause downtime.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:33.779678421+00:00”}