2023_SLI_RESTAURANT

Tables (6)

Untitled (Orders)

  • Key (oderID) — char(10) — Primary key — NOT NULL
  • Field (orderDate) — date
  • Field (Order Method) — char(3)
  • Field (Payment) — int(50000)
  • Key (CustomerID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Customer)

  • Key (CustomerID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — int(10)
  • Field (address) — char(30)

Untitled (FOOD)

  • Key (MenuName) — char(30) — Primary key — NOT NULL
  • Field (Price) — int(50000)
  • Field (Description) — text
  • Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (DeliveryPerson)

  • Key (DeliverID) — char(30) — Primary key — NOT NULL
  • Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (Name) — char(30)
  • Field (Phone) — int(30)
  • Field (DeliveryCompany) — char(30)
  • Field (DeliveryTime) — time
  • Field (DeliveryFee) — int(5000)

Untitled (Side Menu)

  • Key (MenuName) — char(30) — Primary key — NOT NULL
  • Field (Price) — int(5000)
  • Field (Description) — text
  • Key (MenuName2) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Coupon)

  • Key (CouponID) — char(10) — Primary key — NOT NULL
  • Field (Discount) — int(10000)
  • Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL