Delivery Service

Tables (5)

store

  • id — bigint(32) — Primary key — NOT NULL
  • name — varchar(100) — Primary key — NOT NULL
  • address — varchar(150) — NOT NULL
  • status — varchar(45)
  • category — varchar(45)
  • star — double
  • thumnail_url — varchar(200)[ — NOT NULL
  • minimum_amount — decimal(11,4) — NOT NULL
  • minimum_delivery_amount — decimal(11,4) — NOT NULL
  • phone_number — varchar(20)

store_menu

  • id — bigint(32) — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • amount — decimal(11,4)
  • store_id — bigint(32) — Foreign key → store.id — NOT NULL
  • status — varchar(50)
  • thumbnail_url — varchar(200)
  • like_count — int
  • sequence — int

user

  • id — bigint(32) — Primary key — NOT NULL
  • name — varchar(50)
  • email — varchar(100)
  • password — varchar(100)
  • status — varchar(50)
  • address — varchar(150)
  • registered_at — datetime
  • unregistered_at — datetime
  • last_login_at — datetime

user_order_menu

  • id — bingint(32) — Primary key — NOT NULL
  • user_order_id — bigint(32) — Foreign key → user_oreder.id — NOT NULL
  • store_menu_id — bigint(32) — Foreign key → store_menu.id — NOT NULL
  • status — VARCHAR(50)

user_oreder (user_order)

  • id — bigint(32) — Primary key — NOT NULL
  • user_id — bigint(32) — Foreign key → user.id — NOT NULL
  • status — VARCHAR(50)
  • amount — DECIMAL(11,4)
  • ordered_at — DATETIME
  • accepted_at — DATETIME
  • cooking_started_at — DATETIME
  • delivery_started_at — DATETIME
  • received_at — DATETIME