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 | 353 | subscriberid | |
subscriberid_2 | UNIQUE | 353 | subscriberid | |
unsubscribetime_2 | UNIQUE | 353 | unsubscribetime | |
unsubscribetime_4 | UNIQUE | 353 | unsubscribetime | |
subscriberid_3 | UNIQUE | 353 | subscriberid | |
subscriberid_5 | UNIQUE | 353 | subscriberid | |
unsubscribetime_6 | UNIQUE | 353 | unsubscribetime | |
subscriberid_8 | UNIQUE | 353 | subscriberid | |
unsubscribetime_8 | UNIQUE | 353 | unsubscribetime | |
unsubscribetime_9 | UNIQUE | 353 | unsubscribetime | |
subscriberid_9 | UNIQUE | 353 | subscriberid | |
subscriberid_12 | UNIQUE | 353 | subscriberid | |
unsubscribetime_12 | UNIQUE | 353 | unsubscribetime | |
email_list_unsubscribe_sub_list_idx | INDEX | 353 | subscriberid | |
listid | ||||
email_list_subscribers_unsubscribe_statid_idx | INDEX | 39 | statid | |
subscriberid | INDEX | 353 | subscriberid | |
unsubscribetime | INDEX | 353 | unsubscribetime | |
unsubscribeip | INDEX | 353 | 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 | 353 | unsubscribetime | |
statid_2 | INDEX | 39 | statid | |
subscriberid_4 | INDEX | 353 | subscriberid | |
listid_2 | INDEX | 14 | listid | |
unsubscribeip_2 | INDEX | 353 | unsubscribeip | |
unsubscribearea_2 | INDEX | 4 | unsubscribearea | |
statid_3 | INDEX | 39 | statid | |
unsubscribearea_3 | INDEX | 4 | unsubscribearea | |
unsubscribeip_3 | INDEX | 353 | unsubscribeip | |
unsubscriberequestip_3 | INDEX | 2 | unsubscriberequestip | |
subscriberid_6 | INDEX | 353 | subscriberid | |
unsubscriberequesttime_3 | INDEX | 2 | unsubscriberequesttime | |
listid_3 | INDEX | 14 | listid | |
unsubscribetime_5 | INDEX | 353 | unsubscribetime | |
unsubscribeip_4 | INDEX | 353 | unsubscribeip | |
unsubscribearea_4 | INDEX | 4 | unsubscribearea | |
statid_4 | INDEX | 39 | statid | |
subscriberid_7 | INDEX | 353 | 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 | 353 | unsubscribetime | |
statid_5 | INDEX | 39 | statid | |
unsubscribeip_5 | INDEX | 353 | unsubscribeip | |
unsubscriberequesttime_5 | INDEX | 2 | unsubscriberequesttime | |
listid_5 | INDEX | 14 | listid | |
unsubscribetime_10 | INDEX | 353 | unsubscribetime | |
subscriberid_10 | INDEX | 353 | subscriberid | |
unsubscriberequesttime_6 | INDEX | 2 | unsubscriberequesttime | |
unsubscribeip_6 | INDEX | 353 | unsubscribeip | |
subscriberid_11 | INDEX | 353 | subscriberid | |
unsubscribetime_11 | INDEX | 353 | unsubscribetime | |
unsubscribeip_7 | INDEX | 353 | 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 :
|