ship

Tables (6)

Customer

  • CustomerID — INT — Primary key
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(100) — NOT NULL
  • Phone — VARCHAR(15)
  • Address — VARCHAR(255)

Order

  • OrderID — INT — Primary key
  • CustomerID — INT
  • OrderDate — DATE — NOT NULL
  • TotalAmount — DECIMAL(10,2) — NOT NULL
  • ShippingAddress — VARCHAR(255)
  • CustomerID (CustomerID2) — INT — Foreign key → Customer.CustomerID

OrderItem

  • OrderItemID — INT — Primary key
  • OrderID — INT
  • ProductID — INT
  • Quantity — INT — NOT NULL
  • Price — DECIMAL(10,2) — NOT NULL
  • CustomerID — INT — Foreign key → Customer.CustomerID

Product

  • ProductID — INT — Primary key
  • Name — VARCHAR(100) — NOT NULL
  • Description — TEXT
  • Price — DECIMAL(10,2) — NOT NULL
  • StockQuantity — INT — NOT NULL
  • OrderItemID — INT — Foreign key → OrderItem.OrderItemID

Shipment

  • ShipmentID — INT — Primary key
  • OrderID — INT
  • ShippedDate — DATE
  • DeliveryDate — DATE
  • Carrier — VARCHAR(100)
  • TrackingNumber — VARCHAR(50)
  • OrderID (OrderID2) — INT — Foreign key → Order.OrderID

ShipmentStatus

  • StatusID — INT — Primary key
  • ShipmentID — INT
  • Status — VARCHAR(50) — NOT NULL
  • UpdateDate — DATE — NOT NULL
  • ShipmentID (ShipmentID2) — INT — Foreign key → Shipment.ShipmentID