zxcv

Tables (5)

inventory

  • inventory_id — int — Primary key — NOT NULL
  • menu_id — int — Foreign key → menu.menu_id — NOT NULL
  • stock — int — NOT NULL

menu

  • menu_id — int — Primary key — NOT NULL
  • menu_name — varchar(255) — NOT NULL
  • price — decimal(10,0) — NOT NULL

order

  • order_id — int — Primary key — NOT NULL
  • order_time — timestamp — NOT NULL

order_menu

  • order_menu_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → order.order_id — NOT NULL
  • menu_id — int — Foreign key → menu.menu_id — NOT NULL
  • quantity — int — NOT NULL

payment

  • payment_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → order.order_id — NOT NULL
  • payment_method — enum('카드','현금') — NOT NULL
  • payment_amount — decimal(20,0) — NOT NULL
  • payment_time — timestamp — NOT NULL