Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_stats_newslettersemail_stats_newsletters
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

InnoDB free: 727040 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_stats_newsletters`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport