d

Tables (6)

Customer (.)

  • PK (CustomerID) — Primary key — NOT NULL
  • (Fname)
  • (Lname)
  • (Address)
  • (Phone)
  • (Email)

Delivery (,)

  • PK (DeliveryID) — Primary key — NOT NULL
  • (OrderID)
  • (Type)
  • (Status)
  • (Departure)
  • (Arrival)

OrderHeader (_)

  • PK (OrderID) — Primary key — NOT NULL
  • (OrderDate)
  • (OrderTime)
  • (CustomerID)
  • PK (CustomerID2) — Foreign key → Customer.PK — NOT NULL
  • PK (DeliveryID) — Foreign key → Delivery.PK — NOT NULL

OrderLine (-)

  • FK (DeliveryID) — Primary key — NOT NULL
  • FK (LineID) — Primary key — NOT NULL
  • (PizzaID)
  • (Quantity)
  • PK (OrderID) — Foreign key → OrderHeader.PK — NOT NULL
  • PK (PizzaID2) — Foreign key → Pizza.PK — NOT NULL

Payment (=)

  • PK (PaymentID) — Primary key — NOT NULL
  • (PDate)
  • (Type)
  • (OrderID)
  • (CustomerID)
  • (Total)
  • PK (OrderID2) — Foreign key → OrderHeader.PK — NOT NULL

Pizza (+)

  • PK (PizzaID) — Primary key — NOT NULL
  • (Name)
  • (Quantity)
  • (Specification)
  • (Price)