0주차
테이블 (8)
location
- location_id — BIGINT — 기본 키 — NOT NULL
- location_name — VARCHAR(30) — NOT NULL
mission
- mission_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(50) — NOT NULL
- description — VARCHAR(200) — NOT NULL
- point — INT — NOT NULL
- deadline — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- store_id — BIGINT — 외래 키 → store.store_id — NOT NULL
review
- review_id — BIGINT — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- rating — INT — NOT NULL
- user_id — NOTNULL — 외래 키 → user.user_id — NOT NULL
- store_id — BIGINT — 외래 키 → store.store_id — NOT NULL
review_photo
- review_photo_id — BIGINT — 기본 키 — NOT NULL
- review_photo_url — VARCHAR(100)
- review_id — BIGINT — 외래 키 → review.review_id — NOT NULL
review_reply
- reply_id — BIGINT — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
- review_id — BIGINT — 외래 키 → review.review_id — NOT NULL
store
- store_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(30) — NOT NULL
- manager_code — BIGINT — NOT NULL
- detail_address — VARCHAR(100) — NOT NULL
- location_id — NOTNULL — 외래 키 → location.location_id — NOT NULL
user
- user_id — NOTNULL — 기본 키 — NOT NULL
- social_type — ENUM('KAKAO','NAVER','APPLE','GOOGLE') — NOT NULL
- social_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- gender — ENUM('FEMALE','MALE','OTHER') — NOT NULL
- birth — DATE — NOT NULL
- address — VARCHAR(100) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- phone_number — VARCHAR(15)
- point — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
user_mission
- user_mission_id — BIGINT — 기본 키 — NOT NULL
- status — ENUM('ASSIGNED','IN_PROGRESS','CLEARED','FAILED') — NOT NULL
- started_at — DATETIME
- cleared_at — DATETIME
- updated_at — TIMESTAMP
- mission_id — BIGINT — 외래 키 → mission.mission_id — NOT NULL
- user_id — NOTNULL — 외래 키 → user.user_id — NOT NULL