UMC_1stweek

Tables (6)

Mission

  • mission_id — INT
  • store_id — INT — NOT NULL
  • description — TEXT — NOT NULL
  • reward_points — INT — NOT NULL
  • status — ENUM('진행중', '완료')
  • created_at — TIMESTAMP

MissionCompletion

  • user_id — INT — Primary key — NOT NULL
  • region_id — INT — Primary key — NOT NULL
  • missions_completed — INT
  • reward_points — INT

Region

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

Store

  • store_id — INT
  • region_id — INT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

User

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • social_provider — ENUM('local', 'kakao', 'google')
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP

UserMission

  • user_id — INT — Primary key — NOT NULL
  • mission_id — INT — Primary key — NOT NULL
  • status — ENUM('진행중', '완료')
  • completed_at — TIMESTAMP