📦 Magento_Catalog · engine innodb
catalog_product_link_attribute
Catalog Product Link Attribute Table
Neighbourhood (1-hop foreign-key graph — showing 4 of 4)
flowchart LR c["catalog_product_link_attribute"]:::center n0["catalog_product_link_type"] click n0 "/schema/table/catalog_product_link_type" n0 -- link_type_id --> c n1["catalog_product_link_attribute_decimal"] click n1 "/schema/table/catalog_product_link_attribute_decimal" c -- product_link_attribute_id --> n1 n2["catalog_product_link_attribute_int"] click n2 "/schema/table/catalog_product_link_attribute_int" c -- product_link_attribute_id --> n2 n3["catalog_product_link_attribute_varchar"] click n3 "/schema/table/catalog_product_link_attribute_varchar" c -- product_link_attribute_id --> n3 click c "/schema/table/catalog_product_link_attribute" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (4)
Columns (4)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| product_link_attribute_id PK | smallint unsigned | no | Product Link Attribute ID | |
| link_type_id | smallint unsigned | no | 0 | Link Type ID |
| product_link_attribute_code | varchar(32) | yes | Product Link Attribute Code | |
| data_type | varchar(32) | yes | Data Type |
Keys & indexes
Primary key: product_link_attribute_id
Indexes
- CATALOG_PRODUCT_LINK_ATTRIBUTE_LINK_TYPE_ID (link_type_id) btree
References (1)
- link_type_id → catalog_product_link_type .link_type_id (on delete CASCADE)
Referenced by (3)
- catalog_product_link_attribute_decimal .product_link_attribute_id → .product_link_attribute_id (on delete CASCADE)
- catalog_product_link_attribute_int .product_link_attribute_id → .product_link_attribute_id (on delete CASCADE)
- catalog_product_link_attribute_varchar .product_link_attribute_id → .product_link_attribute_id (on delete CASCADE)