Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_list_subscribers_unsubscribeemail_list_subscribers_unsubscribe

email_list_subscribers_unsubscribe

Table comments : InnoDB free: 773120 kB

Field Type Null Default
subscriberid  int(11) No 
unsubscribetime  int(11) No 
unsubscribeip  varchar(20) Yes  NULL 
unsubscriberequesttime  int(11) Yes 
unsubscriberequestip  varchar(20) Yes  NULL 
listid  int(11) No 
statid  int(11) Yes 
unsubscribearea  varchar(20) Yes  NULL 


 Indexes :
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 :
Type Usage
Data 49,152 Bytes
Index 1,008 KB
Total 1,056 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 353
Row length ø 139
Row size  ø 3,063 Bytes
Creation Jun 03, 2018 at 05:52 PM