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

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
   int(11)     Yes    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
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   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 27233  Edit Drop openid
openid_2 UNIQUE 27233  Edit Drop openid
openid_4 UNIQUE 27233  Edit Drop openid
openid_5 UNIQUE 27233  Edit Drop openid
openid_9 UNIQUE 27233  Edit Drop openid
openid_10 UNIQUE 27233  Edit Drop openid
openid_11 UNIQUE 27233  Edit Drop openid
openid_13 UNIQUE 27233  Edit Drop openid
openid_15 UNIQUE 27233  Edit Drop openid
email_stats_emailopens_subscriberid_idx INDEX 13616  Edit Drop subscriberid
email_stats_emailopens_statid_idx INDEX 162  Edit Drop statid
email_open_statid_subscriberid INDEX 27233  Edit Drop subscriberid
statid
openid INDEX 27233  Edit Drop openid
subscriberid INDEX 13616  Edit Drop subscriberid
statid INDEX 92  Edit Drop statid
opentime INDEX 27233  Edit Drop opentime
openip INDEX 5446  Edit Drop openip
fromlink INDEX Edit Drop fromlink
opentype INDEX Edit Drop opentype
openip_2 INDEX 27233  Edit Drop openip
opentype_2 INDEX Edit Drop opentype
statid_2 INDEX 142  Edit Drop statid
openid_3 INDEX 27233  Edit Drop openid
opentime_2 INDEX 27233  Edit Drop opentime
fromlink_2 INDEX Edit Drop fromlink
subscriberid_2 INDEX 9077  Edit Drop subscriberid
statid_3 INDEX 142  Edit Drop statid
fromlink_3 INDEX Edit Drop fromlink
openip_3 INDEX 27233  Edit Drop openip
opentype_3 INDEX Edit Drop opentype
openid_6 INDEX 27233  Edit Drop openid
opentime_3 INDEX 27233  Edit Drop opentime
subscriberid_3 INDEX 13616  Edit Drop subscriberid
openid_7 INDEX 27233  Edit Drop openid
opentype_4 INDEX Edit Drop opentype
opentype_5 INDEX Edit Drop opentype
openid_8 INDEX 27233  Edit Drop openid
subscriberid_4 INDEX 13616  Edit Drop subscriberid
openip_4 INDEX 27233  Edit Drop openip
statid_4 INDEX 92  Edit Drop statid
fromlink_4 INDEX Edit Drop fromlink
fromlink_5 INDEX Edit Drop fromlink
opentime_4 INDEX 27233  Edit Drop opentime
openip_5 INDEX 13616  Edit Drop openip
statid_5 INDEX 92  Edit Drop statid
openip_6 INDEX 27233  Edit Drop openip
fromlink_6 INDEX Edit Drop fromlink
statid_6 INDEX 101  Edit Drop statid
opentime_5 INDEX 27233  Edit Drop opentime
openid_12 INDEX 27233  Edit Drop openid
subscriberid_5 INDEX 13616  Edit Drop subscriberid
statid_7 INDEX 142  Edit Drop statid
opentime_6 INDEX 27233  Edit Drop opentime
openip_7 INDEX 27233  Edit Drop openip
fromlink_7 INDEX Edit Drop fromlink
opentype_6 INDEX Edit Drop opentype
subscriberid_6 INDEX 9077  Edit Drop subscriberid
opentime_7 INDEX 27233  Edit Drop opentime
subscriberid_7 INDEX 13616  Edit Drop subscriberid
subscriberid_8 INDEX 13616  Edit Drop subscriberid
openid_14 INDEX 27233  Edit Drop openid
statid_8 INDEX 142  Edit Drop statid
openip_8 INDEX 27233  Edit Drop openip
opentime_8 INDEX 27233  Edit Drop opentime
Create an index on  columns  
 
Space usage: 
Type Usage
Data 2,576 KB
Index 56,720 KB
Total 59,296 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 27,360
Creation Jun 01, 2018 at 04:06 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: