Codex 5.3 Refactor Note: Canonical refactor plan: docs/CODEX-5.3-REFACTOR-PLAN.md. This document is retained for historical and implementation context during the refactor.

Setup Prisma

This project uses Prisma as the ORM.

Environment Setup

Create a .env.local file in the root with:

DATABASE_URL="postgresql://user:password@localhost:5432/offer_review"
JWT_SECRET="your-secret-key-here-change-in-production"

Database Migrations

# Create migration
npx prisma migrate dev --name init

# Apply migrations
npx prisma migrate deploy

# View schema
npx prisma studio

Seed Data (Development)

npx prisma db seed