2026 Scouting Database — Data Flow

Where the data comes from, and where it goes

flowchart TB
  subgraph IN["DATA INPUTS  ·  grouped by source"]
    direction TB
    pff["PFF premium reports
DOM-scrape · graded and charted metrics"]
    cfbd["CFBD API
roster · stats · EPA · plays"]
    rec["Recruiting (247 / On3)
Age · star rating"]
    mock["Mock drafts (D. Jeremiah)
draft capital and its movement"]
    film["Film study (Zach)
1-10 attribute grades"]
    scout["Scouting judgment (Zach)
tiers · notes · watchlists"]
  end

  subgraph MID["STATS + SCORING"]
    direction TB
    stats["QB / RB / WR / TE Stats tabs
the mapped stat grids"]
    deriv["Derived fields
TOT TCH · TAR · 1D"]
    comp["COMPOSITE SCORING
formula not yet defined"]
    dsm["Draft Slot Multiplier Model
backtested v2 · last-8-picks blend"]
    l2l["L2L Report
normalized RB composite"]
  end

  subgraph OUT["OUTPUT TABS"]
    direction TB
    board["SFLX + 1QB Big Boards
ranked prospects · model columns"]
    filmtab["QB / RB / WR / TE Film"]
    notes["Scout Notes · My Guys · Returning to School"]
  end

  pff --> stats
  cfbd --> stats
  rec --> stats
  stats --> deriv
  stats --> comp
  deriv --> comp
  stats --> l2l
  comp --> board
  l2l --> board
  mock --> dsm
  dsm --> board
  film --> filmtab
  filmtab --> board
  scout --> notes
  notes --> board

  classDef ok fill:#E9F3ED,stroke:#2E7D55,color:#16412c;
  classDef gap fill:#FFF6E5,stroke:#C98A00,color:#8a6000;
  classDef bad fill:#FBE9E7,stroke:#C5341A,color:#1C1C1A;
  classDef man fill:#F5F5F3,stroke:#D4D4D0,color:#1C1C1A;
  classDef accent fill:#FEF0EB,stroke:#E85D26,color:#1C1C1A;

  class cfbd,rec,mock,film,dsm,l2l ok;
  class pff,deriv gap;
  class comp bad;
  class stats,filmtab,notes,scout man;
  class board accent;
    

The full column-to-source map