shoppingmal
Tables (9)
Address
- Address_ID — int — Primary key — NOT NULL
- User_ID — varchar(20) — Foreign key → users.user_id
- State — varchar(255)
- City — varchar(255)
- Address_line — varchar(255)
- Postal_code — varchar(20)
Categories
- CategoryID — int — Primary key — NOT NULL
- CategoryName — varchar(50)
OrderDetails
- ProductID — int — Foreign key → Products.ProductID — NOT NULL
- OrderID — int — Foreign key → Orders.OrderID — NOT NULL
- Quantity — int
- UnitCost — decimal(15,0)
Orders
- OrderID — int — Primary key — NOT NULL
- UserID — varchar(20) — Foreign key → users.user_id
- OrderDate — datetime
- ShipDate — datetime
- Address — varchar(100)
PointHistory
- historyId — int — Primary key — NOT NULL
- userId — varchar(50) — Foreign key → users.user_id
- transactionType — varchar(255)
- transactionAmount — decimal(15,0)
- transactionDate — timestamp
Products
- ProductID — int — Primary key — NOT NULL
- CategoryID — int — Foreign key → Categories.CategoryID
- ModelNumber — varchar(10)
- ModelName — varchar(120)
- ProductImage — varchar(200)
- UnitCost — decimal(15,0)
- Description — text
Reviews
- ReviewID — int — Primary key — NOT NULL
- ProductID — int — Foreign key → Products.ProductID
- UserID — varchar(20) — Foreign key → users.user_id
- Rating — int
- Comments — text
ShoppingCart
- RecordID — int — Primary key — NOT NULL
- UserID — varchar(50) — Foreign key → users.user_id
- Quantity — int
- ProductID — int — Foreign key → Products.ProductID
- DateCreated — datetime
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 — 마지막 로그인 일자