asddas

Tables (7)

Categories

  • CategoryID — INT — Primary key
  • CategoryName — varchar(50)

Customers

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

OrderDetails

  • OrderID — int
  • ProductID — int
  • Quantity — int
  • UnitCost — decimal(15)

Orders

  • OrderID — int
  • CustomerID — int
  • OrderDate — Datetime
  • ShipDate — Datetime

Products

  • ProductID — INT — Primary key
  • CategoryID — INT
  • ModelNumber — nvarchar(10)
  • ModelName — nvarchar(120)
  • ProductImage — nvarchar(30)
  • UnitCost — decimal(15)
  • Description — text

Reviews

  • ReviewID — int — Primary key
  • Rating — int
  • Comments — text
  • ProductID (ProductID2) — INT — Foreign key → Products.ProductID
  • CustomerID (CustomerID2) — int — Foreign key → Customers.CustomerID

ShoppingCart

  • RecordID — int
  • CartID — nvarchar(150)
  • Quantity — int
  • ProductID — int
  • DateCreateed — Datetime