Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 08, 2024 at 07:29 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_stats_newsletters` PROCEDURE ANALYSE();
Rows: 34
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 |