해커톤
테이블 (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