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