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

InnoDB free: 748544 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_list_subscribers`
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_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


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