One-time setup required. The
alignment_check_sessions table does not exist yet. Copy and run this SQL in your
Supabase SQL Editor, then reload this page.
CREATE TABLE IF NOT EXISTS alignment_check_sessions (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
created_at timestamptz DEFAULT now(),
org_name text,
facilitator text,
vertical text,
dept text,
employees integer,
session_date text,
session_data jsonb DEFAULT '{}',
total_drain_mins integer DEFAULT 0,
drain_count integer DEFAULT 0,
cycle_count integer DEFAULT 0,
stack_count integer DEFAULT 0,
is_live boolean DEFAULT false,
session_code text,
status text DEFAULT 'submitted'
);
-- Allow anon inserts (portal is public)
ALTER TABLE alignment_check_sessions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Portal can insert" ON alignment_check_sessions FOR INSERT TO anon WITH CHECK (true);
CREATE POLICY "Admin can read" ON alignment_check_sessions FOR SELECT TO authenticated USING (true);
CREATE POLICY "Admin can update" ON alignment_check_sessions FOR UPDATE TO authenticated USING (true);
Total Sessions
—
All time
Avg Drain Min/Wk
—
Per session
Reviewed
—
Follow-up sent
| Organisation |
Industry |
Drains |
Min/Wk |
Top Workflow |
Score |
Date |
Status |
|
| Loading… |