mysql.puroparty.com
puroparty
email_list_subscribers
| 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 | 3018 | subscribedate | |
| subscriberid | INDEX | 36218 | subscriberid | |
| listid | INDEX | 77 | listid | |
| emailaddress | INDEX | 36218 | emailaddress | |
| domainname | INDEX | 12072 | domainname | |
| format | INDEX | 1 | format | |
| confirmed | INDEX | 1 | confirmed | |
| confirmcode | INDEX | 36218 | confirmcode | |
| requestdate | INDEX | 2786 | requestdate | |
| requestip | INDEX | 1 | requestip | |
| confirmdate | INDEX | 1810 | confirmdate | |
| confirmip | INDEX | 1 | confirmip | |
| confirmip_2 | INDEX | 9 | confirmip | |
| subscribedate | INDEX | 2263 | subscribedate | |
| bounced | INDEX | 1 | bounced | |
| unsubscribed | INDEX | 1 | unsubscribed | |
| unsubscribeconfirmed | INDEX | 1 | unsubscribeconfirmed | |
| formid | INDEX | 1 | formid | |
| emailaddress_2 | INDEX | 36218 | emailaddress | |
| requestip_2 | INDEX | 1 | requestip | |
| listid_2 | INDEX | 77 | listid | |
| confirmip_3 | INDEX | 9 | confirmip | |
| subscribedate_2 | INDEX | 3018 | subscribedate | |
| format_2 | INDEX | 1 | format | |
| confirmed_2 | INDEX | 1 | confirmed | |
| requestdate_2 | INDEX | 3621 | requestdate | |
| subscriberid_3 | INDEX | 36218 | subscriberid | |
| unsubscribed_2 | INDEX | 1 | unsubscribed | |
| unsubscribeconfirmed_2 | INDEX | 1 | unsubscribeconfirmed | |
| confirmdate_2 | INDEX | 2012 | confirmdate | |
| formid_2 | INDEX | 1 | formid | |
| domainname_2 | INDEX | 12072 | 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 | 29 | listid | |
| subscribedate_3 | INDEX | 2263 | subscribedate | |
| confirmip_5 | INDEX | 1 | 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 | 2012 | confirmdate | |
| formid_3 | INDEX | 1 | formid | |
| bounced_3 | INDEX | 1 | bounced | |
| domainname_3 | INDEX | 7243 | domainname | |
| confirmcode_6 | INDEX | 36218 | confirmcode | |
| subscribedate_4 | INDEX | 3292 | subscribedate | |
| confirmcode_7 | INDEX | 36218 | confirmcode | |
| bounced_4 | INDEX | 1 | bounced | |
| confirmed_4 | INDEX | 1 | confirmed | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||