Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 01:54 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_list_subscribers` PROCEDURE ANALYSE();
Rows: 16
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.email_list_subscribers.subscriberid | 1 | 36581 | 1 | 5 | 0 | 0 | 18295.3961 | 10569.8837 | SMALLINT(5) UNSIGNED NOT NULL |
puroparty.email_list_subscribers.listid | 1 | 18 | 1 | 2 | 0 | 0 | 7.1876 | 6.0020 | ENUM('1','2','5','6','8','9','10','11','12','13','... |
puroparty.email_list_subscribers.emailaddress | 01@aol.com | _gloria@hotmail.com | 7 | 69 | 0 | 0 | 22.2158 | NULL | VARCHAR(69) NOT NULL |
puroparty.email_list_subscribers.domainname | @002mag.com | @zxy321.us | 6 | 35 | 0 | 0 | 12.3545 | NULL | VARCHAR(35) NOT NULL |
puroparty.email_list_subscribers.format | h | h | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('h') NOT NULL |
puroparty.email_list_subscribers.confirmed | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('1') NOT NULL |
puroparty.email_list_subscribers.confirmcode | 00014a6f7db7fb8865f3a5299c0009dc | fffe6a710c9483a6913b965514790488 | 32 | 32 | 0 | 0 | 32.0000 | NULL | CHAR(32) NOT NULL |
puroparty.email_list_subscribers.requestdate | 1219288837 | 1269645481 | 10 | 10 | 0 | 0 | 1239987594.2783 | 0.0000 | INT(10) UNSIGNED NOT NULL |
puroparty.email_list_subscribers.requestip | 0 | 0 | 36506 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.email_list_subscribers.confirmdate | 1219293614 | 1269645481 | 10 | 10 | 0 | 0 | 1236417932.4126 | 14856892.1253 | INT(10) UNSIGNED NOT NULL |
puroparty.email_list_subscribers.confirmip | Unknown IP Address | 0 | 18 | 31260 | 0 | 2.5866 | NULL | ENUM('','Unknown IP Address') NOT NULL | |
puroparty.email_list_subscribers.subscribedate | 1219288837 | 1269645481 | 10 | 10 | 0 | 0 | 1236416899.6520 | 14771511.3638 | INT(10) UNSIGNED NOT NULL |
puroparty.email_list_subscribers.bounced | 0 | 0 | 1 | 1 | 36506 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.email_list_subscribers.unsubscribed | 0 | 1291769744 | 1 | 10 | 36211 | 0 | 10033664.8079 | 0.0000 | INT(10) UNSIGNED NOT NULL |
puroparty.email_list_subscribers.unsubscribeconfir... | 0 | 1 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0','1') NOT NULL |
puroparty.email_list_subscribers.formid | 0 | 0 | 1 | 1 | 36506 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |