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)