umc

Tables (7)

Alarm

  • Key (id) — Bigint — Primary key — NOT NULL
  • id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
  • Field (dtype) — varchar(20)
  • Field (title) — varchar(30)
  • Field (body) — text

Member (member)

  • id — Bigint — Primary key — NOT NULL
  • 이름 (userame) — Varchar(20)
  • 성별 (sex) — Varchar(1)
  • 생년월일 (birthday) — Date
  • 주소 (region) — Varchar(20)
  • 포인트 (point) — int
  • Field — enum

Member_mission (member_mission)

  • Key (id) — Bigint — Primary key — NOT NULL
  • mission_id — bigint — Foreign key → Mission.mission_id — NOT NULL
  • id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
  • Field (succes_state) — Varchar(20)

Mission (mission)

  • mission_id (Key) — bigint — Primary key — NOT NULL
  • end_Date (end_date) — Date
  • price' (price) — int
  • store_id — bigint — Foreign key → Store.store_id — NOT NULL
  • Field (region) — Varchar(20)
  • Field (point) — int

Review

  • review_id (id) — bigint — Primary key — NOT NULL
  • user_id — Bigint — Foreign key → Member.id — NOT NULL
  • store_id — bigint — Foreign key → Store.store_id — NOT NULL
  • img — IMAGE
  • star — int(1)
  • Field (content) — text

Store (store)

  • store_id (id) — bigint — Primary key — NOT NULL
  • 가게명 (name) — Varchar(20)
  • 주소 (add) — Varchar(50)
  • 음식종류 (type) — Varchar(20)

favorite_food

  • id — bigint — Primary key — NOT NULL
  • id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
  • 음식종류 (food_type) — Varchar(20)