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