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 :
|