Level 5 - SeniorScenario-Based Questions
Scenario: Introduce Multi-Column Business Key
Interviewer prompt: invoices must be unique by (tenant_id, external_invoice_id) for active rows only. Write enforcement SQL.
Schema Context
invoices(invoice_id, tenant_id, external_invoice_id, deleted_at)