UMC_ERD
Tables (12)
comment
- Key — Primary key — NOT NULL
- id (review_id) — BIGINT — Foreign key → review.id — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('ACTIVE','HIDDEN') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
favorite_category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
member
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- social_id — VARCHAR(20) — NOT NULL
- social_type — ENUM('KAKAO','GOOGLE','NAVER') — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- phone_verified — BOOLEAN — NOT NULL
- gender — ENUM('MALE','FEMALE','OTHER') — NOT NULL
- address — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- point — INT — NOT NULL
- status — ENUM('ACTIVE','INACTIVE') — NOT NULL
- inactive_date — DATE
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
member_agree
- Key (id) — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → member.id — NOT NULL
- id (terms_id) — BIGINT — Foreign key → terms.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
member_mission
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (mission_id) — BIGINT — Foreign key → mission.Key — NOT NULL
- id (member_id) — BIGINT — Foreign key → member.id — NOT NULL
- Key (id2) — BIGINT — Foreign key → mission.Key — NOT NULL
- completed — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
member_prefer
- id — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → member.id — NOT NULL
- id (category_id) — BIGINT — Foreign key → favorite_category.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
mission
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (store_id) — BIGINT — Foreign key → store.Key — NOT NULL
- mission_spec — TEXT — NOT NULL
- min_spend_money — INT — NOT NULL
- reward_points — INT — NOT NULL
- address — VARCHAR(50) — NOT NULL
- deadline — DATE — NOT NULL
- status — ENUM — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
region
- Key (id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
review
- id — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → member.id — NOT NULL
- Key (store_id) — BIGINT — Foreign key → store.Key — NOT NULL
- context — TEXT — NOT NULL
- rating — FLOAT — NOT NULL
- status — ENUM('ACTIVE','HIDDEN') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
review_image
- Key (id) — BIGINT — Primary key — NOT NULL
- id (review_id) — BIGINT — Foreign key → review.id — NOT NULL
- image_url — VARCHAR(300) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
store
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (region_id) — BIGINT — Foreign key → region.Key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- score — FLOAT — NOT NULL
- closed_day — ENUM('MON','TUE','WED','THU','FRI','SAT','SUN') — NOT NULL
- open_time — TIME — NOT NULL
- close_time — TIME — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
terms
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- body — TEXT — NOT NULL
- optional — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)