test

Tables (5)

product (Untitled)

  • id (bigint) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)

product_option (Untitled2)

  • id (bigint) — Primary key — NOT NULL
  • group_id (Key) — Foreign key → product_option_group.id — NOT NULL — ex) 사이즈 그룹 ID
  • name (Field) — ex) S, M, L
  • price_delta (Field3)
  • sort_order (Field2)

product_option_group (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • product_id (bigint) — Foreign key → product.id — NOT NULL
  • depends_on_group_id (Key2) — Foreign key → product_option_group.id — NOT NULL — ex) 컬러 그룹 ID
  • name (Field) — ex) 사이즈
  • sort_order (Field2)

product_variant (Untitled3)

  • id (bigint) — Primary key — NOT NULL
  • product_id (bigint2) — Foreign key → product.id — NOT NULL
  • stock_quantity (Field)
  • sku_name (Field2)

product_variant_option (Untitled4)

  • id (bigint) — Primary key — NOT NULL
  • variant_id (bigint2) — Foreign key → product_variant.id — NOT NULL
  • option_id (bigint3) — Foreign key → product_option.id — NOT NULL