Separate up and down files

Versioned naming

All three tables created

Primary keys defined

Foreign key constraints

At least one index

Appropriate NOT NULL constraints

Correct rollback order

Monetary data types

Idempotent guards

No placeholder text

Sequential steps documented

New columns added first

Data copied in migration

Old column dropped last

Rollback migration present

Rollback reconstructs data

Transaction used

Column existence check or safe DDL

Step explanations in plan

Correct table and column names

Audit table created

Before/after values stored

Primary key on audit table

Timestamp field is timezone-aware

Index on timestamp

Index on entity/row identifier

Index on performed_by

NOT NULL on critical columns

Down migration included

Validation notes present

No placeholder SQL