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

InnoDB free: 781312 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 4083  Edit Drop clickid
clickid_2 UNIQUE 4083  Edit Drop clickid
clickid_4 UNIQUE 4083  Edit Drop clickid
clickid_5 UNIQUE 4083  Edit Drop clickid
clickid_7 UNIQUE 4083  Edit Drop clickid
clickid_9 UNIQUE 4083  Edit Drop clickid
clickid_12 UNIQUE 4083  Edit Drop clickid
email_stats_linkclicks_subscriberid_idx INDEX 4083  Edit Drop subscriberid
email_stats_linkclicks_statid_idx INDEX 78  Edit Drop statid
email_stats_linkclicks_linkid_idx INDEX 58  Edit Drop linkid
email_stats_linkclicks_subscriberid INDEX 4083  Edit Drop subscriberid
clickid INDEX 4083  Edit Drop clickid
clicktime INDEX 4083  Edit Drop clicktime
clickip INDEX 4083  Edit Drop clickip
subscriberid INDEX 4083  Edit Drop subscriberid
statid INDEX 78  Edit Drop statid
linkid INDEX 58  Edit Drop linkid
clickip_2 INDEX 4083  Edit Drop clickip
clickid_3 INDEX 4083  Edit Drop clickid
statid_2 INDEX 113  Edit Drop statid
clicktime_2 INDEX 4083  Edit Drop clicktime
subscriberid_2 INDEX 4083  Edit Drop subscriberid
linkid_2 INDEX 58  Edit Drop linkid
clickip_3 INDEX 4083  Edit Drop clickip
linkid_3 INDEX 58  Edit Drop linkid
statid_3 INDEX 83  Edit Drop statid
subscriberid_3 INDEX 4083  Edit Drop subscriberid
clicktime_3 INDEX 4083  Edit Drop clicktime
clickid_6 INDEX 4083  Edit Drop clickid
linkid_4 INDEX 58  Edit Drop linkid
clickip_4 INDEX 4083  Edit Drop clickip
clicktime_4 INDEX 4083  Edit Drop clicktime
subscriberid_4 INDEX 4083  Edit Drop subscriberid
clickid_8 INDEX 4083  Edit Drop clickid
linkid_5 INDEX 58  Edit Drop linkid
clickip_5 INDEX 4083  Edit Drop clickip
statid_4 INDEX 78  Edit Drop statid
subscriberid_5 INDEX 4083  Edit Drop subscriberid
clicktime_5 INDEX 4083  Edit Drop clicktime
statid_5 INDEX 83  Edit Drop statid
clickid_10 INDEX 4083  Edit Drop clickid
linkid_6 INDEX 58  Edit Drop linkid
clickid_11 INDEX 4083  Edit Drop clickid
clicktime_6 INDEX 4083  Edit Drop clicktime
clickip_6 INDEX 4083  Edit Drop clickip
subscriberid_6 INDEX 4083  Edit Drop subscriberid
statid_6 INDEX 83  Edit Drop statid
linkid_7 INDEX 58  Edit Drop linkid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 278,528 Bytes
Index 5,216 KB
Total 5,488 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 3,918
Creation Apr 16, 2018 at 03:26 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: