mission
Tables (5)
mission
- mission_id — BIGINT
- store_id — BIGINT — Foreign key → store.store_id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
- reward_points — INT — NOT NULL
- created_at — DATETIME — NOT NULL
region
- region_id — BIGINT
- name — VARCHAR(20) — NOT NULL
store
- store_id — BIGINT
- region_id — BIGINT — Foreign key → region.region_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- description — VARCHAR(200)
- category — VARCHAR(20) — NOT NULL
- score — FLOAT
- created_at — DATETIME — NOT NULL
user
- user_id — BIGINT
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- total_points — INT — NOT NULL
- created_at — DATETIME — NOT NULL
user_mission
- user_mission_id — BIGINT
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed_at — DATETIME