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)