텀프로젝트1
테이블 (11)
cart_items
- cart_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- size — INT — NOT NULL
- quantity — INT
categories
- category_id — INT
- category_name — VARCHAR(30) — NOT NULL
materials
- material_id — INT
- material_name — VARCHAR(30) — NOT NULL
order_items
- order_item_id — INT — 기본 키
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- size — INT — NOT NULL
- quantity — INT — NOT NULL
- price — INT — NOT NULL
orders
- order_id — INT
- user_id — INT — NOT NULL
- total_price — INT — NOT NULL
- created_at — TIMESTAMP
product_categories
- pc_id — INT
- product_id — INT — NOT NULL
- category_id — INT — NOT NULL
product_images
- image_id — INT
- product_id — INT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
product_sizes
- ps_id — INT
- product_id — INT — NOT NULL
- size — INT — NOT NULL
- stock — INT
products
- product_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- discount_rate — INT
- material_id — INT
- created_at — TIMESTAMP
reviews
- review_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
users
- user_id — INT
- username — VARCHAR(30) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- role — ENUM('USER', 'ADMIN')
- created_at — TIMESTAMP