📦 Magento_Catalog · engine innodb

catalog_product_option

Catalog Product Option Table

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

flowchart LR
  c["catalog_product_option"]:::center
  n0["catalog_product_entity"]
  click n0 "/schema/table/catalog_product_entity"
  n0 -- product_id --> c
  n1["catalog_product_option_type_value"]
  click n1 "/schema/table/catalog_product_option_type_value"
  c -- option_id --> n1
  n2["catalog_product_option_price"]
  click n2 "/schema/table/catalog_product_option_price"
  c -- option_id --> n2
  n3["catalog_product_option_title"]
  click n3 "/schema/table/catalog_product_option_title"
  c -- option_id --> n3
  click c "/schema/table/catalog_product_option"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

product_id → catalog_product_entity catalog_product_option_price → option_id catalog_product_option_title → option_id catalog_product_option_type_value → option_id

Columns (10)

Name	Type	Null	Default	Comment
option_id PK	int unsigned	no		Option ID
product_id	int unsigned	no	0	Product ID
type	varchar(50)	yes		Type
is_require	smallint	no	1	Is Required
sku	varchar(64)	yes		SKU
max_characters	int unsigned	yes		Max Characters
file_extension	varchar(50)	yes		File Extension
image_size_x	smallint unsigned	yes		Image Size X
image_size_y	smallint unsigned	yes		Image Size Y
sort_order	int unsigned	no	0	Sort Order

Keys & indexes

Primary key: option_id

Indexes

CATALOG_PRODUCT_OPTION_PRODUCT_ID (product_id) btree

References (1)

product_id → catalog_product_entity .entity_id (on delete CASCADE)

Referenced by (3)

catalog_product_option_price .option_id → .option_id (on delete CASCADE)
catalog_product_option_title .option_id → .option_id (on delete CASCADE)
catalog_product_option_type_value .option_id → .option_id (on delete CASCADE)