shoppingmall

Tables (7)

Categories (Untitled)

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

OrderDetails (Untitled6)

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

Orders (Untitled5)

  • OrderID — Int — Primary key — NOT NULL
  • OrderDate — Datetime
  • ShipDate — Datetime
  • CustomerID — Int — Foreign key → users.CustomerID — NOT NULL

Products (Untitled2)

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

Reviews (Untitled4)

  • OrderID — Int — Primary key — NOT NULL
  • Rating — int
  • Field
  • ProductID — Int — Foreign key → Products.ProductID — NOT NULL
  • CustomerID — Int — Foreign key → users.CustomerID — NOT NULL

ShoppingCart (Untitled7)

  • RecordID — Int — Primary key — NOT NULL
  • CartID — nvarchar(150)
  • Quantity — Int
  • DateCreated — Datetime
  • ProductID — Int — Foreign key → Products.ProductID — NOT NULL

users (Untitled3)

  • CustomerID — Int — Primary key — NOT NULL
  • Name — varchar(10)
  • EmailAddress — varchar(100)
  • Password — varchar(12)