UMC 11기 PE 1주차 - Reward Service ERD

테이블 (12)

food_categories

  • id — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

member_food_categories

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • food_category_id — BIGINT — 외래 키 → food_categories.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

member_missions

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • mission_id — BIGINT — 외래 키 → missions.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • verification_code — VARCHAR(100)
  • verification_requested_at — DATETIME(6)
  • accepted_at — DATETIME(6) — NOT NULL
  • completed_at — DATETIME(6)
  • claimed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member_terms

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • term_id — BIGINT — 외래 키 → terms.id — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

members

  • id — BIGINT — 기본 키 — NOT NULL
  • region_id — BIGINT — 외래 키 → regions.id — NOT NULL
  • email — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • phone_number — VARCHAR(20)
  • gender — VARCHAR(20) — NOT NULL
  • birth_date — DATE — NOT NULL
  • address_detail — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

missions

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — 외래 키 → stores.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500) — NOT NULL
  • minimum_order_amount — DECIMAL(10, 2)
  • reward_points — INT — NOT NULL
  • started_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

regions

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_region_id — BIGINT — 외래 키 → regions.id
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • depth — TINYINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

review_images

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → reviews.id — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

reviews

  • id — BIGINT — 기본 키 — NOT NULL
  • member_mission_id — BIGINT — 외래 키 → member_missions.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — VARCHAR(1000)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

social_accounts

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

stores

  • id — BIGINT — 기본 키 — NOT NULL
  • region_id — BIGINT — 외래 키 → regions.id — NOT NULL
  • food_category_id — BIGINT — 외래 키 → food_categories.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • description — VARCHAR(500)
  • image_url — VARCHAR(2048)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

terms

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content_url — VARCHAR(2048) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • effective_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)