Server: mysql.puroparty.com | Database: puroparty | Table: email_list_subscribers |
Field | Type | Null | Default |
---|---|---|---|
subscriberid | int(11) | No | |
listid | int(11) | No | 0 |
emailaddress | varchar(200) | Yes | NULL |
domainname | varchar(100) | Yes | NULL |
format | char(1) | Yes | NULL |
confirmed | char(1) | Yes | 0 |
confirmcode | varchar(32) | Yes | NULL |
requestdate | int(11) | Yes | 0 |
requestip | varchar(20) | Yes | NULL |
confirmdate | int(11) | Yes | 0 |
confirmip | varchar(20) | Yes | NULL |
subscribedate | int(11) | Yes | 0 |
bounced | int(11) | Yes | 0 |
unsubscribed | int(11) | Yes | 0 |
unsubscribeconfirmed | char(1) | Yes | 0 |
formid | int(11) | Yes | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 36218 | subscriberid | |
subscriberid_2 | UNIQUE | 36218 | subscriberid | |
subscriberid_4 | UNIQUE | 36218 | subscriberid | |
subscriberid_6 | UNIQUE | 36218 | subscriberid | |
email_subscribers_email_list_idx | UNIQUE | 36218 | emailaddress | |
listid | ||||
confirmcode_2 | UNIQUE | 36218 | confirmcode | |
confirmcode_3 | UNIQUE | 36218 | confirmcode | |
confirmcode_5 | UNIQUE | 36218 | confirmcode | |
email_list_subscribers_sub_list_idx | INDEX | 36218 | subscriberid | |
listid | ||||
email_subscribe_date_idx | INDEX | 2414 | subscribedate | |
subscriberid | INDEX | 36218 | subscriberid | |
listid | INDEX | 59 | listid | |
emailaddress | INDEX | 36218 | emailaddress | |
domainname | INDEX | 6036 | domainname | |
format | INDEX | 1 | format | |
confirmed | INDEX | 1 | confirmed | |
confirmcode | INDEX | 36218 | confirmcode | |
requestdate | INDEX | 3621 | requestdate | |
requestip | INDEX | 1 | requestip | |
confirmdate | INDEX | 2263 | confirmdate | |
confirmip | INDEX | 9 | confirmip | |
confirmip_2 | INDEX | 1 | confirmip | |
subscribedate | INDEX | 4024 | subscribedate | |
bounced | INDEX | 1 | bounced | |
unsubscribed | INDEX | 31 | unsubscribed | |
unsubscribeconfirmed | INDEX | 9 | unsubscribeconfirmed | |
formid | INDEX | 1 | formid | |
emailaddress_2 | INDEX | 36218 | emailaddress | |
requestip_2 | INDEX | 1 | requestip | |
listid_2 | INDEX | 59 | listid | |
confirmip_3 | INDEX | 1 | confirmip | |
subscribedate_2 | INDEX | 2786 | subscribedate | |
format_2 | INDEX | 1 | format | |
confirmed_2 | INDEX | 1 | confirmed | |
requestdate_2 | INDEX | 2786 | requestdate | |
subscriberid_3 | INDEX | 36218 | subscriberid | |
unsubscribed_2 | INDEX | 1 | unsubscribed | |
unsubscribeconfirmed_2 | INDEX | 1 | unsubscribeconfirmed | |
confirmdate_2 | INDEX | 3018 | confirmdate | |
formid_2 | INDEX | 1 | formid | |
domainname_2 | INDEX | 9054 | domainname | |
confirmcode_4 | INDEX | 36218 | confirmcode | |
bounced_2 | INDEX | 1 | bounced | |
confirmip_4 | INDEX | 1 | confirmip | |
requestip_3 | INDEX | 1 | requestip | |
emailaddress_3 | INDEX | 36218 | emailaddress | |
listid_3 | INDEX | 9 | listid | |
subscribedate_3 | INDEX | 3292 | subscribedate | |
confirmip_5 | INDEX | 9 | confirmip | |
confirmed_3 | INDEX | 1 | confirmed | |
unsubscribed_3 | INDEX | 31 | unsubscribed | |
subscriberid_5 | INDEX | 36218 | subscriberid | |
unsubscribeconfirmed_3 | INDEX | 1 | unsubscribeconfirmed | |
format_3 | INDEX | 1 | format | |
requestdate_3 | INDEX | 2414 | requestdate | |
confirmdate_3 | INDEX | 3292 | confirmdate | |
formid_3 | INDEX | 1 | formid | |
bounced_3 | INDEX | 1 | bounced | |
domainname_3 | INDEX | 12072 | domainname | |
confirmcode_6 | INDEX | 36218 | confirmcode | |
subscribedate_4 | INDEX | 1906 | subscribedate | |
confirmcode_7 | INDEX | 36218 | confirmcode | |
bounced_4 | INDEX | 1 | bounced | |
confirmed_4 | INDEX | 1 | confirmed |
Space usage :
|
Row Statistic :
|