Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.email_jobs.jobid |
1 |
75 |
1 |
2 |
0 |
0 |
38.4638 |
21.7799 |
TINYINT(2) UNSIGNED NOT NULL |
puroparty.email_jobs.jobtype |
send |
send |
4 |
4 |
0 |
0 |
4.0000 |
NULL |
ENUM('send') NOT NULL |
puroparty.email_jobs.jobstatus |
c |
p |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('c','i','p') NOT NULL |
puroparty.email_jobs.jobtime |
1219292572 |
1269646401 |
10 |
10 |
0 |
0 |
1248072816.0290 |
0.0000 |
INT(10) UNSIGNED NOT NULL |
puroparty.email_jobs.jobdetails |
a:19:{s:16:"NewsletterChosen";i:0;s:5:"Lists";a:1:... |
a:22:{s:16:"NewsletterChosen";i:0;s:5:"Lists";a:1:... |
641 |
774 |
0 |
0 |
694.4058 |
NULL |
TEXT NOT NULL |
puroparty.email_jobs.fkid |
1 |
30 |
1 |
2 |
0 |
0 |
19.3478 |
9.4743 |
ENUM('1','2','3','4','7','9','10','11','12','13','... |
puroparty.email_jobs.lastupdatetime |
1219292606 |
1269646414 |
10 |
10 |
0 |
0 |
1248076528.6087 |
0.0000 |
INT(10) UNSIGNED NOT NULL |
puroparty.email_jobs.fktype |
newsletter |
newsletter |
10 |
10 |
0 |
0 |
10.0000 |
NULL |
ENUM('newsletter') NOT NULL |
puroparty.email_jobs.queueid |
2 |
77 |
1 |
2 |
0 |
0 |
39.9855 |
22.2095 |
TINYINT(2) UNSIGNED NOT NULL |
puroparty.email_jobs.ownerid |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.email_jobs.approved |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.email_jobs.authorisedtosend |
0 |
0 |
1 |
1 |
69 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_jobs.resendcount |
0 |
1 |
1 |
1 |
68 |
0 |
0.0145 |
0.1195 |
ENUM('0','1') NOT NULL |