Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 08:45 PM
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','1220654581','1220857911','1224278516','1224914530','1229004870','1237430413','1237438448','1237438815','1237445868','1237455211','1237460768','1237460988','1237508445','1237988074','1237988346','1238023609','1240303703','1240304617','1240356606','1240386172','1241596950','1241597489','1241604812','1241652484','1244022558','1244072544','1244623446','1244623874','1244699663','1255042509','1255046583','1255047047','1255047366','1255047697','1255048394','1255055071','1258677344','1258678050','1258678578','1258678994','1258679671','1258680729','1258702719','1258717700','1269578674','1269580180','1269581141','1269586676','1269589163','1269595580','1269625581','1269643708','1269644501','1269646873') NOT NULL |
| 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.multipartrecipients | 1 | 19145 | 1 | 5 | 0 | 0 | 2969.5942 | 6385.4569 | ENUM('1','2','3','4','5','8','29','43','58','59','69','103','142','153','329','425','456','472','489','499','510','522','532','540','945','1049','1527','5241','5246','5779','7613','18843','18964','19005','19040','19091','19138','19142','19145') NOT NULL |
| 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_unknown | 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','51','55') NOT NULL |
| 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','14','15','17','21','22','24','27','28','29','30') NOT NULL |
| puroparty.email_stats_newsletters.sendfromname | pp | robert | 2 | 16 | 0 | 0 | 10.1159 | NULL | ENUM('pp','ppevents','PuroParty','PuroParty Events','robert') NOT NULL |
| 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@puroparty.com') NOT NULL |
| 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@puroparty.com') NOT NULL |
| 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@puroparty.com') NOT NULL |
| 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;s:1:"1";}s:6:"Status";s:1:"a";} | N; | 2 | 118 | 0 | 0 | 75.1449 | NULL | ENUM('a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"5";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"8";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"9";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"10";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"11";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"12";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"13";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"14";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"15";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:2:"16";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:2:{i:0;s:1:"5";i:1;s:1:"2";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:2:{i:0;s:1:"6";i:1;s:1:"1";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:2:{i:0;s:2:"17";i:1;s:2:"18";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:3:{i:0;s:1:"5";i:1;s:1:"2";i:2;s:1:"1";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:3:{i:0;s:1:"5";i:1;s:1:"6";i:2;s:1:"1";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:3:{i:0;s:1:"5";i:1;s:1:"6";i:2;s:1:"2";}s:6:"Status";s:1:"a";}','a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:4:{i:0;s:1:"5";i:1;s:1:"6";i:2;s:1:"2";i:3;s:1:"1";}s:6:"Status";s:1:"a";}','N;') NOT NULL |
| 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','425','472','499','510','522','532','540','748','1049','1139','2810','5241','5246','7613','18812','18844','18965','19005','19040','19091','19138','19139','19142','19145','19151') NOT NULL |
| 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','58','70','83','190','232','234','239','319','323','353','369','526','838') NOT NULL |
| 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','22','32','33','34','39','42','46','57','64','69','111','301','453','641','700','753','1641','1979','2131','2432','2537','2981','3061','3206','3758') NOT NULL |
| puroparty.email_stats_newsletters.emailforwards | 0 | 0 | 1 | 1 | 69 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.email_stats_newsletters.emailopens_unique | 1 | 1770 | 1 | 4 | 0 | 0 | 227.3478 | 503.0870 | ENUM('1','2','3','4','6','8','10','11','12','16','22','24','25','27','31','32','33','38','42','65','179','290','380','413','587','1028','1107','1317','1427','1549','1609','1716','1766','1770') NOT NULL |
| 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','22','32','33','34','39','42','46','57','64','69','111','301','453','641','700','753','1641','1979','2131','2431','2537','2981','3060','3206','3758') NOT NULL |
| 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','22','24','25','27','31','32','33','38','42','65','179','290','380','413','587','1028','1107','1317','1427','1548','1609','1716','1765','1770') NOT NULL |
| 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 |