📄 Magento_AdobeStockAsset · engine innodb

adobe_stock_asset

Adobe Stock Asset

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

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

Click a node to jump to that table.

Related tables (3)

category_id → adobe_stock_category creator_id → adobe_stock_creator media_gallery_id → media_gallery_asset

Columns (6)

Name	Type	Null	Default	Comment
id PK	int unsigned	no		Entity ID
media_gallery_id	int unsigned	yes		Media gallery ID
category_id	int unsigned	yes		Category ID
creator_id	int unsigned	yes		Creator ID
is_licensed	int unsigned	no	0	Is Licensed
creation_date	varchar(255)	yes		Creation Date

Keys & indexes

Primary key: id

Indexes

ADB_STK_AST (id) btree
ADB_STK_CT_ID_INDEX (category_id) btree
ADB_STK_CRT_ID_INDEX (creator_id) btree

References (3)

category_id → adobe_stock_category .id (on delete SET NULL)
creator_id → adobe_stock_creator .id (on delete SET NULL)
media_gallery_id → media_gallery_asset .id (on delete CASCADE)