📦 Magento_ConfigurableProduct · engine innodb
catalog_product_super_attribute
Catalog Product Super Attribute Table
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["catalog_product_super_attribute"]:::center n0["catalog_product_entity"] click n0 "/schema/table/catalog_product_entity" n0 -- product_id --> c n1["catalog_product_super_attribute_label"] click n1 "/schema/table/catalog_product_super_attribute_label" c -- product_super_attribute_id --> n1 click c "/schema/table/catalog_product_super_attribute" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (4)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| product_super_attribute_id PK | int unsigned | no | Product Super Attribute ID | |
| product_id | int unsigned | no | 0 | Product ID |
| attribute_id | smallint unsigned | no | 0 | Attribute ID |
| position | smallint unsigned | no | 0 | Position |
Keys & indexes
Primary key: product_super_attribute_id
Unique
- CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID (product_id, attribute_id)
References (1)
- product_id → catalog_product_entity .entity_id (on delete CASCADE)
Referenced by (1)
- catalog_product_super_attribute_label .product_super_attribute_id → .product_super_attribute_id (on delete CASCADE)