red
Tables (10)
Cart
- cart_id — INT — Primary key
- user_id — VARCHAR(50) — Foreign key → Users.user_id — NOT NULL
- created_at — DATETIME
CartItem
- cart_item_id — INT — Primary key
- cart_id — INT — Foreign key → Cart.cart_id — NOT NULL
- product_id — INT — Foreign key → Products.product_id — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Categories
- category_id — INT — Primary key
- category_name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
Order_Details
- detail_id — INT — Primary key
- order_id — INT — Foreign key → Orders.order_id
- product_id — INT — Foreign key → Products.product_id
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
Orders
- order_id — INT — Primary key
- order_number — VARCHAR(50) — NOT NULL
- order_status — VARCHAR(50)
- user_id — VARCHAR(50) — Foreign key → Users.user_id
- total_amount — INT — NOT NULL
- saved_point — INT — NOT NULL
- ordered_at — DATETIME
Point_History
- history_id — INT — Primary key
- user_id — VARCHAR(50) — Foreign key → Users.user_id
- amount — INT — NOT NULL
- description — VARCHAR(200) — NOT NULL
- created_at — DATETIME
Product_Category
- pc_id — INT — Primary key
- product_id — INT — Foreign key → Products.product_id
- category_id — INT — Foreign key → Categories.category_id
Products
- product_id — INT — Primary key
- product_name — VARCHAR(200) — NOT NULL
- product_price — INT — NOT NULL
- product_stock — INT — NOT NULL
- thumb_image — VARCHAR(500)
- detail_image — VARCHAR(500)
User_Addresses
- address_id — INT — Primary key
- user_id — VARCHAR(50) — Foreign key → Users.user_id
- address_detail — VARCHAR(500) — NOT NULL
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 — 마지막 로그인 일자