umc_workbook_final
Tables (9)
food_category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- image_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
member
- id — BIGINT — Primary key — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- social_type — ENUM('KAKAO', 'NAVER', 'GOOGLE', 'APPLE') — NOT NULL
- social_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- gender — ENUM('MALE', 'FEMALE')
- birth — DATE — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- address_detail — VARCHAR(100) — NOT NULL
- point — INT — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
member_mission
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- mission_id — BIGINT — Foreign key → mission.id — NOT NULL
- status — ENUM('CHALLENGING', 'COMPLETE') — NOT NULL
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
member_prefer_food
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- food_id — BIGINT — Foreign key → food_category.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
member_term
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- term_id — BIGINT — Foreign key → term.id — NOT NULL
- agreed — BOOLEAN — NOT NULL
- agreed_at — DATETIME — NOT NULL
mission
- id — BIGINT — Primary key — NOT NULL
- store_id — BIGINT — Foreign key → store.id — NOT NULL
- condition — VARCHAR(20) — NOT NULL
- start_at — DATETIME
- end_at — DATETIME
- required_amount — INT
- reward_point — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
region
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
store
- id — BIGINT — Primary key — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- food_id — BIGINT — Foreign key → food_category.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- open_at — TIME — NOT NULL
- close_at — TIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
term
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- is_required — BOOLEAN — NOT NULL
- version — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME