Fields (20)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| product_stream_id | binary(16) | NO | MUL | NULL | |
| storefront_sales_channel_id | binary(16) | YES | MUL | NULL | |
| sales_channel_id | binary(16) | NO | MUL | NULL | |
| sales_channel_domain_id | binary(16) | YES | MUL | NULL | |
| file_name | varchar(255) | NO | UNI | NULL | |
| access_key | varchar(255) | NO | NULL | ||
| encoding | varchar(255) | NO | NULL | ||
| file_format | varchar(255) | NO | NULL | ||
| include_variants | tinyint(1) | YES | 0 | ||
| generate_by_cronjob | tinyint(1) | NO | 0 | ||
| generated_at | datetime(3) | YES | NULL | ||
| interval | int(11) | NO | NULL | ||
| header_template | longtext | YES | NULL | ||
| body_template | longtext | YES | NULL | ||
| footer_template | longtext | YES | NULL | ||
| created_at | datetime(3) | NO | NULL | ||
| updated_at | datetime(3) | YES | NULL | ||
| currency_id | binary(16) | NO | NULL | ||
| paused_schedule | tinyint(1) | YES | 0 |
Indexes (6)
| Name | Columns | Unique |
|---|---|---|
| file_name | file_name | Yes |
| fk.product_export.product_stream_id | product_stream_id | No |
| fk.product_export.sales_channel_domain_id | sales_channel_domain_id | No |
| fk.product_export.sales_channel_id | sales_channel_id | No |
| fk.product_export.storefront_sales_channel_id | storefront_sales_channel_id | No |
| PRIMARY | id | Yes |