Required SQL — Run in Supabase
CREATE TABLE IF NOT EXISTS sessions (
id TEXT PRIMARY KEY,
label TEXT, hname TEXT, wname TEXT,
hid TEXT, wid TEXT, coach_id TEXT,
original_session_id TEXT,
original_hid TEXT, original_wid TEXT,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE IF NOT EXISTS responses (
id TEXT PRIMARY KEY,
session_id TEXT REFERENCES sessions(id) ON DELETE CASCADE,
spouse TEXT, name TEXT, partner TEXT, coach_id TEXT,
answers JSONB DEFAULT '{}'::jsonb,
done BOOLEAN DEFAULT FALSE,
has_children BOOLEAN,
skip_sexual BOOLEAN DEFAULT FALSE,
completed_at TIMESTAMPTZ
);
ALTER TABLE sessions DISABLE ROW LEVEL SECURITY;
ALTER TABLE responses DISABLE ROW LEVEL SECURITY;