Shopware 5.7.9 s_campaigns_maildata
Additional subscriber data for newsletter personalization.
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| email | varchar(255) | NO | Index |
| groupID | int(11) unsigned | NO | |
| salutation | varchar(255) | YES | |
| title | varchar(255) | YES | |
| firstname | varchar(255) | YES | |
| lastname | varchar(255) | YES | |
| street | varchar(255) | YES | |
| zipcode | varchar(255) | YES | |
| city | varchar(255) | YES | |
| added | datetime | NO | |
| double_optin_confirmed | datetime | YES | |
| deleted | datetime | YES | |
| Index Name | Columns | Unique |
| email | email,groupID | Yes |
| PRIMARY | id | Yes |
