beamin

Tables (6)

ADDRESS

  • Key (id) — int — Primary key — NOT NULL
  • Field (address) — varchar(300)
  • Field (address_detail) — varchar(300)
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Field2 (is_prime) — boolean

MENU

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchat(200)
  • Field (price) — int
  • Field (description) — varchat(1000)
  • Field (category) — varchar(50)
  • Key (restaurant_id) — int — Foreign key → RESTAURANT.Key — NOT NULL

MENU_ORDER

  • Key (menu_id) — int — Foreign key → MENU.Key — NOT NULL
  • Key (order_id) — int — Foreign key → ORDER.Key — NOT NULL
  • Field (count)

ORDER

  • Key (id) — int — Primary key — NOT NULL
  • Field (request_message) — varchar(200)
  • Field2 (total_price) — int
  • Field (status) — varchar(200)
  • Field (startAt) — datetime
  • Field (endAt) — datetime
  • Field
  • Key (contect_info_id) — int — Foreign key → ADDRESS.Key — NOT NULL

RESTAURANT

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(45)
  • Field2 (address) — varchar(200)
  • Field (address_detail) — varchat(200)
  • Field (telephone) — varchat(20)

USER

  • Key (id) — int — Primary key — NOT NULL
  • Field (email) — varchat(45)
  • Field (pwd) — varchat(300)
  • Field (phone_number)