Shopware 5.6.3 s_mail_log
Sent email log entries with subject, sender, timestamp, and delivery status.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| type_id | int(11) | YES | Index
Foreign Key → s_core_config_mails.id |
| order_id | int(11) | YES | Index
Foreign Key → s_order.id |
| shop_id | int(10) unsigned | YES | Index
Foreign Key → s_core_shops.id |
| subject | longtext | YES | |
| sender | varchar(255) | NO | |
| sent_at | datetime | NO | |
| content_html | longtext | YES | |
| content_text | longtext | YES | |
| Index Name | Columns | Unique |
| PRIMARY | id | Yes |
| s_mail_log_idx_order_id | order_id | No |
| s_mail_log_idx_shop_id | shop_id | No |
| s_mail_log_idx_type_id | type_id | No |
Relations (from this table)
3 relations
Relations (to this table)
2 relations
