Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 06:19 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_stats_linkclicks` PROCEDURE ANALYSE();
Rows: 6
| 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_linkclicks.clickid | 1 | 3938 | 1 | 4 | 0 | 0 | 1969.5000 | 1136.8026 | SMALLINT(4) UNSIGNED NOT NULL |
| puroparty.email_stats_linkclicks.clicktime | 1220655327 | 1706722228 | 10 | 10 | 0 | 0 | 1241293937.9937 | 30767440.5730 | INT(10) UNSIGNED NOT NULL |
| puroparty.email_stats_linkclicks.clickip | 10.0.1.16 | 99.9.72.240 | 9 | 15 | 216 | 0 | 12.5122 | NULL | VARCHAR(15) NOT NULL |
| puroparty.email_stats_linkclicks.subscriberid | 1 | 36506 | 1 | 5 | 10 | 0 | 8037.6094 | 6897.4301 | SMALLINT(5) UNSIGNED NOT NULL |
| puroparty.email_stats_linkclicks.statid | 4 | 76 | 1 | 2 | 0 | 0 | 27.9472 | 14.7903 | ENUM('4','5','6','7','8','9','10','16','18','19','... |
| puroparty.email_stats_linkclicks.linkid | 1 | 34 | 1 | 2 | 0 | 0 | 13.8070 | 8.7622 | ENUM('1','2','3','4','5','6','7','9','11','12','13... |