Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.email_stats_newsletters.statid |
2 |
76 |
1 |
2 |
0 |
0 |
39.4638 |
21.7799 |
TINYINT(2) UNSIGNED NOT NULL |
puroparty.email_stats_newsletters.queueid |
2 |
77 |
1 |
2 |
0 |
0 |
39.9855 |
22.2095 |
TINYINT(2) UNSIGNED NOT NULL |
puroparty.email_stats_newsletters.jobid |
1 |
75 |
1 |
2 |
0 |
0 |
38.4638 |
21.7799 |
TINYINT(2) UNSIGNED NOT NULL |
puroparty.email_stats_newsletters.starttime |
1219292572 |
1269646402 |
10 |
10 |
0 |
0 |
1248072818.5217 |
0.0000 |
INT(10) UNSIGNED NOT NULL |
puroparty.email_stats_newsletters.finishtime |
1219292608 |
1269646873 |
10 |
10 |
12 |
0 |
1030338185.2174 |
0.0000 |
ENUM('0','1219292608','1219293739','1220653593','1... |
puroparty.email_stats_newsletters.htmlrecipients |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.textrecipients |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.multipartrecipie... |
1 |
19145 |
1 |
5 |
0 |
0 |
2969.5942 |
6385.4569 |
ENUM('1','2','3','4','5','8','29','43','58','59','... |
puroparty.email_stats_newsletters.trackopens |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_stats_newsletters.tracklinks |
0 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('0','1') NOT NULL |
puroparty.email_stats_newsletters.bouncecount_soft |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.bouncecount_hard |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.bouncecount_unkn... |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.unsubscribecount |
0 |
55 |
1 |
2 |
50 |
0 |
4.3043 |
12.3785 |
ENUM('0','1','3','4','5','6','30','38','40','46','... |
puroparty.email_stats_newsletters.newsletterid |
1 |
30 |
1 |
2 |
0 |
0 |
19.3478 |
9.4743 |
ENUM('1','2','3','4','7','9','10','11','12','13','... |
puroparty.email_stats_newsletters.sendfromname |
pp |
robert |
2 |
16 |
0 |
0 |
10.1159 |
NULL |
ENUM('pp','ppevents','PuroParty','PuroParty Events... |
puroparty.email_stats_newsletters.sendfromemail |
events@puroparty.com |
puroparty@puroparty.com |
19 |
23 |
0 |
0 |
19.7246 |
NULL |
ENUM('events@puroparty.com','ppcru@puroparty.com',... |
puroparty.email_stats_newsletters.bounceemail |
events@puroparty.com |
puroparty@puroparty.com |
19 |
23 |
0 |
0 |
19.5362 |
NULL |
ENUM('events@puroparty.com','ppcru@puroparty.com',... |
puroparty.email_stats_newsletters.replytoemail |
events@puroparty.com |
puroparty@puroparty.com |
19 |
23 |
0 |
0 |
19.7246 |
NULL |
ENUM('events@puroparty.com','ppcru@puroparty.com',... |
puroparty.email_stats_newsletters.charset |
UTF-8 |
UTF-8 |
5 |
5 |
0 |
0 |
5.0000 |
NULL |
ENUM('UTF-8') NOT NULL |
puroparty.email_stats_newsletters.sendinformation |
a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0... |
N; |
2 |
118 |
0 |
0 |
75.1449 |
NULL |
ENUM('a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:... |
puroparty.email_stats_newsletters.sendsize |
1 |
19151 |
1 |
5 |
0 |
0 |
4308.1159 |
7546.6208 |
ENUM('1','2','3','4','5','8','69','142','329','388... |
puroparty.email_stats_newsletters.sentby |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.email_stats_newsletters.notifyowner |
0 |
0 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.linkclicks |
0 |
838 |
1 |
3 |
27 |
0 |
57.0725 |
144.3980 |
ENUM('0','1','2','3','4','5','6','8','9','11','16'... |
puroparty.email_stats_newsletters.emailopens |
1 |
3758 |
1 |
4 |
0 |
0 |
396.9565 |
909.6005 |
ENUM('1','2','3','6','8','10','11','12','13','19',... |
puroparty.email_stats_newsletters.emailforwards |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.emailopens_uniqu... |
1 |
1770 |
1 |
4 |
0 |
0 |
227.3478 |
503.0870 |
ENUM('1','2','3','4','6','8','10','11','12','16','... |
puroparty.email_stats_newsletters.htmlopens |
1 |
3758 |
1 |
4 |
0 |
0 |
396.9275 |
909.5256 |
ENUM('1','2','3','6','8','10','11','12','13','19',... |
puroparty.email_stats_newsletters.htmlopens_unique |
1 |
1770 |
1 |
4 |
0 |
0 |
227.3188 |
503.0047 |
ENUM('1','2','3','4','6','8','10','11','12','16','... |
puroparty.email_stats_newsletters.textopens |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.textopens_unique |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_stats_newsletters.hiddenby |
0 |
1 |
1 |
1 |
67 |
0 |
0.0290 |
0.1678 |
ENUM('0','1') NOT NULL |
puroparty.email_stats_newsletters.sendtestmode |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |