showping
Tables (7)
Categories
- CategoryID — INT
- CategoryName — varchar(50)
Customers
- CustomerID — int
- 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
- CategoryID — INT
- ModelNumber — nvarchar(10)
- ModelName — nvarchar(120)
- ProductImage — nvarchar(30)
- UnitCost — decimal(15)
- Description — text
Reviews
- ReviewID — int
- ProductID — int
- CustomerID — int
- Rating — int
- Comments — text
ShoppingCart
- RecordID — int
- CartID — nvarchar(150)
- Quantity — int
- ProductID — int
- DateCreateed — Datetime