shopping
Tables (9)
addresses
- address_id — INT
- user_id — VARCHAR(50)
- address — VARCHAR(255)
cart
- cart_id — INT
- user_id — VARCHAR(50)
- product_id — INT
- quantity — INT
- created_at — DATETIME
categories
- category_id — INT
- category_name — VARCHAR(100)
- sort_order — INT
order_details
- order_detail_id — INT
- order_id — INT
- product_id — INT
- quantity — INT
- price — INT
orders
- order_id — INT
- user_id — VARCHAR(50)
- total_price — INT
- created_at — DATETIME
points
- point_id — INT
- user_id — VARCHAR(50)
- point_change — INT
- description — VARCHAR(255)
- created_at — DATETIME
product_category
- product_id — INT
- category_id — INT
products
- product_id — INT
- product_name — VARCHAR(100)
- description — TEXT
- price — INT
- thumbnail_url — VARCHAR(255)
- image_url — VARCHAR(255)
- created_at — 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 — 마지막 로그인 일자