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

InnoDB free: 739328 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_lists`
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_lists.listid 1 18 1 2 0 0 10.2500 5.0187 ENUM('1','2','5','6','7','8','9','10','11','12','1...
puroparty.email_lists.name chuly stuff test list 1 7 28 0 0 16.1875 NULL ENUM('chuly stuff','Copy of PuroParty Newsletter',...
puroparty.email_lists.ownername pp robert 2 16 0 0 11.8750 NULL ENUM('pp','PuroParty','Puroparty Events','robert')...
puroparty.email_lists.owneremail events@puroparty.com ppcru@puroparty.com 19 20 0 0 19.6250 NULL ENUM('events@puroparty.com','ppcru@puroparty.com')...
puroparty.email_lists.bounceemail events@puroparty.com ppcru@puroparty.com 19 20 0 0 19.6875 NULL ENUM('events@puroparty.com','ppcru@puroparty.com')...
puroparty.email_lists.replytoemail events@puroparty.com ppcru@puroparty.com 19 20 0 0 19.6250 NULL ENUM('events@puroparty.com','ppcru@puroparty.com')...
puroparty.email_lists.bounceserver   aspmx.l.google.com. 0 19 15 0 1.1875 NULL ENUM('','aspmx.l.google.com.') NOT NULL
puroparty.email_lists.bounceusername   robert 0 6 15 0 0.3750 NULL ENUM('','robert') NOT NULL
puroparty.email_lists.bouncepassword   bWlzZXJ5MQ== 0 12 15 0 0.7500 NULL ENUM('','bWlzZXJ5MQ==') NOT NULL
puroparty.email_lists.extramailsettings     0 0 16 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.email_lists.companyname PuroParty PuroParty 9 9 2 0 7.8750 NULL ENUM('','PuroParty') NOT NULL
puroparty.email_lists.companyaddress P.O. Box 6, South Houston, TX 77587 PO Box 6, South Houston, TX 77587 8 35 10 0 9.3750 NULL ENUM('','P.O. Box 6, South Houston, TX 77587','PO ...
puroparty.email_lists.companyphone 713-645-8400 713-645-8400 12 12 13 0 2.2500 NULL ENUM('','713-645-8400') NOT NULL
puroparty.email_lists.format b b 1 1 0 0 1.0000 NULL ENUM('b') NOT NULL
puroparty.email_lists.notifyowner 0 1 1 1 0 0 1.0000 NULL ENUM('0','1') NOT NULL
puroparty.email_lists.imapaccount 0 0 1 1 0 0 1.0000 NULL ENUM('0') NOT NULL
puroparty.email_lists.createdate 1219288757 1269645257 10 10 0 0 1256170440.5625 657789760.2643 ENUM('1219288757','1219791843','1237445094','12374...
puroparty.email_lists.subscribecount 3 18811 1 5 1 0 2263.1250 4740.2446 ENUM('0','3','4','424','472','498','510','522','52...
puroparty.email_lists.unsubscribecount 0 277 1 3 9 0 18.5000 66.8066 ENUM('0','1','3','12','277') NOT NULL
puroparty.email_lists.bouncecount 0 0 1 1 16 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.email_lists.processbounce 0 1 1 1 0 0 1.0000 NULL ENUM('0','1') NOT NULL
puroparty.email_lists.agreedelete 0 1 1 1 0 0 1.0000 NULL ENUM('0','1') NOT NULL
puroparty.email_lists.visiblefields emailaddress,subscribedate,format,status,confirmed emailaddress,subscribedate,format,status,confirmed 50 50 0 0 50.0000 NULL ENUM('emailaddress,subscribedate,format,status,con...
puroparty.email_lists.ownerid 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL


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