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

email_stats_emailopens

Table comments : InnoDB free: 776192 kB

Field Type Null Default
openid  int(11) No   
subscriberid  int(11) Yes 
statid  int(11) Yes 
opentime  int(11) Yes 
openip  varchar(20) Yes  NULL 
fromlink  char(1) Yes 
opentype  char(1) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 27233 openid
openid_2 UNIQUE 27233 openid
openid_4 UNIQUE 27233 openid
openid_5 UNIQUE 27233 openid
openid_9 UNIQUE 27233 openid
openid_10 UNIQUE 27233 openid
openid_11 UNIQUE 27233 openid
openid_13 UNIQUE 27233 openid
openid_15 UNIQUE 27233 openid
email_stats_emailopens_subscriberid_idx INDEX 9077 subscriberid
email_stats_emailopens_statid_idx INDEX 72 statid
email_open_statid_subscriberid INDEX 27233 subscriberid
statid
openid INDEX 27233 openid
subscriberid INDEX 13616 subscriberid
statid INDEX 182 statid
opentime INDEX 27233 opentime
openip INDEX 9077 openip
fromlink INDEX 1 fromlink
opentype INDEX 1 opentype
openip_2 INDEX 13616 openip
opentype_2 INDEX 1 opentype
statid_2 INDEX 203 statid
openid_3 INDEX 27233 openid
opentime_2 INDEX 27233 opentime
fromlink_2 INDEX 1 fromlink
subscriberid_2 INDEX 13616 subscriberid
statid_3 INDEX 203 statid
fromlink_3 INDEX 1 fromlink
openip_3 INDEX 27233 openip
opentype_3 INDEX 1 opentype
openid_6 INDEX 27233 openid
opentime_3 INDEX 27233 opentime
subscriberid_3 INDEX 13616 subscriberid
openid_7 INDEX 27233 openid
opentype_4 INDEX 1 opentype
opentype_5 INDEX 1 opentype
openid_8 INDEX 27233 openid
subscriberid_4 INDEX 13616 subscriberid
openip_4 INDEX 27233 openip
statid_4 INDEX 182 statid
fromlink_4 INDEX 1 fromlink
fromlink_5 INDEX 1 fromlink
opentime_4 INDEX 27233 opentime
openip_5 INDEX 27233 openip
statid_5 INDEX 182 statid
openip_6 INDEX 27233 openip
fromlink_6 INDEX 1 fromlink
statid_6 INDEX 132 statid
opentime_5 INDEX 27233 opentime
openid_12 INDEX 27233 openid
subscriberid_5 INDEX 13616 subscriberid
statid_7 INDEX 203 statid
opentime_6 INDEX 27233 opentime
openip_7 INDEX 27233 openip
fromlink_7 INDEX 1 fromlink
opentype_6 INDEX 1 opentype
subscriberid_6 INDEX 13616 subscriberid
opentime_7 INDEX 27233 opentime
subscriberid_7 INDEX 13616 subscriberid
subscriberid_8 INDEX 9077 subscriberid
openid_14 INDEX 27233 openid
statid_8 INDEX 203 statid
openip_8 INDEX 27233 openip
opentime_8 INDEX 27233 opentime


 Space usage :
Type Usage
Data 2,576 KB
Index 56,720 KB
Total 59,296 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 27,233
Row length ø 96
Row size  ø 2,230 Bytes
Next Autoindex 27,360
Creation Jun 01, 2018 at 04:06 AM