getaiemail

CREATE TABLE IF NOT EXISTS event_records (
  id TEXT PRIMARY KEY,
  event_name TEXT NOT NULL,
  user_id TEXT,
  anonymous_key TEXT,
  scenario TEXT,
  plan TEXT,
  billing TEXT,
  landing_path TEXT,
  referrer TEXT,
  utm_source TEXT,
  utm_medium TEXT,
  utm_campaign TEXT,
  metadata TEXT,
  created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE INDEX IF NOT EXISTS idx_event_records_name_created ON event_records(event_name, created_at DESC);
CREATE INDEX IF NOT EXISTS idx_event_records_scenario_created ON event_records(scenario, created_at DESC);
CREATE INDEX IF NOT EXISTS idx_event_records_plan_created ON event_records(plan, created_at DESC);