_migrations


Description

{“what”:“Tracks applied database migrations for schema versioning.”,“why”:“Without it, migrations could be re-run or skipped, corrupting schema state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:01.529375473+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
name text 2147483647 null
builds.binary_name Implied Constraint R
deployments.binary_name Implied Constraint R

{“what”:“Unique migration identifier, typically a version or filename.”,“why”:“Without it, applied migrations cannot be distinguished, causing duplicate or missing changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:01.557091282+00:00”}

applied_at timestamptz 35,6 √ now()

{“what”:“UTC timestamp when the migration was executed.”,“why”:“Without it, the order and timing of schema changes is unknown, complicating rollbacks and audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:01.573525061+00:00”}

Indexes

Constraint Name Type Sort Column(s)
_migrations_pkey Primary key Asc name

Relationships