Level 5 - SeniorScenario-Based Questions
Scenario: Zero-Downtime Add Enum-Like Status
Interviewer prompt: Payments team wants a new status value 'CHARGEBACK_REVIEW'. Existing code validates status via CHECK constraint. Write migration SQL with low risk and rollback clarity.
Schema Context
payments(payment_id, status, updated_at)