Shopware 5.7.12 s_campaigns_mailings
Newsletter mailing definitions — subject, sender, schedule, and assigned content.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| datum | date | YES | |
| groups | mediumtext | NO | |
| subject | varchar(100) | NO | |
| sendermail | varchar(255) | NO | |
| sendername | varchar(255) | NO | |
| plaintext | int(1) | NO | |
| templateID | int(11) | NO | Default: 0 |
| languageID | int(11) | NO | |
| status | int(11) | NO | Default: 0 |
| locked | datetime | YES | |
| recipients | int(11) | NO | |
| read | int(11) | NO | Default: 0 |
| clicked | int(11) | NO | Default: 0 |
| customergroup | varchar(15) | YES | |
| publish | int(1) unsigned | NO | |
| timed_delivery | datetime | YES | |
| Index Name | Columns | Unique |
| PRIMARY | id | Yes |
