쇼핑몰
테이블 (6)
Addresses
- AddressID — int
- UserID — varchar(50) — NOT NULL
- FullAddress — text — NOT NULL
Categories
- CategoryID — int
- CategoryName — varchar(50)
PointsTransactions
- TransactionID — int
- user_id — varchar(50)
- TransactionType — varchar(10)
- Points — int
- DateTime — datetime
- Description — varchar(255)
Products
- ProductID — int
- CategoryID — int
- ModelNumber — varchar(10)
- ProductName — varchar(120)
- ProductImage — varchar(100)
- UnitCost — decimal(15)
- Description — text
ShoppingCart
- RecordID — int
- CartID — varchar(150)
- Quantity — int
- ProductID — int
- DateCreated — datetime
users
- user_id — varchar(50) — NOT NULL — 아이디' primary ke
- 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 — 마지막 로그인 일자