ShoppingMall
Tables (7)
Categories (카테고리)
- CategoryID (카테고리ID) — INT — Primary key — NOT NULL
- CategoryName (카테고리이름) — VARCHAR(50)
Customers (Untitled2)
- CustomerID (Key) — INT — Primary key — NOT NULL — auto_increment
- Name (Field) — VARCHAR(10)
- EmailAddress (Field2) — VARCHAR(100)
- Password (Field3) — VARCHAR(12)
OrderDetails (Untitled5)
- OrderID (Key) — INT — Foreign key → Orders.OrderID — NOT NULL
- ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
- Quantity (Field) — INT
- UnitCost (Field2) — DECIMAL(15)
Orders (Untitled4)
- OrderID (Key) — INT — Primary key — NOT NULL
- CustomerID (Key2) — INT — Foreign key → Customers.CustomerID — NOT NULL — auto_increment
- OrderDate (Field) — DATETIME
- ShipDate (Field2) — DATETIME
Products (Untitled)
- ProductID (Key) — INT — Primary key — NOT NULL — auto_increment
- Field
- CategoryID (카테고리ID) — INT — Foreign key → Categories.CategoryID — NOT NULL
- ModelNumber (Field2) — NVARCHAR(10)
- ModelName (Field3) — NVARCHAR(120)
- ProductImage (Field4) — NVARCHARR(30)
- UnitCost (Field5) — DECIMAL(15)
- Description (Field6) — TEXT
Reviews (Untitled3)
- ReviewID (Key) — INT — Primary key — NOT NULL — auto_increment
- Field
- ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
- CustomerID (Key3) — INT — Foreign key → Customers.CustomerID — NOT NULL — auto_increment
- Rating (Field2) — INT
- Comments (Field3) — TEXT
ShoppingCart (Untitled6)
- RecordID (Key) — INT — Primary key — NOT NULL — auto_increment
- CartID (Field) — NVARCHAR(150)
- Quantity (Field2) — INT
- ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
- DateCreated (Field3) — DATETIME