📦 Magento_Downloadable · engine innodb
downloadable_sample
Downloadable Sample Table
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["downloadable_sample"]:::center n0["catalog_product_entity"] click n0 "/schema/table/catalog_product_entity" n0 -- product_id --> c n1["downloadable_sample_title"] click n1 "/schema/table/downloadable_sample_title" c -- sample_id --> n1 click c "/schema/table/downloadable_sample" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (6)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| sample_id PK | int unsigned | no | Sample ID | |
| product_id | int unsigned | no | 0 | Product ID |
| sample_url | varchar(255) | yes | Sample URL | |
| sample_file | varchar(255) | yes | Sample file | |
| sample_type | varchar(20) | yes | Sample Type | |
| sort_order | int unsigned | no | 0 | Sort Order |
Keys & indexes
Primary key: sample_id
Indexes
- DOWNLOADABLE_SAMPLE_PRODUCT_ID (product_id) btree
References (1)
- product_id → catalog_product_entity .entity_id (on delete CASCADE)
Referenced by (1)
- downloadable_sample_title .sample_id → .sample_id (on delete CASCADE)