Skip to main content

​
Overview

The seed script (backend/app/seed.py) runs automatically on first startup when SEED_DB=true. It’s idempotent — skips if data already exists.

​
What Gets Seeded

EntityCountDetails
Conferences10SEC, ACC, Big Ten, Big 12, Pac-12, AAC, Mountain West, Sun Belt, MAC, Conference USA
Universities17Blue Mountain State (demo school) + 16 real schools (Alabama, Georgia, Ohio State, etc.)
Sports6Football, Basketball (M), Basketball (W), Baseball, Track & Field, Soccer (W)
Positions~3210 Football, 5 Basketball, 8 Baseball, 5 Track, 4 Soccer
Brands20Nike, Adidas, Under Armour, Gatorade, Red Bull, State Farm, etc.
Athletes2,320~190 per university, distributed across sports
NIL Deals1,852Realistic values by sport/position, 60% of BMS athletes get deals
Budget Allocations6One per BMS sport with realistic caps
Reporting Periods513 per university (2023-24 closed, 2024-25 closed, 2025-26 open)
Users5Admin (premium), 2 Agreement Managers, 2 Read Only
Activity Logs~62Deal uploads, verifications, certifications, expiry alerts
Athlete Notes~10Internal staff notes on BMS athletes
Contract Files6Placeholder PDFs uploaded to MinIO

​
Deal Value Distributions

The seed generates deals with sport-appropriate value ranges:
Sport / PositionValue Range
Football — QB50,000–50,000 – 500,000
Football — WR, RB20,000–20,000 – 200,000
Football — Other10,000–10,000 – 120,000
Basketball (M/W)15,000–15,000 – 200,000
Baseball5,000–5,000 – 80,000
Track, Soccer3,000–3,000 – 40,000
BMS Football QBs are guaranteed at least 2 deals each to ensure compelling benchmark data.

​
Demo Users

NameEmailRoleTierPurpose
Admin Useradmin@bluemountain.eduadminpremiumFull access, benchmarks visible
Sarah Chensarah.chen@bluemountain.eduagreement_managerpremiumCan submit/edit deals
Mike Thompsonmike.t@bluemountain.eduagreement_managerstandardNo benchmark grid access
Coach Williamscoach.w@bluemountain.eduread_onlystandardView-only
Lisa Rodriguezlisa.r@bluemountain.eduread_onlystandardCompliance officer view

​
Re-seeding

docker compose down -v    # Delete volumes (DB + MinIO)
docker compose up --build # Recreates everything from scratch