UMC 1st

테이블 (12)

member

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'NONE') — NOT NULL
  • birth_date — DATE — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • address_detail — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • email — VARCHAR(100)
  • social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE') — NOT NULL
  • social_uid — VARCHAR(100) — NOT NULL — UNIQUE(social_type, social_uid)
  • point — INT — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_food_preference

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL — UNIQUE(member_id, food_category_id)
  • food_category_id — BIGINT — 외래 키 → 음식 카테고리.아이디 — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_mission

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • mission_id — BIGINT — 외래 키 → mission.id — NOT NULL
  • status — ENUM('IN_PROGRESS','COMPLETED','CANCELED') — NOT NULL
  • completed_at — DATETIME
  • earned_point — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_terms

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL — UNIQUE(member_id, terms_id)
  • terms_id — BIGINT — 외래 키 → 약관명.id — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

mission

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • reward_type — ENUM('FIXED','RATE') — NOT NULL
  • reward_value — INT — NOT NULL
  • min_amount — INT — NOT NULL
  • deadline — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • member_mission_id — BIGINT — 외래 키 → member_mission.id — NOT NULL
  • rating — DECIMAL(2,1) — NOT NULL
  • content — TEXT — NOT NULL
  • owner_reply — TEXT
  • owner_replied_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review_image

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

store

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • owner_code — VARCHAR(20) — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

store_image

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — 외래 키 → store.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

약관명 (terms)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

음식 카테고리 (food_category)

  • 아이디 (id) — BIGINT — 기본 키 — NOT NULL
  • 카테고리명 (name) — VARCHAR(20) — NOT NULL
  • 생성일시 (created_at) — DATETIME — NOT NULL
  • 수정일시 (updated_at) — DATETIME — NOT NULL

지역 (region)

  • 아이디 (id) — BIGINT — 기본 키 — NOT NULL
  • 지역명 (name) — VARCHAR(30) — NOT NULL — UNIQUE
  • 생성일시 (created_at) — DATETIME — NOT NULL
  • 수정일시 (updated_at) — DATETIME — NOT NULL