umc_1week

Tables (14)

consent_document

  • id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • required — BOOLEAN — NOT NULL
  • published_at — DATETIME(6) — NOT NULL

food_category

  • id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • addr1 — VARCHAR(100)
  • addr2 — VARCHAR(100)
  • status — VARCHAR(50)
  • inactive_date — DATE
  • gender — VARCHAR(20) — NOT NULL
  • birth_date — DATE
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • CHECK — (status IN('ACTIVE', 'INACTIVE'))

member_consent

  • member_id — BIGINT — Primary key — NOT NULL
  • document_id — BIGINT — Primary key — NOT NULL
  • agreed_at — DATETIME — NOT NULL

member_food_preference

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • selected_at — DATETIME — NOT NULL
  • INDEX — (member_id)

member_region_progress

  • member_id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Primary key — NOT NULL
  • completed_count — INT — NOT NULL
  • last_completed_at — DATETIME

mission

  • id — BIGINT
  • store_id — BIGINT — NOT NULL
  • region_id — BIGINT — NOT NULL
  • mission_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(120) — NOT NULL
  • description — TEXT
  • starts_at — DATETIME
  • ends_at — DATETIME
  • base_reward — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • INDEX — (region_id, mission_type, starts_at)
  • INDEX — (store_id)
  • CHECK — (mission_type IN ('VISIT'))

mission_assignment

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • mission_id — BIGINT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • assigned_at — DATETIME — NOT NULL
  • started_at — DATETIME
  • completed_at — DATETIME
  • INDEX — (member_id, status, assigned_at)
  • INDEX — (mission_id)
  • CHECK — (status IN ('ASSIGNED','IN_PROGRESS','COMPLETED'))

mission_visit

  • id — BIGINT
  • min_spend — INT — NOT NULL
  • require_owner_code — BOOLEAN — NOT NULL
  • require_receipt — BOOLEAN — NOT NULL

oauth_account

  • member_id — BIGINT — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_user_id — VARCHAR(191) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • CHECK — (provider IN ('KAKAO', 'NAVER', 'APPLE', 'GOOGLE'))

onboarding_state

  • member_id — BIGINT
  • stage — VARCHAR(100) — NOT NULL
  • last_step — VARCHAR(50)
  • updated_at — DATETIME(6) — NOT NULL
  • CHECK — (stage IN ('SIGNED_UP','CONSENTED','PROFILE_DONE','PREFERENCE_DONE','DONE'))

point_ledger

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • delta — INT — NOT NULL
  • reason — VARCHAR(100) — NOT NULL
  • region_id — BIGINT
  • assignment_id — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • INDEX — (member_id, created_at)
  • CHECK — (reason IN ('MISSION_REWARD','REGION_BONUS'))
  • CHECK — (delta <> 0)

region

  • id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

store

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • addr1 — VARCHAR(100)
  • addr2 — VARCHAR(100)
  • owner_secret — VARCHAR(20)
  • region_id — BIGINT — NOT NULL
  • INDEX — (region_id)