배달의 민족 연습

테이블 (7)

Untitled (menu)

  • Key (menu_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (category) — varchar(50)
  • Field (name) — varchar(100)
  • Field (price) — decimal
  • Field (status) — varchar(50)

Untitled (store)

  • Key (store_id) — bigint(20) — 기본 키 — NOT NULL
  • Field (name) — varchar(200)
  • Field (type) — int(1)
  • Field (address) — varchar(255)
  • Field (phone) — varchar(20)
  • Field (rating) — int
  • Field (operationHours) — int
  • Field (least_order_price) — decimal
  • Field (status) — varchar(50)

Untitled (cart)

  • Key (cart_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (menu_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (order_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — int — NOT NULL
  • Field (status) — varchar(50)

Untitled (order)

  • Key (order_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (user_id) — bigint(20) — 외래 키 → 회원.Key — NOT NULL
  • Field (status) — varchar(50)
  • Field (payment) — varchar(255)
  • Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (review)

  • Key (review_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (rating) — int
  • Field (content) — varchar(255)
  • Field (status) — varchar(50)

Untitled (option)

  • Key (option_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (menu_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(100)
  • Field (is_checked) — boolean

회원 (user)

  • Key (user_id) — bigint(20) — 기본 키 — NOT NULL
  • Field (password) — varchar(255)
  • Field (name) — varchar(100)
  • Field (phone) — varchar(11)
  • Field (email) — varchar(100)
  • Field (grade) — varchar(100)
  • Field (address) — varchar(100)
  • Field (createAt) — timestamp
  • Field (status) — varchar(50)
  • Field (role) — varchar(50)