week0

Tables (6)

missions

  • mission_id — BIGINT
  • store_id — BIGINT — NOT NULL
  • title — VARCHAR(80) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • reward_point — INT — NOT NULL
  • deadline — DATE
  • created_at — DATETIME — NOT NULL

region_mission_summary

  • user_id — BIGINT — Primary key — NOT NULL
  • region_id — INT — Primary key — NOT NULL
  • cleared_count — INT — NOT NULL
  • bonus_given — TINYINT(1) — NOT NULL
  • updated_at — DATETIME — NOT NULL

regions

  • region_id — INT
  • name — VARCHAR(50) — NOT NULL

stores

  • store_id — BIGINT
  • region_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • address — VARCHAR(200)
  • created_at — DATETIME — NOT NULL

user_mission_progress

  • progress_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • mission_id — BIGINT — NOT NULL
  • status — ENUM('ONGOING','SUCCESS','FAILED') — NOT NULL
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • manager_code — VARCHAR(20)

users

  • 유저 id (user_id) — BIGINT — 회원 정보
  • 유저 이메일 (email) — VARCHAR(100)
  • password_hash — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • gender — ENUM('M','F','N')
  • birthdate — DATE
  • address — VARCHAR(200)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL