해커톤

테이블 (9)

Badge

  • badge_id — INT
  • name — VARCHAR(100)
  • description — TEXT
  • image_url — VARCHAR(255)

Character

  • character_id — INT
  • user_id — INT
  • current_skin — VARCHAR(100)
  • current_animation — VARCHAR(100)
  • level — INT
  • exp — INT

Mission

  • mission_id — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • goal_type — VARCHAR(50)
  • goal_value — INT
  • reward_point — INT
  • reward_badge_id — INT
  • reward_skin_id — INT
  • duration_days — INT

MissionProgress

  • progress_id — INT
  • user_id — INT
  • mission_id — INT
  • status — VARCHAR(20)
  • progress_value — INT
  • started_at — DATETIME
  • completed_at — DATETIME

Ranking

  • ranking_id — INT
  • school_id — INT
  • user_id — INT
  • rank — INT
  • total_exp — INT
  • updated_at — DATETIME

RewardLog

  • reward_log_id — INT
  • user_id — INT
  • mission_id — INT
  • badge_id — INT
  • point — INT
  • skin_id — INT
  • reward_date — DATETIME

School

  • school_id — INT
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(100)

Skin

  • skin_id — INT
  • name — VARCHAR(100)
  • description — TEXT
  • image_url — VARCHAR(255)
  • unlock_level — INT

User

  • user_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • school_id — INT
  • current_level — INT
  • total_exp — INT
  • join_date — DATE