mysql.puroparty.com
puroparty
email_lists
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: email_lists
|
| Field | Type | Null | Default |
|---|---|---|---|
| listid | int(11) | No | |
| name | varchar(255) | Yes | NULL |
| ownername | varchar(255) | Yes | NULL |
| owneremail | varchar(100) | Yes | NULL |
| bounceemail | varchar(100) | Yes | NULL |
| replytoemail | varchar(100) | Yes | NULL |
| bounceserver | varchar(100) | Yes | NULL |
| bounceusername | varchar(100) | Yes | NULL |
| bouncepassword | varchar(100) | Yes | NULL |
| extramailsettings | varchar(100) | Yes | NULL |
| companyname | varchar(255) | Yes | NULL |
| companyaddress | varchar(255) | Yes | NULL |
| companyphone | varchar(20) | Yes | NULL |
| format | char(1) | Yes | NULL |
| notifyowner | char(1) | Yes | 0 |
| imapaccount | char(1) | Yes | 0 |
| createdate | int(11) | Yes | 0 |
| subscribecount | int(11) | Yes | 0 |
| unsubscribecount | int(11) | Yes | 0 |
| bouncecount | int(11) | Yes | 0 |
| processbounce | char(1) | Yes | 0 |
| agreedelete | char(1) | Yes | 0 |
| visiblefields | text | No | |
| ownerid | int(11) | Yes | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 16 | listid | |
| listid_2 | UNIQUE | 16 | listid | |
| listid_4 | UNIQUE | 16 | listid | |
| listid_6 | UNIQUE | 16 | listid | |
| name_2 | UNIQUE | 16 | name | |
| createdate_2 | UNIQUE | 16 | createdate | |
| name_3 | UNIQUE | 16 | name | |
| createdate_3 | UNIQUE | 16 | createdate | |
| createdate_5 | UNIQUE | 16 | createdate | |
| email_lists_owner_idx | INDEX | 2 | ownerid | |
| listid | INDEX | 16 | listid | |
| name | INDEX | 16 | name | |
| ownername | INDEX | 8 | ownername | |
| owneremail | INDEX | 4 | owneremail | |
| bounceemail | INDEX | 4 | bounceemail | |
| replytoemail | INDEX | 4 | replytoemail | |
| bounceserver | INDEX | 4 | bounceserver | |
| bounceusername | INDEX | 4 | bounceusername | |
| bouncepassword | INDEX | 4 | bouncepassword | |
| extramailsettings | INDEX | 2 | extramailsettings | |
| companyname | INDEX | 4 | companyname | |
| companyaddress | INDEX | 8 | companyaddress | |
| companyphone | INDEX | 4 | companyphone | |
| format | INDEX | 2 | format | |
| notifyowner | INDEX | 4 | notifyowner | |
| imapaccount | INDEX | 2 | imapaccount | |
| createdate | INDEX | 16 | createdate | |
| subscribecount | INDEX | 16 | subscribecount | |
| unsubscribecount | INDEX | 16 | unsubscribecount | |
| bouncecount | INDEX | 2 | bouncecount | |
| processbounce | INDEX | 4 | processbounce | |
| agreedelete | INDEX | 4 | agreedelete | |
| ownerid | INDEX | 2 | ownerid | |
| replytoemail_2 | INDEX | 4 | replytoemail | |
| bounceemail_2 | INDEX | 4 | bounceemail | |
| companyname_2 | INDEX | 4 | companyname | |
| extramailsettings_2 | INDEX | 2 | extramailsettings | |
| processbounce_2 | INDEX | 4 | processbounce | |
| unsubscribecount_2 | INDEX | 16 | unsubscribecount | |
| bouncecount_2 | INDEX | 2 | bouncecount | |
| bouncepassword_2 | INDEX | 4 | bouncepassword | |
| ownerid_2 | INDEX | 2 | ownerid | |
| bounceusername_2 | INDEX | 4 | bounceusername | |
| companyaddress_2 | INDEX | 8 | companyaddress | |
| name_4 | INDEX | 16 | name | |
| listid_3 | INDEX | 16 | listid | |
| agreedelete_2 | INDEX | 4 | agreedelete | |
| ownername_2 | INDEX | 8 | ownername | |
| bounceserver_2 | INDEX | 4 | bounceserver | |
| owneremail_2 | INDEX | 4 | owneremail | |
| subscribecount_2 | INDEX | 16 | subscribecount | |
| format_2 | INDEX | 2 | format | |
| notifyowner_2 | INDEX | 4 | notifyowner | |
| createdate_4 | INDEX | 16 | createdate | |
| companyphone_2 | INDEX | 4 | companyphone | |
| imapaccount_2 | INDEX | 2 | imapaccount | |
| bounceserver_3 | INDEX | 4 | bounceserver | |
| listid_5 | INDEX | 16 | listid | |
| replytoemail_3 | INDEX | 4 | replytoemail | |
| extramailsettings_3 | INDEX | 2 | extramailsettings | |
| bounceusername_3 | INDEX | 4 | bounceusername | |
| name_5 | INDEX | 16 | name | |
| ownerid_3 | INDEX | 2 | ownerid | |
| bounceemail_3 | INDEX | 4 | bounceemail | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||