📦 Magento_Downloadable · engine innodb
downloadable_link_purchased_item
Downloadable Link Purchased Item Table
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["downloadable_link_purchased_item"]:::center n0["downloadable_link_purchased"] click n0 "/schema/table/downloadable_link_purchased" n0 -- purchased_id --> c n1["sales_order_item"] click n1 "/schema/table/sales_order_item" n1 -- order_item_id --> c click c "/schema/table/downloadable_link_purchased_item" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Columns (16)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| item_id PK | int unsigned | no | Item ID | |
| purchased_id | int unsigned | no | 0 | Purchased ID |
| order_item_id | int unsigned | yes | 0 | Order Item ID |
| product_id | int unsigned | yes | 0 | Product ID |
| link_hash | varchar(255) | yes | Link hash | |
| number_of_downloads_bought | int unsigned | no | 0 | Number of downloads bought |
| number_of_downloads_used | int unsigned | no | 0 | Number of downloads used |
| link_id | int unsigned | no | 0 | Link ID |
| link_title | varchar(255) | yes | Link Title | |
| 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(255) | yes | Link Type | |
| status | varchar(50) | yes | Status | |
| created_at | timestamp | no | CURRENT_TIMESTAMP | Creation Time |
| updated_at | timestamp | no | CURRENT_TIMESTAMP | Update Time |
Keys & indexes
Primary key: item_id
Indexes
- DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH (link_hash) btree
- DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID (order_item_id) btree
- DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID (purchased_id) btree
References (2)
- purchased_id → downloadable_link_purchased .purchased_id (on delete CASCADE)
- order_item_id → sales_order_item .item_id (on delete SET NULL)