Overview

src/website/ranking_score/
└── routes.py    # All logic in single file

-- In supabase_ranking database (separate from main)
CREATE TABLE pre_payment_rankings (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  website_url TEXT UNIQUE NOT NULL,
  score INTEGER NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);