📦 Magento_Catalog · engine innodb

catalog_product_entity_media_gallery

Catalog Product Media Gallery Attribute Backend Table

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

flowchart LR
  c["catalog_product_entity_media_gallery"]:::center
  n0["eav_attribute"]
  click n0 "/schema/table/eav_attribute"
  n0 -- attribute_id --> c
  n1["catalog_product_entity_media_gallery_value"]
  click n1 "/schema/table/catalog_product_entity_media_gallery_value"
  c -- value_id --> n1
  n2["catalog_product_entity_media_gallery_value_to_entity"]
  click n2 "/schema/table/catalog_product_entity_media_gallery_value_to_entity"
  c -- value_id --> n2
  n3["catalog_product_entity_media_gallery_value_video"]
  click n3 "/schema/table/catalog_product_entity_media_gallery_value_video"
  c -- value_id --> n3
  click c "/schema/table/catalog_product_entity_media_gallery"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

attribute_id → eav_attribute catalog_product_entity_media_gallery_value → value_id catalog_product_entity_media_gallery_value_to_entity → value_id catalog_product_entity_media_gallery_value_video → value_id

Columns (5)

Name	Type	Null	Default	Comment
value_id PK	int unsigned	no		Value ID
attribute_id	smallint unsigned	no	0	Attribute ID
value	varchar(255)	yes		Value
media_type	varchar(32)	no	image	Media entry type
disabled	smallint unsigned	no	0	Visibility status

Keys & indexes

Primary key: value_id

Indexes

CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ATTRIBUTE_ID (attribute_id) btree

References (1)

attribute_id → eav_attribute .attribute_id (on delete CASCADE)

Referenced by (3)

catalog_product_entity_media_gallery_value .value_id → .value_id (on delete CASCADE)
catalog_product_entity_media_gallery_value_to_entity .value_id → .value_id (on delete CASCADE)
catalog_product_entity_media_gallery_value_video .value_id → .value_id (on delete CASCADE)