Scenario: Enforce Exactly One Primary Address

Interviewer prompt: customers can have many addresses, but only one active primary address per customer. Write schema-level enforcement SQL.

customer_addresses(address_id, customer_id, is_primary, deleted_at)