umc

Tables (12)

food category

  • id — bigint — Primary key — NOT NULL
  • category_name — varchar

inquiry

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • type — enum
  • title — varchar
  • content — text
  • status — enum
  • created_at — DATETIME
  • updated_at — DATETIME
  • reply — text
  • replied_at — DATETIME

mission

  • mission_id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • mission_title (title) — varchar
  • mission_content — text
  • reward_point (reward_ppint) — int
  • end_date — DATETIME
  • created_at — DATETIME

notification

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • message — text
  • type — enum
  • created_at — DATETIME

prefer_food

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → food category.id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

region

  • id — bigint — Primary key — NOT NULL
  • region_code — varchar
  • name — varchar
  • city — varchar
  • district — varchar
  • neighborhood — varchar
  • latitude — double
  • longitude — double
  • Field

review

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • id (id2) — bigint — Foreign key → store.region_id — NOT NULL
  • score — float
  • review_content — text
  • image_url — text
  • created_at — DATETIME
  • updated_at — DATETIME

store

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • store_name — varchar
  • address — varchar
  • average_rate (averate_rate) — float
  • category_id — bigint

user (User)

  • id — bigint — Primary key — NOT NULL
  • name — varchar
  • birth — DATE
  • gender — Enum
  • address — varchar
  • email — varchar
  • point — int
  • mission_completed — int
  • status — enum
  • updated_at — DATETIME
  • created_at — DATETIME
  • phone_number — varchar
  • is_phone_varified (Field) — boolean

user mission

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.mission_id — NOT NULL
  • status — enum
  • created_at — DATETIME
  • updated_at — DATETIME

user notification

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • event_status — enum
  • review_status — enum
  • inquiry_status — enum
  • created_at — DATETIME
  • updated_at — DATETIME

user point transaction

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.mission_id — NOT NULL
  • type — enum
  • amount — int
  • related_mission_id — bigint
  • created_at — DATETIME
  • updated_at — DATETIME