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