mysql.puroparty.com
puroparty
email_list_subscribers_unsubscribe
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: email_list_subscribers_unsubscribe
|
| Field | Type | Null | Default |
|---|---|---|---|
| subscriberid | int(11) | No | 0 |
| unsubscribetime | int(11) | No | 0 |
| unsubscribeip | varchar(20) | Yes | NULL |
| unsubscriberequesttime | int(11) | Yes | 0 |
| unsubscriberequestip | varchar(20) | Yes | NULL |
| listid | int(11) | No | 0 |
| statid | int(11) | Yes | 0 |
| unsubscribearea | varchar(20) | Yes | NULL |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 239 | subscriberid | |
| subscriberid_2 | UNIQUE | 239 | subscriberid | |
| unsubscribetime_2 | UNIQUE | 239 | unsubscribetime | |
| unsubscribetime_4 | UNIQUE | 239 | unsubscribetime | |
| subscriberid_3 | UNIQUE | 239 | subscriberid | |
| subscriberid_5 | UNIQUE | 239 | subscriberid | |
| unsubscribetime_6 | UNIQUE | 239 | unsubscribetime | |
| subscriberid_8 | UNIQUE | 239 | subscriberid | |
| unsubscribetime_8 | UNIQUE | 239 | unsubscribetime | |
| unsubscribetime_9 | UNIQUE | 239 | unsubscribetime | |
| subscriberid_9 | UNIQUE | 239 | subscriberid | |
| subscriberid_12 | UNIQUE | 239 | subscriberid | |
| unsubscribetime_12 | UNIQUE | 239 | unsubscribetime | |
| email_list_unsubscribe_sub_list_idx | INDEX | 239 | subscriberid | |
| listid | ||||
| email_list_subscribers_unsubscribe_statid_idx | INDEX | 39 | statid | |
| subscriberid | INDEX | 239 | subscriberid | |
| unsubscribetime | INDEX | 239 | unsubscribetime | |
| unsubscribeip | INDEX | 239 | unsubscribeip | |
| unsubscriberequesttime | INDEX | 2 | unsubscriberequesttime | |
| unsubscriberequestip | INDEX | 2 | unsubscriberequestip | |
| listid | INDEX | 14 | listid | |
| statid | INDEX | 39 | statid | |
| unsubscribearea | INDEX | 4 | unsubscribearea | |
| unsubscriberequestip_2 | INDEX | 2 | unsubscriberequestip | |
| unsubscriberequesttime_2 | INDEX | 2 | unsubscriberequesttime | |
| unsubscribetime_3 | INDEX | 239 | unsubscribetime | |
| statid_2 | INDEX | 39 | statid | |
| subscriberid_4 | INDEX | 239 | subscriberid | |
| listid_2 | INDEX | 14 | listid | |
| unsubscribeip_2 | INDEX | 239 | unsubscribeip | |
| unsubscribearea_2 | INDEX | 4 | unsubscribearea | |
| statid_3 | INDEX | 39 | statid | |
| unsubscribearea_3 | INDEX | 4 | unsubscribearea | |
| unsubscribeip_3 | INDEX | 239 | unsubscribeip | |
| unsubscriberequestip_3 | INDEX | 2 | unsubscriberequestip | |
| subscriberid_6 | INDEX | 239 | subscriberid | |
| unsubscriberequesttime_3 | INDEX | 2 | unsubscriberequesttime | |
| listid_3 | INDEX | 14 | listid | |
| unsubscribetime_5 | INDEX | 239 | unsubscribetime | |
| unsubscribeip_4 | INDEX | 239 | unsubscribeip | |
| unsubscribearea_4 | INDEX | 4 | unsubscribearea | |
| statid_4 | INDEX | 39 | statid | |
| subscriberid_7 | INDEX | 239 | subscriberid | |
| unsubscriberequestip_4 | INDEX | 2 | unsubscriberequestip | |
| unsubscriberequesttime_4 | INDEX | 2 | unsubscriberequesttime | |
| unsubscriberequestip_5 | INDEX | 2 | unsubscriberequestip | |
| listid_4 | INDEX | 14 | listid | |
| unsubscribearea_5 | INDEX | 4 | unsubscribearea | |
| unsubscribetime_7 | INDEX | 239 | unsubscribetime | |
| statid_5 | INDEX | 39 | statid | |
| unsubscribeip_5 | INDEX | 239 | unsubscribeip | |
| unsubscriberequesttime_5 | INDEX | 2 | unsubscriberequesttime | |
| listid_5 | INDEX | 14 | listid | |
| unsubscribetime_10 | INDEX | 239 | unsubscribetime | |
| subscriberid_10 | INDEX | 239 | subscriberid | |
| unsubscriberequesttime_6 | INDEX | 2 | unsubscriberequesttime | |
| unsubscribeip_6 | INDEX | 239 | unsubscribeip | |
| subscriberid_11 | INDEX | 239 | subscriberid | |
| unsubscribetime_11 | INDEX | 239 | unsubscribetime | |
| unsubscribeip_7 | INDEX | 239 | unsubscribeip | |
| unsubscriberequesttime_7 | INDEX | 2 | unsubscriberequesttime | |
| unsubscriberequestip_6 | INDEX | 2 | unsubscriberequestip | |
| listid_6 | INDEX | 14 | listid | |
| statid_6 | INDEX | 39 | statid | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||