a
Tables (8)
categories
- category_id — int — Primary key — NOT NULL
- category_name — varchar(50)
order_details
- order_id — int — Foreign key → orders.order_id — NOT NULL
- product_id — int — Foreign key → products.product_id — NOT NULL
- quantity — int
- unit_cost — decimal(15,0)
orders
- order_id — int — Primary key — NOT NULL
- user_id — varchar(50) — Foreign key → users.user_id
- order_date — datetime
- ship_date — datetime
point_info
- info_id — int — Primary key — NOT NULL
- user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
- info — varchar(50)
- point — int
- date — datetime
products
- product_id — int — Primary key — NOT NULL
- category_id — int — Foreign key → categories.category_id
- model_number — varchar(10)
- model_name — varchar(120)
- product_image — varchar(300)
- unit_cost — decimal(15,0)
- description — text
reviews
- review_id — int — Primary key — NOT NULL
- product_id — int — Foreign key → products.product_id
- user_id — varchar(50) — Foreign key → users.user_id
- rating — int
- comments — text
shopping_cart
- record_id — int — Primary key — NOT NULL
- quantity — int
- product_id — int — Foreign key → products.product_id
- user_id — varchar(50) — Foreign key → users.user_id
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 — 마지막 로그인 일자