⚙️ Magento_MediaGallery · engine innodb

media_gallery_asset

Media Gallery Asset

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

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

Click a node to jump to that table.

Related tables (2)

adobe_stock_asset → media_gallery_id media_gallery_asset_keyword → asset_id

Columns (12)

Name	Type	Null	Default	Comment
id PK	int unsigned	no		Entity ID
path	text	yes		Path
title	varchar(255)	yes		Title
description	text	yes		Description
source	varchar(255)	yes		Source
hash	varchar(255)	yes		File hash
content_type	varchar(255)	yes		Content Type
width	int unsigned	no	0	Width
height	int unsigned	no	0	Height
size	int unsigned	no		Asset file size in bytes
created_at	timestamp	no	CURRENT_TIMESTAMP	Created At
updated_at	timestamp	no	CURRENT_TIMESTAMP	Updated At

Keys & indexes

Primary key: id

Indexes

MEDIA_GALLERY_ID (id) btree
MEDIA_GALLERY_ASSET_TITLE (title) fulltext

Referenced by (2)

adobe_stock_asset .media_gallery_id → .id (on delete CASCADE)
media_gallery_asset_keyword .asset_id → .id (on delete CASCADE)