재고관리 추가.
테이블 (6)
category
- category_id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_id — VARCHAR(50) — 외래 키 → category.category_id
- parent_name — VARCHAR(100)
- INDEX — idx_parent_id
model
- model_id — VARCHAR(50) — 기본 키 — NOT NULL
- height — INT
- weight — INT
- gender — ENUM('M', 'F', 'O')
- age — INT
product
- product_id — VARCHAR(50) — 기본 키 — NOT NULL
- category_id — VARCHAR(50) — 외래 키 → category.category_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- discount_price — DECIMAL(10,2)
- sku — VARCHAR(50)
- summary — VARCHAR(255)
- color — VARCHAR(50)
- remaining_stock — INT
- stock_status — ENUM('in_stock', 'out_of_stock', 'low_stock') — NOT NULL
- weight — DECIMAL(5,2)
- dimensions — VARCHAR(50)
- thumbnail — VARCHAR(255)
- special — VARCHAR(100)
- tags — VARCHAR(255)
- is_featured — BIT(1) — NOT NULL
- average_rating — DECIMAL(3,1)
- sales_count — INT
- view_count — INT
- availability_date — DATETIME
- enabled — BIT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
product_description_image
- image_id — VARCHAR(50) — 기본 키 — NOT NULL
- product_id — VARCHAR(50) — 외래 키 → product.product_id — NOT NULL
- min_width — INT
- max_width — INT
- url — VARCHAR(255) — NOT NULL
- format — ENUM('jpg', 'png', 'webp') — NOT NULL
- render_priority — INT
- INDEX — idx_product_id
product_detail
- id — BIGINT(20) — 기본 키 — NOT NULL
- product_id — VARCHAR(50) — 외래 키 → product.product_id — NOT NULL
- color_count — INT
- size — INT
- related_item_id — VARCHAR(50) — 외래 키 → product.product_id
- qna — LONGTEXT
- delivery_option — INT
- model_specific — VARCHAR(100) — 모델이 입은 옷 정보(사이즈, 색상)
- model_id — VARCHAR(50) — 외래 키 → model.model_id — NOT NULL
product_variant
- variant_id — VARCHAR(50) — 기본 키 — NOT NULL
- product_id — VARCHAR(50) — 외래 키 → product.product_id — NOT NULL
- sku — VARCHAR(50) — NOT NULL
- color — VARCHAR(50) — NOT NULL
- size — VARCHAR(50) — NOT NULL
- remaining_stock — INT — NOT NULL
- stock_status — ENUM('in_stock', 'out_of_stock', 'low_stock') — NOT NULL
- price_modifier — DECIMAL(10,2)
- image_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- INDEX — idx_product_id
- INDEX — idx_color_size