shoppingmall
Tables (8)
Categories
- CategoryID — INT — Primary key
- CategoryName — varchar(50)
OrderDetails
- OrderID — int — Foreign key → Orders.OrderID
- user_id — varchar(50) — Foreign key → Orders.user_id — NOT NULL — 아이디
- ProductID — INT — Foreign key → Products.ProductID
- Quantity — int
- UnitCost — decimal(15)
Orders
- OrderID — int — Primary key
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- OrderDate — Datetime
- ShipDate — Datetime
Products
- ProductID — INT — Primary key
- ModelNumber — nvarchar(10)
- ModelName — nvarchar(120)
- ProductImage — nvarchar(30)
- UnitCost — decimal(15)
- Description — text
- CategoryID (CategoryID2) — INT — Foreign key → Categories.CategoryID
Reviews
- ReviewID — int — Primary key
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- ProductID — INT — Foreign key → Products.ProductID
- Rating — int
- Comments — text
ShoppingCart
- RecordID — int — Primary key
- ProductID — INT — Foreign key → Products.ProductID
- CartID — nvarchar(150)
- Quantity — int
- DateCreateed — Datetime
address (Untitled)
- address (Field)
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
users
- user_id — varchar(50) — Primary key — NOT NULL — 아이디
- user_name — varchar(50) — NOT NULL — 이름
- user_password — varchar(200) — NOT NULL — mysql password 사용
- user_birth — varchar(8) — NOT NULL — 생년월일 : 19840503
- user_auth — varchar(10) — NOT NULL — 권한: ROLE_ADMIN,ROLE_USER
- user_point — int — NOT NULL — default : 1000000
- created_at — datetime — NOT NULL — 가입일자
- latest_login_at — datetime — 마지막 로그인 일자