색상관리 추가.

테이블 (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`