supabase-schema.sql

-- Table 1: Raw webhook logs (stores EVERYTHING that comes in)
CREATE TABLE readai_webhook_logs (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  session_id TEXT,
  trigger_type TEXT,
  title TEXT,
  payload JSONB NOT NULL,
  is_customer_meeting BOOLEAN DEFAULT FALSE,
  processed_at TIMESTAMPTZ,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX idx_webhook_logs_session_id ON readai_webhook_logs(session_id);

-- Table 2: Parsed customer meetings (only external meetings)
CREATE TABLE customer_meetings (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  session_id TEXT UNIQUE NOT NULL,
  title TEXT NOT NULL,
  meeting_date TIMESTAMPTZ,
  duration_minutes INTEGER,
  platform TEXT,
  report_url TEXT,
  owner_name TEXT,
  owner_email TEXT,
  summary TEXT,
  action_items TEXT,
  customer_domains TEXT[],
  external_participants JSONB,
  internal_participants JSONB,
  raw_webhook_id UUID REFERENCES readai_webhook_logs(id),
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX idx_customer_meetings_domains ON customer_meetings USING GIN(customer_domains);

-- Enable Row Level Security (allow all for test env)
ALTER TABLE readai_webhook_logs ENABLE ROW LEVEL SECURITY;
ALTER TABLE customer_meetings ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Service role full access" ON readai_webhook_logs
  FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "Service role full access" ON customer_meetings
  FOR ALL USING (true) WITH CHECK (true);