123

Tables (5)

Management (Untitled4)

  • ManagerID (Key) — Primary key — NOT NULL
  • MenuID (Field)
  • PaymentID (Field2)
  • SoldOut (Field3)
  • Revenue (Field4)

Menu (Untitled5)

  • MenuID (Key) — Primary key — NOT NULL
  • MenuName (Field)
  • Category (Field2)
  • Option (Field3)
  • Price (Field4)

Order (Untitled)

  • OrderID (Key) — Primary key — NOT NULL
  • ItemsID (Field)
  • Total (Field2)
  • Orderdate (Field3)

Orderitems (Untitled2)

  • ItemsID (Key) — Primary key — NOT NULL
  • MenuID (Field)
  • Price (Field2)
  • Quantity (Field3)
  • Subtotal (Field4)

Payment (Untitled3)

  • PaymentID (Key) — Primary key — NOT NULL
  • OrderID (Field)
  • PaymentAmount (Field2)
  • PaymentMethod (Field3)
  • PaymentDate (Field4)