📦 Magento_Downloadable · engine innodb

downloadable_link

Downloadable Link Table

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

flowchart LR
  c["downloadable_link"]:::center
  n0["catalog_product_entity"]
  click n0 "/schema/table/catalog_product_entity"
  n0 -- product_id --> c
  n1["downloadable_link_price"]
  click n1 "/schema/table/downloadable_link_price"
  c -- link_id --> n1
  n2["downloadable_link_title"]
  click n2 "/schema/table/downloadable_link_title"
  c -- link_id --> n2
  click c "/schema/table/downloadable_link"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

product_id → catalog_product_entity downloadable_link_price → link_id downloadable_link_title → link_id

Columns (11)

Name	Type	Null	Default	Comment
link_id PK	int unsigned	no		Link ID
product_id	int unsigned	no	0	Product ID
sort_order	int unsigned	no	0	Sort order
number_of_downloads	int	yes		Number of downloads
is_shareable	smallint unsigned	no	0	Shareable flag
link_url	varchar(255)	yes		Link Url
link_file	varchar(255)	yes		Link File
link_type	varchar(20)	yes		Link Type
sample_url	varchar(255)	yes		Sample Url
sample_file	varchar(255)	yes		Sample File
sample_type	varchar(20)	yes		Sample Type

Keys & indexes

Primary key: link_id

Indexes

DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER (product_id, sort_order) btree

References (1)

product_id → catalog_product_entity .entity_id (on delete CASCADE)

Referenced by (2)

downloadable_link_price .link_id → .link_id (on delete CASCADE)
downloadable_link_title .link_id → .link_id (on delete CASCADE)