shop
Tables (8)
address
- addressID — int — NOT NULL
- addressLine1 — varchar(50)
- addressLine2 — varchar(50)
- city — varchar(30)
- stateProvince — varchar(50)
- contryRegion — varchar(50)
- postalCode — varchar(10)
categories
- CategoryID — INT — NOT NULL
- CategoryName — varchar(50) — NOT NULL
customerAddress
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- addressID — int — Foreign key → address.addressID — NOT NULL
- addressType — text
orders
- OrderID — int — Primary key — NOT NULL
- ProductID — INT — Foreign key → products.ProductID — NOT NULL
- OrderDate — Datetime
- ShipDate — Datetime
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- addressID — int — Foreign key → address.addressID — NOT NULL
products
- ProductID — INT — NOT NULL
- ModelNumber — varchar(20)
- ProductImage — varchar(60)
- UnitCost — decimal(15)
- Description — text
- Inventory — INT — NOT NULL
- CategoryID1 — INT — Foreign key → categories.CategoryID — NOT NULL
- CategoryID2 — INT — Foreign key → categories.CategoryID
- CategoryID3 — INT — Foreign key → categories.CategoryID
- ModelName — varchar(200) — NOT NULL
reviews
- ReviewID — int — NOT NULL
- Rating — int
- Comments — text
- ProductID — INT — Foreign key → products.ProductID
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
shoppingCart
- RecordID — int — NOT NULL
- CartID — nvarchar(150)
- Quantity — int
- ProductID — int — Foreign key → products.ProductID
- DateCreateed — Datetime
- ProductID — INT
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
users
- user_id — varchar(50) — 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 — 마지막 로그인 일자