Database Schema

Sessions Table

CREATE TABLE sessions (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  phone_number VARCHAR(20),
  status VARCHAR(20),
  qr_code TEXT,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

Messages Table

CREATE TABLE messages (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  session_id UUID REFERENCES sessions(id),
  from_number VARCHAR(20),
  to_number VARCHAR(20),
  message TEXT,
  message_type VARCHAR(20),
  timestamp TIMESTAMP DEFAULT NOW()
);

Webhooks Table

CREATE TABLE webhooks (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  session_id UUID REFERENCES sessions(id),
  url TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);