shopping mall
Tables (11)
Account (Untitled)
- UserPassword
- UserName
- UserAuth
- CreatedDateAt
- LatestLoginDateAt
- UserBirth
Addresses
- AddressID — INT — Primary key
- UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
- 우편번호 (ZipCode) — varchar(20)
- State — varchar(50)
- City — varchar(50) — NOT NULL
- Street — varchar(255) — NOT NULL
Categories
- CategoryID — INT — Primary key
- CategoryName — varchar(50)
OrderDetails
- OrderID — int — Foreign key → Orders.OrderID
- ProductID — INT — Foreign key → Products.ProductID
- Quantity — int
Orders
- OrderID — int — Primary key
- UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
- OrderDate — Datetime
- ShipDate — Datetime
PointUsageHistory
- PointHistoryID — INT — Primary key
- UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
- PointsUsage — INT
- RemainingPoints — INT
- Route
Products
- ProductID — INT — Primary key
- ModelNumber — nvarchar(10)
- ModelName — nvarchar(120)
- ProductImage — nvarchar(30)
- UnitCost — decimal(15)
- Description — text
Reviews
- ReviewID — int — Primary key
- UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
- ProductID — INT — Foreign key → Products.ProductID
- Rating — int
- Comments — text
ShoppingCart
- CartID — nvarchar(150)
- Quantity — int
- DateCreated — Datetime
- RecordID — int
Users
- UserID — varchar(50) — Primary key — NOT NULL — 아이디
- UserPassword
- UserName
- UserBirth
- UserRole
- UserPoint — int — NOT NULL — default : 1000000
- CreatedDateAt
- LatestLoginDateAt
product_categories (Untitled2)
- CategoryID — INT — Foreign key → Categories.CategoryID
- ProductID — INT — Foreign key → Products.ProductID