📋 Project Details
🎯 Business Impact Scoring

Score each dimension 1–10. Scores are weighted to calculate a composite business priority score.

Composite Business Priority Score
Weighted across all 5 dimensions
📝 Additional Notes
  • 📊
    Loading rankings...

    Fetching projects from database.

Project Team Category Self Score Override Final Status Actions
Loading...
🗄️ Supabase Connection
🔐 Credentials
Contributor Login
Admin Login
📦 Database Setup — Run this SQL in Supabase
-- Run in Supabase SQL Editor
CREATE TABLE IF NOT EXISTS projects (
  id          uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  name        text NOT NULL,
  team        text,
  category    text,
  description text,
  timeline    text,
  effort      text,
  notes       text,
  scores      jsonb NOT NULL DEFAULT '{}',
  composite   numeric(5,2),
  override    numeric(5,2),
  final_score numeric(5,2),
  rank_order  integer,
  status      text DEFAULT 'pending',
  created_at  timestamptz DEFAULT now(),
  updated_at  timestamptz DEFAULT now()
);

-- Enable Row Level Security (allow all for anon - adjust as needed)
ALTER TABLE projects ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON projects FOR ALL USING (true) WITH CHECK (true);