test
Tables (12)
address
- addressID — int — NOT NULL
- addressLine1 — varchar(60)
- addressLine2 — varchar(60)
- city — varchar(30)
- stateProvince — varchar(60)
- contryRegion — varchar(60)
- postalCode — varchar(15)
categories
- CategoryID — INT — Primary key — NOT NULL
- CategoryName — varchar(50)
customer_address
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- addressID — int — Foreign key → address.addressID — NOT NULL
- addressType — text
order_details
- OrderID — bigint — Foreign key → orders.OrderID — NOT NULL
- Quantity — int
- UnitCost — decimal(15)
- ProductID (ProductID2) — INT — Foreign key → orders.ProductID — NOT NULL
- CategoryID (CategoryID4) — INT — Foreign key → orders.CategoryID — NOT NULL
orders
- OrderID — bigInt — 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
- used_point — BIGINT — NOT NULL
- ProductID — INT — Foreign key → products.ProductID
- ProductID (ProductID2) — INT — Foreign key → products.ProductID — NOT NULL
- CategoryID (CategoryID4) — INT — Foreign key → products.CategoryID — NOT NULL
products
- ProductID — INT — Primary key — NOT NULL
- ModelNumber — varchar(20)
- ModelName — varchar(240)
- ProductImage — varchar(60)
- UnitCost — decimal(15)
- Description — text
- CategoryID1 — INT — Foreign key → categories.CategoryID — NOT NULL
- CategoryID2 — INT — Foreign key → categories.CategoryID
- CategoryID3 — INT — Foreign key → categories.CategoryID
- CategoryID (CategoryID4) — INT — Foreign key → categories.CategoryID — 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 — 아이디
- ProductID (ProductID2) — INT — Foreign key → products.ProductID — NOT NULL
- CategoryID (CategoryID4) — INT — Foreign key → products.CategoryID — NOT NULL
role
- role_id — int — NOT NULL
- role — VARCHAR(255)
role_user
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- role_id — int — Foreign key → role.role_id — NOT NULL
shopping_cart
- RecordID — int — NOT NULL
- CartID — nvarchar(150)
- Quantity — int
- DateCreateed — Datetime
- ProductID — INT — Foreign key → products.ProductID
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- ProductID (ProductID2) — INT — Foreign key → products.ProductID — NOT NULL
- CategoryID (CategoryID4) — INT — Foreign key → products.CategoryID — NOT NULL
user_point_history
- history_id — BIGINT — NOT NULL
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
- history — datetime
- used_point — INT
- now_point — int
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 — 마지막 로그인 일자