Next Steps & Handoff - NIL Benchmark

What’s Complete

Alembic Migrations

Currently using Base.metadata.create_all() for table creation. Set up proper Alembic migrations for schema versioning:

cd backend
alembic revision --autogenerate -m "initial schema"
alembic upgrade head

Update entrypoint.sh to run alembic upgrade head instead of create_all.

Production Auth Security

SMTP Configuration

Configure a real SMTP provider (SendGrid, AWS SES, Resend) and set SMTP_HOST env vars. All email templates are already built.

Production Docker

Feature	Current State	What’s Needed
Payment integration	Pricing page exists, tier stored on user	Integrate Stripe for plan upgrades, webhook for tier changes
Sport limitations	`sport_limitations` UUID[] field on User	Enforce in query filters so agreement_managers only see assigned sports
Peer group management	Configured via seed, UI shows chips	Wire add/remove buttons in Settings to `PUT /admin/peer-groups`
Athlete search in upload wizard	Dropdown of all athletes	Add server-side search endpoint for large rosters
Password change (logged in)	Only forgot-password flow	Add `/settings/security` page with current+new password form
Data export	CSV export for deals	Add CSV/PDF export for benchmarks, athletes, budget

Feature	Description
LLM extraction upgrade	Replace regex NLP with OpenAI/Claude API for 95%+ accuracy on unstructured contracts
Historical trending	Store snapshots per reporting period, build period-over-period trend charts with real data
Collective reporting	Allow NIL collectives to submit deals on behalf of universities
Agent tracking	Track athlete agents/representatives as a separate entity
Notification system	In-app + email notifications for expiring deals, verification due, budget alerts
Bulk operations	Bulk verify, bulk export, bulk status change for deals
Audit log search	Full-text search across activity log entries
Mobile app	React Native or PWA for on-the-go deal management

Item	Description
Testing	Add pytest integration tests for all API endpoints, Vitest unit tests for Vue components, Playwright E2E
CI/CD	GitHub Actions for lint, test, build, deploy
Monitoring	Sentry for error tracking, Prometheus/Grafana for metrics
CDN	Move MinIO to AWS S3 or Cloudflare R2 for production file storage
Caching	Add Redis for session storage and query caching on heavy benchmark queries

File	What It Does	Start Here If…
`backend/app/main.py`	App bootstrap, all router mounts	Understanding the API surface
`backend/app/models/__init__.py`	All model imports	Understanding the data model
`backend/app/seed.py`	Demo data generation	Customizing demo data
`backend/app/routers/benchmarks.py`	Benchmark engine	Working on analytics
`backend/app/services/extraction/real.py`	PDF extraction	Improving AI extraction
`frontend/src/router/index.ts`	All routes + auth guards	Understanding page structure
`frontend/src/stores/auth.ts`	Auth state + isPremium	Working on access control
`frontend/src/pages/BenchmarksPage.vue`	Most complex page	Understanding frontend patterns
`docker-compose.yml`	Service orchestration	DevOps / deployment