Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_stats_emailopensemail_stats_emailopens

InnoDB free: 780288 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 27359 1 5 0 0 13680.0000 7897.8630 SMALLINT(5) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.subscriberid 1 36538 1 5 0 0 9262.6918 7308.4204 SMALLINT(5) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.statid 2 76 1 2 0 0 28.5143 15.6588 TINYINT(2) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.opentime 1219292628 1505266319 10 10 0 0 1239648711.7296 16994021.6907 INT(10) UNSIGNED NOT NULL
puroparty.email_stats_emailopens.openip 10.0.1.16 99.9.72.70 8 15 1892 0 12.1714 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