📦 Magento_Bundle · engine innodb

catalog_product_bundle_selection

Catalog Product Bundle Selection

Neighbourhood (1-hop foreign-key graph — showing 3 of 3)

flowchart LR
  c["catalog_product_bundle_selection"]:::center
  n0["catalog_product_bundle_option"]
  click n0 "/schema/table/catalog_product_bundle_option"
  n0 -- option_id --> c
  n1["catalog_product_entity"]
  click n1 "/schema/table/catalog_product_entity"
  n1 -- product_id --> c
  n2["catalog_product_bundle_selection_price"]
  click n2 "/schema/table/catalog_product_bundle_selection_price"
  c -- selection_id --> n2
  click c "/schema/table/catalog_product_bundle_selection"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

option_id → catalog_product_bundle_option product_id → catalog_product_entity catalog_product_bundle_selection_price → selection_id

Columns (10)

Name	Type	Null	Default	Comment
selection_id PK	int unsigned	no		Selection ID
option_id	int unsigned	no		Option ID
parent_product_id	int unsigned	no		Parent Product ID
product_id	int unsigned	no		Product ID
position	int unsigned	no	0	Position
is_default	smallint unsigned	no	0	Is Default
selection_price_type	smallint unsigned	no	0	Selection Price Type
selection_price_value	decimal	no	0	Selection Price Value
selection_qty	decimal	yes		Selection Qty
selection_can_change_qty	smallint	no	0	Selection Can Change Qty

Keys & indexes

Primary key: selection_id

Indexes

CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION_ID (option_id) btree
CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT_ID (product_id) btree

References (2)

option_id → catalog_product_bundle_option .option_id (on delete CASCADE)
product_id → catalog_product_entity .entity_id (on delete CASCADE)

Referenced by (1)

catalog_product_bundle_selection_price .selection_id → .selection_id (on delete CASCADE)