📦 Magento_Catalog · engine innodb
catalog_product_link_attribute_decimal
Catalog Product Link Decimal Attribute Table
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["catalog_product_link_attribute_decimal"]:::center n0["catalog_product_link"] click n0 "/schema/table/catalog_product_link" n0 -- link_id --> c n1["catalog_product_link_attribute"] click n1 "/schema/table/catalog_product_link_attribute" n1 -- product_link_attribute_id --> c click c "/schema/table/catalog_product_link_attribute_decimal" 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 |
|---|---|---|---|---|
| value_id PK | int unsigned | no | Value ID | |
| product_link_attribute_id | smallint unsigned | yes | Product Link Attribute ID | |
| link_id | int unsigned | no | Link ID | |
| value | decimal | no | 0 | Value |
Keys & indexes
Primary key: value_id
Unique
- CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID_LNK_ID (product_link_attribute_id, link_id)
Indexes
- CATALOG_PRODUCT_LINK_ATTRIBUTE_DECIMAL_LINK_ID (link_id) btree
References (2)
- link_id → catalog_product_link .link_id (on delete CASCADE)
- product_link_attribute_id → catalog_product_link_attribute .product_link_attribute_id (on delete CASCADE)