미션-week1
테이블 (9)
food_category
- food_category_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member
- member_id — BIGINT — 기본 키 — NOT NULL
- social_provider — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE') — NOT NULL
- social_uid — VARCHAR(100) — NOT NULL — 소셜 서비스가 발급한 고유 ID
- role — ENUM('USER', 'OWNER', 'ADMIN') — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- gender — ENUM('NONE', 'MALE', 'FEMALE') — NOT NULL
- birth_date — DATE — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20)
- email — VARCHAR(100) — 애플 로그인은 이메일이 없을 수 있어 NULL 허용
- point — INT — NOT NULL
- status — ENUM('ACTIVE', 'DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_mission
- member_mission_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- mission_id — BIGINT — 외래 키 → mission.mission_id — NOT NULL
- status — ENUM('CHALLENGING','COMPLETE') — NOT NULL
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_prefer
- member_prefer_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- food_category_id — BIGINT — 외래 키 → food_category.food_category_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
mission
- mission_id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — 외래 키 → store.store_id — NOT NULL
- reward_point — INT — NOT NULL — 적립 포인트 (예: 500)
- condition_price — INT — NOT NULL — 조건 금액 (예: 12000원 이상 식사)
- deadline_date — DATE — NOT NULL — 마감일 (D-day 계산 기준)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification_setting
- notification_setting_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- is_event_allowed — BOOLEAN — NOT NULL — 새로운 이벤트 수신
- is_review_reply_allowed — BOOLEAN — NOT NULL — 리뷰 답변 알림
- is_inquiry_reply_allowed — BOOLEAN — NOT NULL — 문의 내역 답변 알림
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
point_history
- point_history_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- member_mission_id — BIGINT — 외래 키 → member_mission.member_mission_id
- amount — INT — NOT NULL
- type — ENUM('EARN', 'USE') — NOT NULL
- description — VARCHAR(255) — NOT NULL — 적립/사용 사유
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
region
- region_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
store
- store_id — BIGINT — 기본 키 — NOT NULL
- region_id — BIGINT — 외래 키 → region.region_id — NOT NULL
- food_category_id — BIGINT — 외래 키 → food_category.food_category_id — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10,7) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- image_url — VARCHAR(500)
- owner_verification_code — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL