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)