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