00000
Tables (10)
Mission
- mission_id — INT
- title — VARCHAR(255)
- description — TEXT
- reward_point — INT
- mission_type — VARCHAR(100)
- created_at — DATETIME
Notification
- notification_id — INT
- user_id — INT — Foreign key → User.user_id
- type — VARCHAR(100)
- content — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
Point
- point_id — INT
- user_id — INT — Foreign key → User.user_id
- amount — INT
- reason — VARCHAR(255)
- created_at — DATETIME
Review
- review_id — INT
- user_id — INT — Foreign key → User.user_id
- store_id — INT — Foreign key → Store.store_id
- rating — INT
- content — TEXT
- created_at — DATETIME
Review_Image
- image_id — INT
- review_id — INT — Foreign key → Review.review_id
- image_url — VARCHAR(255)
Store
- store_id — INT
- name — VARCHAR(255)
- category — VARCHAR(100)
- address — VARCHAR(255)
- lat — FLOAT
- lng — FLOAT
- description — TEXT
Store_Mission
- store_mission_id — INT
- store_id — INT — Foreign key → Store.store_id
- mission_id — INT — Foreign key → Mission.mission_id
User
- user_id — INT
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(100)
- profile_image — VARCHAR(255)
- created_at — DATETIME
User_Mission
- user_mission_id — INT
- user_id — INT — Foreign key → User.user_id
- mission_id — INT — Foreign key → Mission.mission_id
- status — VARCHAR(50)
- started_at — DATETIME
- completed_at — DATETIME
User_Preference
- preference_id — INT
- user_id — INT — Foreign key → User.user_id
- category — VARCHAR(100)