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