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

InnoDB free: 739328 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_stats_emailopens`
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_emailopens.openid 1 27388 1 5 0 0 13694.5000 7906.2346 SMALLINT(5) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.subscriberid 1 36538 1 5 1 0 9267.8043 7311.6554 SMALLINT(5) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.statid 2 76 1 2 0 0 28.5174 15.6613 TINYINT(2) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.opentime 1219292628 1706722174 10 10 0 0 1240108954.9373 0.0000 INT(10) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.openip 10.0.1.16 99.9.72.70 8 15 1921 0 12.1585 NULL VARCHAR(15) NOT NULL
puroparty.email_stats_emailopens.fromlink 0 1 1 1 0 0 1.0000 NULL ENUM('0','1') NOT NULL
puroparty.email_stats_emailopens.opentype h h 1 1 0 0 1.0000 NULL ENUM('h') NOT NULL


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