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

InnoDB free: 776192 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 353  Edit Drop subscriberid
subscriberid_2 UNIQUE 353  Edit Drop subscriberid
unsubscribetime_2 UNIQUE 353  Edit Drop unsubscribetime
unsubscribetime_4 UNIQUE 353  Edit Drop unsubscribetime
subscriberid_3 UNIQUE 353  Edit Drop subscriberid
subscriberid_5 UNIQUE 353  Edit Drop subscriberid
unsubscribetime_6 UNIQUE 353  Edit Drop unsubscribetime
subscriberid_8 UNIQUE 353  Edit Drop subscriberid
unsubscribetime_8 UNIQUE 353  Edit Drop unsubscribetime
unsubscribetime_9 UNIQUE 353  Edit Drop unsubscribetime
subscriberid_9 UNIQUE 353  Edit Drop subscriberid
subscriberid_12 UNIQUE 353  Edit Drop subscriberid
unsubscribetime_12 UNIQUE 353  Edit Drop unsubscribetime
email_list_unsubscribe_sub_list_idx INDEX 353  Edit Drop subscriberid
listid
email_list_subscribers_unsubscribe_statid_idx INDEX 39  Edit Drop statid
subscriberid INDEX 353  Edit Drop subscriberid
unsubscribetime INDEX 353  Edit Drop unsubscribetime
unsubscribeip INDEX 353  Edit Drop unsubscribeip
unsubscriberequesttime INDEX Edit Drop unsubscriberequesttime
unsubscriberequestip INDEX Edit Drop unsubscriberequestip
listid INDEX 14  Edit Drop listid
statid INDEX 39  Edit Drop statid
unsubscribearea INDEX Edit Drop unsubscribearea
unsubscriberequestip_2 INDEX Edit Drop unsubscriberequestip
unsubscriberequesttime_2 INDEX Edit Drop unsubscriberequesttime
unsubscribetime_3 INDEX 353  Edit Drop unsubscribetime
statid_2 INDEX 39  Edit Drop statid
subscriberid_4 INDEX 353  Edit Drop subscriberid
listid_2 INDEX 14  Edit Drop listid
unsubscribeip_2 INDEX 353  Edit Drop unsubscribeip
unsubscribearea_2 INDEX Edit Drop unsubscribearea
statid_3 INDEX 39  Edit Drop statid
unsubscribearea_3 INDEX Edit Drop unsubscribearea
unsubscribeip_3 INDEX 353  Edit Drop unsubscribeip
unsubscriberequestip_3 INDEX Edit Drop unsubscriberequestip
subscriberid_6 INDEX 353  Edit Drop subscriberid
unsubscriberequesttime_3 INDEX Edit Drop unsubscriberequesttime
listid_3 INDEX 14  Edit Drop listid
unsubscribetime_5 INDEX 353  Edit Drop unsubscribetime
unsubscribeip_4 INDEX 353  Edit Drop unsubscribeip
unsubscribearea_4 INDEX Edit Drop unsubscribearea
statid_4 INDEX 39  Edit Drop statid
subscriberid_7 INDEX 353  Edit Drop subscriberid
unsubscriberequestip_4 INDEX Edit Drop unsubscriberequestip
unsubscriberequesttime_4 INDEX Edit Drop unsubscriberequesttime
unsubscriberequestip_5 INDEX Edit Drop unsubscriberequestip
listid_4 INDEX 14  Edit Drop listid
unsubscribearea_5 INDEX Edit Drop unsubscribearea
unsubscribetime_7 INDEX 353  Edit Drop unsubscribetime
statid_5 INDEX 39  Edit Drop statid
unsubscribeip_5 INDEX 353  Edit Drop unsubscribeip
unsubscriberequesttime_5 INDEX Edit Drop unsubscriberequesttime
listid_5 INDEX 14  Edit Drop listid
unsubscribetime_10 INDEX 353  Edit Drop unsubscribetime
subscriberid_10 INDEX 353  Edit Drop subscriberid
unsubscriberequesttime_6 INDEX Edit Drop unsubscriberequesttime
unsubscribeip_6 INDEX 353  Edit Drop unsubscribeip
subscriberid_11 INDEX 353  Edit Drop subscriberid
unsubscribetime_11 INDEX 353  Edit Drop unsubscribetime
unsubscribeip_7 INDEX 353  Edit Drop unsubscribeip
unsubscriberequesttime_7 INDEX Edit Drop unsubscriberequesttime
unsubscriberequestip_6 INDEX Edit Drop unsubscriberequestip
listid_6 INDEX 14  Edit Drop listid
statid_6 INDEX 39  Edit Drop statid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 49,152 Bytes
Index 1,008 KB
Total 1,056 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Jun 03, 2018 at 05:52 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: