Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 03:03 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 |