Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 16, 2024 at 08:06 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','13','14','15','16','17','18') NOT NULL |
puroparty.email_lists.name | chuly stuff | test list 1 | 7 | 28 | 0 | 0 | 16.1875 | NULL | ENUM('chuly stuff','Copy of PuroParty Newsletter','just me','puroparty main clean','PuroParty Newsletter','puroparty subs 1','puroparty subs 100','puroparty subs 2','puroparty subs 3','puroparty subs 4','puroparty subs 5','puroparty subs 6','puroparty subs 7','puroparty subs 8','puroparty subs 9','test list 1') NOT NULL |
puroparty.email_lists.ownername | pp | robert | 2 | 16 | 0 | 0 | 11.8750 | NULL | ENUM('pp','PuroParty','Puroparty Events','robert') NOT NULL |
puroparty.email_lists.owneremail | events@puroparty.com | ppcru@puroparty.com | 19 | 20 | 0 | 0 | 19.6250 | NULL | ENUM('events@puroparty.com','ppcru@puroparty.com') NOT NULL |
puroparty.email_lists.bounceemail | events@puroparty.com | ppcru@puroparty.com | 19 | 20 | 0 | 0 | 19.6875 | NULL | ENUM('events@puroparty.com','ppcru@puroparty.com') NOT NULL |
puroparty.email_lists.replytoemail | events@puroparty.com | ppcru@puroparty.com | 19 | 20 | 0 | 0 | 19.6250 | NULL | ENUM('events@puroparty.com','ppcru@puroparty.com') NOT NULL |
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 Box 6','PO Box 6, South Houston, TX 77587') NOT NULL |
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','1237455085','1244080213','1244621097','1269566894','1269570081','1269581373','1269586122','1269594489','1269596582','1269626307','1269632651','1269645204','1269645257') NOT NULL |
puroparty.email_lists.subscribecount | 3 | 18811 | 1 | 5 | 1 | 0 | 2263.1250 | 4740.2446 | ENUM('0','3','4','424','472','498','510','522','526','532','539','5234','7610','18811') NOT NULL |
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,confirmed') NOT NULL |
puroparty.email_lists.ownerid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |