미션-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