FoodOrder

Tables (3)

Food (food)

  • FoodID (food_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR2(50)
  • Price (price) — INT(100)
  • Description (description) — VARCHAR2(100)

Order (order)

  • OrderID (order_id) — INT — Primary key — NOT NULL
  • Order Time (order_time) — TIME
  • TotalAmount (totalAmount) — INT

Order Detail (order detail)

  • OrderDetailID (orderDetail_id) — INT — Primary key — NOT NULL
  • OrderID (order_id) — INT — Primary key — NOT NULL
  • FoodID (food_id) — INT — Primary key — NOT NULL
  • Quantity (quantity) — INT