ch1
Tables (7)
Mission_Assignments
- assignment_id — NOT — Primary key — NOT NULL
- user_id — NOT — NOT NULL
- mission_id — NOT — NOT NULL
- status — NULL
- assigned_at — NULL
- completed_at — NULL
- user_id2 — NOT — NOT NULL
- mission_id2 — NOT — NOT NULL
Missions
- mission_id — NOT — Primary key — NOT NULL
- store_id — NOT — NOT NULL
- mission_title — NOT — NOT NULL
- mission_desc — NULL
- reward_point — NULL
- store_id2 — NOT — NOT NULL
Point_Log
- log_id — NOT — Primary key — NOT NULL
- user_id — NOT — NOT NULL
- points — NOT — NOT NULL
- reason — NOT — NOT NULL
- created_at — NOT — NOT NULL
- user_id2 — NOT — NOT NULL
Regions
- region_id — NOT — Primary key — NOT NULL
- region_name — NULL — NOT NULL
Reviews
- review_id — NOT — Primary key — NOT NULL
- assignment_id — NOT — NOT NULL
- rating — NULL
- comment — NULL — EX
- created_at — NULL
- assignment_id2 — NOT — NOT NULL
Stores
- store_id — NOT — Primary key — NOT NULL
- region_id — NOT — NOT NULL
- store_name — NOT — NOT NULL
- address — NULL
- region_id2 — NOT — NOT NULL
Users
- user_id — NOT — Primary key — NOT NULL
- username — NOT — NOT NULL
- password — NOT — NOT NULL
- email — NULL
- preference — NULL
- points — NULL
- created_at — NULL
- phone_number — NULL
- phone_verified — NOT — NOT NULL