schema.sql

CREATE TABLE public.profiles (
  id TEXT PRIMARY KEY,
  created_on TIMESTAMP NOT NULL,
  full_name TEXT,
  username TEXT,
  has_profile BOOLEAN,
  coins INTEGER,
  xp INTEGER,
  level INTEGER,
  last_updated BIGINT,
  achievements JSONB,
  active_boosts JSONB,
  inventory JSONB,
  streak JSONB
);

CREATE TABLE public.quests (
  id TEXT PRIMARY KEY,
  user_id TEXT REFERENCES public.profiles(id),
  created_on TIMESTAMP NOT NULL,
  title TEXT,
  instructions TEXT,
  reward INTEGER,
  is_destroyed BOOLEAN,
  auto_destruct TIMESTAMP,
  last_completed_on TIMESTAMP,
  last_updated BIGINT,
  quest_json JSONB,
  selected_days JSONB,
  time_range JSONB,
  integration_id TEXT
);

CREATE TABLE public.quest_stats (
  id TEXT PRIMARY KEY,
  user_id TEXT REFERENCES public.profiles(id),
  quest_id TEXT REFERENCES public.quests(id),
  date TIMESTAMP
);