과제

테이블 (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