⚙️ Magento_MediaGallery · engine innodb

media_gallery_asset_keyword

Media Gallery Asset Keyword

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

flowchart LR
  c["media_gallery_asset_keyword"]:::center
  n0["media_gallery_keyword"]
  click n0 "/schema/table/media_gallery_keyword"
  n0 -- keyword_id --> c
  n1["media_gallery_asset"]
  click n1 "/schema/table/media_gallery_asset"
  n1 -- asset_id --> c
  click c "/schema/table/media_gallery_asset_keyword"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (2)

keyword_id → media_gallery_keyword asset_id → media_gallery_asset

Columns (2)

Name	Type	Null	Default	Comment
keyword_id	int unsigned	no		Keyword Id
asset_id	int unsigned	no		Asset ID

Keys & indexes

Primary key: keyword_id, asset_id

Indexes

MEDIA_GALLERY_ASSET_KEYWORD_ASSET_ID_INDEX (asset_id) btree
MEDIA_GALLERY_ASSET_KEYWORD_KEYWORD_ID_INDEX (keyword_id) btree

References (2)

keyword_id → media_gallery_keyword .id (on delete CASCADE)
asset_id → media_gallery_asset .id (on delete CASCADE)