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

InnoDB free: 775168 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  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)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    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 3753  Edit Drop clickid
clickid_2 UNIQUE 3753  Edit Drop clickid
clickid_4 UNIQUE 3753  Edit Drop clickid
clickid_5 UNIQUE 3753  Edit Drop clickid
clickid_7 UNIQUE 3753  Edit Drop clickid
clickid_9 UNIQUE 3753  Edit Drop clickid
clickid_12 UNIQUE 3753  Edit Drop clickid
clickid_13 UNIQUE 3753  Edit Drop clickid
clickid_15 UNIQUE 3753  Edit Drop clickid
email_stats_linkclicks_subscriberid_idx INDEX 3753  Edit Drop subscriberid
email_stats_linkclicks_statid_idx INDEX 83  Edit Drop statid
email_stats_linkclicks_linkid_idx INDEX 70  Edit Drop linkid
email_stats_linkclicks_subscriberid INDEX 3753  Edit Drop subscriberid
clickid INDEX 3753  Edit Drop clickid
clicktime INDEX 3753  Edit Drop clicktime
clickip INDEX 3753  Edit Drop clickip
subscriberid INDEX 3753  Edit Drop subscriberid
statid INDEX 83  Edit Drop statid
linkid INDEX 70  Edit Drop linkid
clickip_2 INDEX 3753  Edit Drop clickip
clickid_3 INDEX 3753  Edit Drop clickid
statid_2 INDEX 72  Edit Drop statid
clicktime_2 INDEX 3753  Edit Drop clicktime
subscriberid_2 INDEX 3753  Edit Drop subscriberid
linkid_2 INDEX 70  Edit Drop linkid
clickip_3 INDEX 3753  Edit Drop clickip
linkid_3 INDEX 70  Edit Drop linkid
statid_3 INDEX 83  Edit Drop statid
subscriberid_3 INDEX 3753  Edit Drop subscriberid
clicktime_3 INDEX 3753  Edit Drop clicktime
clickid_6 INDEX 3753  Edit Drop clickid
linkid_4 INDEX 70  Edit Drop linkid
clickip_4 INDEX 3753  Edit Drop clickip
clicktime_4 INDEX 3753  Edit Drop clicktime
subscriberid_4 INDEX 3753  Edit Drop subscriberid
clickid_8 INDEX 3753  Edit Drop clickid
linkid_5 INDEX 70  Edit Drop linkid
clickip_5 INDEX 3753  Edit Drop clickip
statid_4 INDEX 83  Edit Drop statid
subscriberid_5 INDEX 3753  Edit Drop subscriberid
clicktime_5 INDEX 3753  Edit Drop clicktime
statid_5 INDEX 83  Edit Drop statid
clickid_10 INDEX 3753  Edit Drop clickid
linkid_6 INDEX 70  Edit Drop linkid
clickid_11 INDEX 3753  Edit Drop clickid
clicktime_6 INDEX 3753  Edit Drop clicktime
clickip_6 INDEX 3753  Edit Drop clickip
subscriberid_6 INDEX 3753  Edit Drop subscriberid
statid_6 INDEX 83  Edit Drop statid
linkid_7 INDEX 70  Edit Drop linkid
linkid_8 INDEX 70  Edit Drop linkid
statid_7 INDEX 75  Edit Drop statid
subscriberid_7 INDEX 3753  Edit Drop subscriberid
clicktime_7 INDEX 3753  Edit Drop clicktime
linkid_9 INDEX 70  Edit Drop linkid
clickip_7 INDEX 3753  Edit Drop clickip
clickid_14 INDEX 3753  Edit Drop clickid
statid_8 INDEX 78  Edit Drop statid
subscriberid_8 INDEX 3753  Edit Drop subscriberid
clicktime_8 INDEX 3753  Edit Drop clicktime
linkid_10 INDEX 70  Edit Drop linkid
clickid_16 INDEX 3753  Edit Drop clickid
clickip_8 INDEX 3753  Edit Drop clickip
clickid_17 INDEX 3753  Edit Drop clickid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 278,528 Bytes
Index 6,976 KB
Total 7,248 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 3,918
Creation Jun 08, 2018 at 03:01 AM

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: