| name |
varchar(100)
|
utf8mb4_unicode_520_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_unicode_520_ci
|
|
|
| token |
varchar(50)
|
utf8mb4_unicode_520_ci
|
|
|
| language |
varchar(10)
|
utf8mb4_unicode_520_ci
|
|
|
| status |
varchar(1)
|
utf8mb4_unicode_520_ci
|
|
|
| id |
int(11)
|
|
|
|
| profile |
mediumtext
|
utf8mb4_unicode_520_ci
|
|
|
| created |
timestamp
|
|
|
|
| updated |
int(11)
|
|
|
|
| last_activity |
int(11)
|
|
|
|
| followup_step |
tinyint(4)
|
|
|
|
| followup_time |
bigint(20)
|
|
|
|
| followup |
tinyint(4)
|
|
|
|
| surname |
varchar(100)
|
utf8mb4_unicode_520_ci
|
|
|
| sex |
char(1)
|
utf8mb4_unicode_520_ci
|
|
|
| feed_time |
bigint(20)
|
|
|
|
| feed |
tinyint(4)
|
|
|
|
| referrer |
varchar(50)
|
utf8mb4_unicode_520_ci
|
|
|
| ip |
varchar(50)
|
utf8mb4_unicode_520_ci
|
|
|
| wp_user_id |
int(11)
|
|
|
|
| http_referer |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| geo |
tinyint(4)
|
|
|
|
| country |
varchar(4)
|
utf8mb4_unicode_520_ci
|
|
|
| region |
varchar(100)
|
utf8mb4_unicode_520_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_520_ci
|
|
|
| bounce_type |
varchar(50)
|
utf8mb4_unicode_520_ci
|
|
|
| bounce_time |
int(11)
|
|
|
|
| unsub_email_id |
int(11)
|
|
|
|
| unsub_time |
int(11)
|
|
|
|
| list_1 |
tinyint(4)
|
|
|
|
| list_2 |
tinyint(4)
|
|
|
|
| list_3 |
tinyint(4)
|
|
|
|
| list_4 |
tinyint(4)
|
|
|
|
| list_5 |
tinyint(4)
|
|
|
|
| list_6 |
tinyint(4)
|
|
|
|
| list_7 |
tinyint(4)
|
|
|
|
| list_8 |
tinyint(4)
|
|
|
|
| list_9 |
tinyint(4)
|
|
|
|
| list_10 |
tinyint(4)
|
|
|
|
| list_11 |
tinyint(4)
|
|
|
|
| list_12 |
tinyint(4)
|
|
|
|
| list_13 |
tinyint(4)
|
|
|
|
| list_14 |
tinyint(4)
|
|
|
|
| list_15 |
tinyint(4)
|
|
|
|
| list_16 |
tinyint(4)
|
|
|
|
| list_17 |
tinyint(4)
|
|
|
|
| list_18 |
tinyint(4)
|
|
|
|
| list_19 |
tinyint(4)
|
|
|
|
| list_20 |
tinyint(4)
|
|
|
|
| list_21 |
tinyint(4)
|
|
|
|
| list_22 |
tinyint(4)
|
|
|
|
| list_23 |
tinyint(4)
|
|
|
|
| list_24 |
tinyint(4)
|
|
|
|
| list_25 |
tinyint(4)
|
|
|
|
| list_26 |
tinyint(4)
|
|
|
|
| list_27 |
tinyint(4)
|
|
|
|
| list_28 |
tinyint(4)
|
|
|
|
| list_29 |
tinyint(4)
|
|
|
|
| list_30 |
tinyint(4)
|
|
|
|
| list_31 |
tinyint(4)
|
|
|
|
| list_32 |
tinyint(4)
|
|
|
|
| list_33 |
tinyint(4)
|
|
|
|
| list_34 |
tinyint(4)
|
|
|
|
| list_35 |
tinyint(4)
|
|
|
|
| list_36 |
tinyint(4)
|
|
|
|
| list_37 |
tinyint(4)
|
|
|
|
| list_38 |
tinyint(4)
|
|
|
|
| list_39 |
tinyint(4)
|
|
|
|
| list_40 |
tinyint(4)
|
|
|
|
| profile_1 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_2 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_3 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_4 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_5 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_6 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_7 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_8 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_9 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_10 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_11 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_12 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_13 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_14 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_15 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_16 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_17 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_18 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_19 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| profile_20 |
varchar(255)
|
utf8mb4_unicode_520_ci
|
|
|
| test |
tinyint(4)
|
|
|
|
| source |
varchar(50)
|
utf8mb4_unicode_520_ci
|
|
|
