📦 Magento_Downloadable · engine innodb

downloadable_link_purchased

Downloadable Link Purchased Table

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

flowchart LR
  c["downloadable_link_purchased"]:::center
  n0["customer_entity"]
  click n0 "/schema/table/customer_entity"
  n0 -- customer_id --> c
  n1["sales_order"]
  click n1 "/schema/table/sales_order"
  n1 -- order_id --> c
  n2["downloadable_link_purchased_item"]
  click n2 "/schema/table/downloadable_link_purchased_item"
  c -- purchased_id --> n2
  click c "/schema/table/downloadable_link_purchased"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

customer_id → customer_entity order_id → sales_order downloadable_link_purchased_item → purchased_id

Columns (10)

Name	Type	Null	Default	Comment
purchased_id PK	int unsigned	no		Purchased ID
order_id	int unsigned	yes	0	Order ID
order_increment_id	varchar(50)	yes		Order Increment ID
order_item_id	int unsigned	no	0	Order Item ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Date of creation
updated_at	timestamp	no	CURRENT_TIMESTAMP	Date of modification
customer_id	int unsigned	yes	0	Customer ID
product_name	varchar(255)	yes		Product name
product_sku	varchar(255)	yes		Product sku
link_section_title	varchar(255)	yes		Link_section_title

Keys & indexes

Primary key: purchased_id

Indexes

DOWNLOADABLE_LINK_PURCHASED_ORDER_ID (order_id) btree
DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID (order_item_id) btree
DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID (customer_id) btree

References (2)

customer_id → customer_entity .entity_id (on delete SET NULL)
order_id → sales_order .entity_id (on delete SET NULL)

Referenced by (1)

downloadable_link_purchased_item .purchased_id → .purchased_id (on delete CASCADE)