wating_system

Tables (4)

menu

  • menu_id — INT
  • store_id — INT — Foreign key → store.store_id — NOT NULL
  • menu_name — VARCHAR(50) — NOT NULL
  • price — INT — NOT NULL

store

  • store_id — INT
  • store_name — VARCHAR(50) — NOT NULL

waiting

  • waiting_id — INT
  • store_id — INT — Foreign key → store.store_id — NOT NULL
  • waiting_number — INT — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • party_size — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • registered_at — DATETIME — NOT NULL
  • called_at — DATETIME
  • entered_at — DATETIME
  • cancelled_at — DATETIME

waiting_order

  • waiting_order_id — INT
  • waiting_id — INT — Foreign key → waiting.waiting_id — NOT NULL
  • menu_id — INT — Foreign key → menu.menu_id — NOT NULL
  • quantity — INT — NOT NULL