asd

Tables (5)

Corner

  • corner_id — INT — Primary key — NOT NULL
  • corner_name — VARCHAR(50) — NOT NULL

Menu

  • menu_id — INT — Primary key — NOT NULL
  • menu_name — VARCHAR(50) — NOT NULL
  • corner_id — INT — Foreign key → Corner.corner_id — NOT NULL

OrderDetail

  • order_id — INT — Primary key — NOT NULL
  • corner_id — INT — Foreign key → Corner.corner_id — NOT NULL
  • menu_id — INT — Foreign key → Menu.menu_id — NOT NULL
  • order_page_id — INT — Foreign key → OrderPage.order_page_id — NOT NULL
  • payment_id — INT — Foreign key → Payment.payment_id — NOT NULL

OrderPage

  • order_page_id — INT — Primary key — NOT NULL
  • order_page_name — VARCHAR(50) — NOT NULL
  • price — DECIMAL(10, 2)
  • quantity — INT
  • totalPrice — DECIMAL(10, 2

Payment

  • payment_id — INT — Primary key — NOT NULL
  • payment_name — VARCHAR(50) — NOT NULL