DataMall

Tables (7)

Categories

  • CategoryID (Key) — INT — Primary key — NOT NULL
  • CategoryName — varchar(50)

Customers

  • CustomerID — int — Primary key
  • Name — varchar(10)
  • EmailAddress — varchar(100)
  • Password — varchar(12)

OrderDetails

  • OrderID (OrderID2) — int — Foreign key → Orders.OrderID
  • ProductID (ProductID2) — Foreign key → Products.ProductID — NOT NULL — Auto_Increase
  • Quantity — int
  • UnitCost — decimal(15)

Orders

  • OrderID — int — Primary key
  • OrderDate — Datetime
  • ShipDate — Datetime
  • CustomerID (CustomerID2) — int — Foreign key → Customers.CustomerID

Products

  • ProductID — Primary key — NOT NULL — Auto_Increase
  • ModelNumber — nvarchar(10)
  • ModelName — nvarchar(120)
  • ProductImage — nvarchar(30)
  • UnitCost — decimal(15)
  • Description — text
  • CategoryID — INT — Foreign key → Categories.CategoryID — NOT NULL

Reviews

  • ReviewID — int — Primary key
  • Rating — int
  • Comments — text
  • ProductID (Key) — Foreign key → Products.ProductID — NOT NULL — Auto_Increase
  • CustomerID (CustomerID2) — int — Foreign key → Customers.CustomerID

ShoppingCart

  • RecordID — int — Primary key
  • CartID — nvarchar(150)
  • Quantity — int
  • DateCreateed — Datetime
  • ProductID (ProductID2) — Foreign key → Products.ProductID — NOT NULL — Auto_Increase