Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 11:13 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_stats_emailopens` PROCEDURE ANALYSE();
Rows: 7
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 |