Create Database Migration

When to Use

Schema changes only: adding/removing/modifying columns, tables, indexes, or feature flags.

When NOT to Use

Patient data operations (backfilling, updating, transforming data) → Use commons-packages/backend/jobs/ instead.

Create a Migration

npm run migrate:make <name-of-migration>

Creates file in commons-packages/backend/models/migrations/YYYYMMDDHHMMSS_name-of-migration.ts

Common Patterns