Shopware 5.7.6 s_campaigns_mailaddresses
Newsletter subscriber email addresses and opt-in status.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| customer | int(1) | NO | |
| groupID | int(11) | NO | Index |
| email | varchar(90) | NO | Index |
| lastmailing | int(11) | NO | Index |
| lastread | int(11) | NO | Index |
| added | datetime | YES | |
| double_optin_confirmed | datetime | YES | |
| Index Name | Columns | Unique |
| email | email | No |
| groupID | groupID | No |
| lastmailing | lastmailing | No |
| lastread | lastread | No |
| PRIMARY | id | Yes |
