| id |
int(10)
|
|
|
|
| userID |
int(11)
|
|
|
|
| name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| custom_fields |
longtext
|
utf8mb4_unicode_ci
|
|
|
| list |
int(11)
|
|
|
|
| unsubscribed |
int(11)
|
|
|
|
| bounced |
int(11)
|
|
|
|
| bounce_soft |
int(11)
|
|
|
|
| complaint |
int(11)
|
|
|
|
| last_campaign |
int(11)
|
|
|
|
| last_ares |
int(11)
|
|
|
|
| timestamp |
int(11)
|
|
|
|
| join_date |
int(11)
|
|
|
|
| confirmed |
int(11)
|
|
|
|
| messageID |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| ip |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(2)
|
utf8mb4_unicode_ci
|
|
|
| referrer |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| method |
int(11)
|
|
|
|
| added_via |
int(11)
|
|
|
|
| gdpr |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| sb_list_cleaning_state |
int(11)
|
|
|
|