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