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