testERD
Tables (11)
agreements
- user_id — INT
- over_14 — BOOLEAN — NOT NULL
- terms_of_service — BOOLEAN — NOT NULL
- privacy_policy — BOOLEAN — NOT NULL
- location_service — BOOLEAN
- marketing — BOOLEAN
mission_attempts
- id — INT
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- store_owner_id — BIGINT — NOT NULL
- status — ENUM('대기 중', '성공 요청', '미완료')
- requested_at — TIMESTAMP
- created_at — TIMESTAMP
mission_reviews
- id — INT
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- review_text — TEXT — NOT NULL
- rating — TINYINT
- created_at — TIMESTAMP
missions
- id — INT
- district — VARCHAR(100) — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
- category — ENUM( '한식', '일식', '중식', '양식', '치킨', '분식', '고기/구이', '도시락', '야식', '패스트푸드', '디저트', '아시안 푸드' ) — NOT NULL
- mission_info — VARCHAR(255) — NOT NULL
- reward — INT — NOT NULL
- due_date — DATETIME — NOT NULL
- created_at — TIMESTAMP
notifications
- id — INT
- user_id — INT — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
user_locations
- user_id — INT
- district — VARCHAR(100) — NOT NULL
- updated_at — TIMESTAMP
user_mission_stats
- id — INT
- user_id — INT — NOT NULL
- district — VARCHAR(100) — NOT NULL
- completed_missions — INT
- last_rewarded_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_missions
- id — INT
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- status — ENUM('진행 중', '완료', '실패')
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
user_points
- id — INT
- user_id — INT — NOT NULL
- mission_id — INT
- points — INT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
user_preferences
- id — INT
- user_id — INT — NOT NULL
- food_type — ENUM( '한식', '일식', '중식', '양식', '치킨', '분식', '고기/구이', '도시락', '야식', '패스트푸드', '디저트', '아시안 푸드' ) — NOT NULL
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- gender — ENUM('남', '여', '선택안함')
- birth_date — DATE — NOT NULL
- address — VARCHAR(255)
- created_at — TIMESTAMP