Phase 1 | Priority: P0 | Status: Not Started | Covers: FR-001

Context

Part of the Self-Serve Referral Flow implementation. This is the foundational data model that all other referral tasks depend on.

Objective

Create the referral_codes database table and migration so referral codes can be generated, stored, and looked up efficiently.

Acceptance Criteria

• Table: referral_codes with columns: id, user_id (FK), code (unique, 8-char), created_at, status (active/revoked)
• Index on code column for fast lookup
• Unique constraint: one active code per user (idempotent generation)
• Migration runs cleanly up and down

Dependencies

Blocked by: None (first task). Blocks: all other Phase 1 tasks.