과제
테이블 (16)
food_category
- food_category_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL — 한식/양식/치킨 등
inquiry
- inquiry_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- type — VARCHAR(30) — 문의 유형
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL — 대기/답변완료
- created_at — DATETIME — NOT NULL
inquiry_image
- inquiry_image_id — BIGINT — 기본 키 — NOT NULL
- inquiry_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
inquiry_reply
- inquiry_reply_id — BIGINT — 기본 키 — NOT NULL
- inquiry_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
member
- member_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — 소셜만이면 null
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — VARCHAR(10)
- birth_date — DATE
- point — INT — NOT NULL — 현재 보유 포인트(캐시)
- status — VARCHAR(20) — NOT NULL — ACTIVE / WITHDRAWN
- created_at — DATETIME — NOT NULL
- Field
member_food_preference
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- food_category_id — BIGINT — 외래 키 → food_category.food_category_id — 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 — VARCHAR(20) — NOT NULL — 도전중/완료(진행상태) 진행 상태
- earned_point — INT — 지급 확정 포인트
- challenged_at — DATETIME — NOT NULL
- completed_at — DATETIME
mission
- mission_id — BIGINT — 기본 키 — NOT NULL
- store_id — BIGINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- condition_amount — INT — NOT NULL — 12000원 이상 등
- reward_type — VARCHAR(20) — NOT NULL — FIXED / PERCENT
- reward_point — INT — 정액 보상
- reward_rate — DECIMAL(5, 2) — 정률 %
- deadline — DATE
- status — VARCHAR(20) — NOT NULL — OPEN/CLOSED
- created_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — NOT NULL
- type — VARCHAR(30) — NOT NULL — 미션/이벤트/리뷰/문의 알림
- content — VARCHAR(500) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
notification_setting
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- new_event_alert — BOOLEAN — NOT NULL
- review_reply_alert — BOOLEAN — NOT NULL
- inquiry_reply_alert — BOOLEAN — NOT NULL
point_history
- point_history_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL — 적립/사용(적립/차감)
- amount — INT — NOT NULL — +100 / -1000
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
region
- region_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL — 지역명
review
- review_id — BIGINT — 기본 키 — NOT NULL
- member_mission_id — BIGINT — NOT NULL — 미션 완료 건
- store_id — BIGINT — NOT NULL
- rating — INT — NOT NULL — 1~5
- content — TEXT
- created_at — DATETIME — NOT NULL
review_image
- review_image_id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT
social_account
- social_account_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — NOT NULL
- provider — VARCHAR(20) — NOT NULL — KAKAO/NAVER/APPLE/GOOGLE
- provider_user_id — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
store
- store_id — BIGINT — 기본 키 — NOT NULL
- region_id — BIGINT — NOT NULL
- food_category_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- zone_code — VARCHAR(10) — 우편번호 5자리
- address — VARCHAR(255)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- business_status — VARCHAR(20) — NOT NULL — OPEN/CLOSED
- rating_avg — DECIMAL(2, 1) — 리뷰 평균 캐시
- created_at — DATETIME — NOT NULL