Gamification

CREATE TABLE user_streaks (
  user_id UUID PRIMARY KEY,
  current_streak INTEGER DEFAULT 0,
  longest_streak INTEGER DEFAULT 0,
  total_study_days INTEGER DEFAULT 0,
  last_activity_date DATE,
  streak_freeze_count INTEGER DEFAULT 0,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

// Log study activity
POST /api/streaks/activity

// Get current streak
GET /api/streaks/current

// View activity history
GET /api/streaks/history

// Get activity statistics
GET /api/streaks/stats

function xpToLevel(totalXp) {
  const level = Math.floor(xp / 100) + 1;
  const currentLevelBase = (level - 1) * 100;
  const nextLevelXp = level * 100;
  return { level, currentLevelBase, nextLevelXp };
}

CREATE TABLE user_xp (
  user_id UUID PRIMARY KEY,
  total_xp INTEGER DEFAULT 0,
  level INTEGER DEFAULT 1,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE xp_events (
  id UUID PRIMARY KEY,
  user_id UUID NOT NULL,
  delta INTEGER NOT NULL,
  reason TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE badges (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  description TEXT NOT NULL,
  icon TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE user_badges (
  user_id UUID,
  badge_id TEXT,
  earned_at TIMESTAMPTZ DEFAULT NOW(),
  PRIMARY KEY (user_id, badge_id)
);

// Get top users
GET /api/gamification/leaderboards?limit=20

// Response includes:
{
  success: true,
  leaderboard: [
    {
      rank: 1,
      user_id: "...",
      username: "TopStudent",
      total_xp: 5420,
      level: 55
    },
    // ...
  ]
}

// Configure daily goals
PUT /api/goals/daily/settings
{
  target_minutes: 60,
  target_sessions: 2,
  target_tasks: 3
}

// Track today's progress
GET /api/goals/daily/today

// Update progress
POST /api/goals/daily/today/increment
{
  minutes_delta: 25,
  sessions_delta: 1,
  tasks_delta: 1
}

CREATE TABLE daily_goal_settings (
  user_id UUID PRIMARY KEY,
  target_minutes INTEGER DEFAULT 60,
  target_sessions INTEGER DEFAULT 2,
  target_tasks INTEGER DEFAULT 3,
  updated_at TIMESTAMPTZ
);

CREATE TABLE daily_goal_progress (
  user_id UUID,
  goal_date DATE,
  minutes_done INTEGER DEFAULT 0,
  sessions_done INTEGER DEFAULT 0,
  tasks_done INTEGER DEFAULT 0,
  PRIMARY KEY (user_id, goal_date)
);

POST /api/gamification/challenges
{
  title: "30-Day Study Challenge",
  description: "Study for at least 30 minutes every day for 30 days",
  target_count: 30,
  start_date: "2026-03-01",
  end_date: "2026-03-31"
}

// Update challenge progress
POST /api/gamification/challenges/:id/progress
{
  delta: 1  // Increment by 1
}

// View all challenges
GET /api/gamification/challenges

// Create a new habit
POST /api/goals/habits
{
  name: "Review flashcards daily"
}

// List all habits
GET /api/goals/habits

// Archive a habit
PATCH /api/goals/habits/:id
{
  is_archived: true
}

// Mark today as complete
POST /api/goals/habits/:id/checkin
{
  done: true,
  checkin_date: "2026-03-03"
}

// View check-in history
GET /api/goals/habits/checkins?from=2026-03-01&to=2026-03-31

CREATE TABLE habits (
  id UUID PRIMARY KEY,
  user_id UUID NOT NULL,
  name TEXT NOT NULL,
  is_archived BOOLEAN DEFAULT FALSE,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE habit_checkins (
  habit_id UUID,
  user_id UUID,
  checkin_date DATE,
  done BOOLEAN DEFAULT TRUE,
  PRIMARY KEY (habit_id, checkin_date)
);

// Connect with a partner by username
POST /api/gamification/accountability/partner
{
  username: "studybuddy123"
}

// View your partner
GET /api/gamification/accountability/partner

// Send a check-in message
POST /api/gamification/accountability/checkins
{
  message: "Completed 2 hours of studying today!"
}

// View check-in history
GET /api/gamification/accountability/checkins?limit=50

// Create a milestone
POST /api/gamification/milestones
{
  milestone_type: "study",
  title: "Completed first exam preparation",
  metadata: {
    subject: "Mathematics",
    score: 95
  }
}

// List all milestones
GET /api/gamification/milestones?limit=50