리복
테이블 (11)
Cart
- cart_id — INT
- user_id — INT — 외래 키 → Users.user_id
- created_at — TIMESTAMP
CartItems
- cart_item_id — INT
- cart_id — INT — 외래 키 → Cart.cart_id
- product_id — INT — 외래 키 → Products.product_id
- size_id — INT — 외래 키 → Sizes.size_id
- color_id — INT — 외래 키 → Colors.color_id
- quantity — INT
Categories
- category_id — INT
- category_name — VARCHAR(255) — NOT NULL
- parent_id — INT — 외래 키 → Categories.category_id
Colors
- color_id — INT
- color_name — VARCHAR(50) — NOT NULL
- color_code — VARCHAR(7)
OrderDetails
- order_detail_id — INT
- order_id — INT — 외래 키 → Orders.order_id
- product_id — INT — 외래 키 → Products.product_id
- quantity — INT
- price — DECIMAL(10, 2)
Orders
- order_id — INT
- user_id — INT — 외래 키 → Users.user_id
- order_date — TIMESTAMP
- total_price — DECIMAL(10, 2)
- status — VARCHAR(50)
ProductDetails
- detail_id — INT
- product_id — INT — 외래 키 → Products.product_id
- size_id — INT — 외래 키 → Sizes.size_id
- color_id — INT — 외래 키 → Colors.color_id
- stock_quantity — INT
Products
- product_id — INT
- product_name — VARCHAR(255) — NOT NULL
- category_id — INT — 외래 키 → Categories.category_id
- description — TEXT
- price — DECIMAL(10, 2)
- product_image — VARCHAR(255)
Reviews
- review_id — INT
- product_id — INT — 외래 키 → Products.product_id
- user_id — INT — 외래 키 → Users.user_id
- rating — INT
- comment — TEXT — EX
- review_date — TIMESTAMP
Sizes
- size_id — INT
- size_value — VARCHAR(50) — NOT NULL
Users
- user_id — INT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP