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)