색상관리 추가.
테이블 (9)
Colors
- id — INT
- name — VARCHAR(50) — NOT NULL
- hex_code — VARCHAR(7) — NOT NULL
- parent_id — INT — 외래 키 → Colors.id
brand
- brand_id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
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
- brand_id — VARCHAR(50) — 외래 키 → brand.brand_id
- title — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- discount_price — DECIMAL(10,2)
- sku — VARCHAR(50)
- summary — VARCHAR(255)
- thumbnail — VARCHAR(255)
- weight — DECIMAL(5,2)
- dimensions — VARCHAR(50)
- 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
- INDEX — `idx_category_id`
- INDEX — `idx_is_featured`
- INDEX — `idx_average_rating`
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_id — INT — 외래 키 → Colors.id — 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_id`
product_variant_image
- image_id — VARCHAR(50) — 기본 키 — NOT NULL
- variant_id — VARCHAR(50) — 외래 키 → product_variant.variant_id — NOT NULL
- url — VARCHAR(255) — NOT NULL
- format — ENUM('jpg', 'png', 'webp') — NOT NULL
- image_type — ENUM('main', 'front', 'back', 'side', 'zoom')
- min_width — INT
- max_width — INT
- render_priority — INT
- created_at — DATETIME — NOT NULL
- INDEX — `idx_variant_id`