📦 Magento_Catalog · engine innodb
catalog_product_entity_media_gallery_value
Catalog Product Media Gallery Attribute Value Table
Neighbourhood (1-hop foreign-key graph — showing 3 of 3)
flowchart LR c["catalog_product_entity_media_gallery_value"]:::center n0["catalog_product_entity_media_gallery"] click n0 "/schema/table/catalog_product_entity_media_gallery" n0 -- value_id --> c n1["store"] click n1 "/schema/table/store" n1 -- store_id --> c n2["catalog_product_entity"] click n2 "/schema/table/catalog_product_entity" n2 -- entity_id --> c click c "/schema/table/catalog_product_entity_media_gallery_value" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (3)
Columns (7)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| value_id | int unsigned | no | 0 | Value ID |
| store_id | smallint unsigned | no | 0 | Store ID |
| entity_id | int unsigned | no | 0 | Entity ID |
| label | varchar(255) | yes | Label | |
| position | int unsigned | yes | Position | |
| disabled | smallint unsigned | yes | 0 | Is Disabled |
| record_id PK | int unsigned | no | Record ID |
Keys & indexes
Primary key: record_id
Indexes
- CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_STORE_ID (store_id) btree
- CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_ENTITY_ID (entity_id) btree
- CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_VALUE_ID (value_id) btree
- CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID (entity_id, value_id, store_id) btree
References (3)
- value_id → catalog_product_entity_media_gallery .value_id (on delete CASCADE)
- store_id → store .store_id (on delete CASCADE)
- entity_id → catalog_product_entity .entity_id (on delete CASCADE)