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

email_stats_autoresponders

Table comments : InnoDB free: 775168 kB

Field Type Null Default
statid  int(11) No 
htmlrecipients  int(11) Yes 
textrecipients  int(11) Yes 
multipartrecipients  int(11) Yes 
bouncecount_soft  int(11) Yes 
bouncecount_hard  int(11) Yes 
bouncecount_unknown  int(11) Yes 
unsubscribecount  int(11) Yes 
autoresponderid  int(11) Yes 
linkclicks  int(11) Yes 
emailopens  int(11) Yes 
emailforwards  int(11) Yes 
emailopens_unique  int(11) Yes 
htmlopens  int(11) Yes 
htmlopens_unique  int(11) Yes 
textopens  int(11) Yes 
textopens_unique  int(11) Yes 
hiddenby  int(11) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 statid
statid_2 UNIQUE 0 statid
statid_3 UNIQUE 0 statid
htmlrecipients_2 UNIQUE 0 htmlrecipients
textrecipients_2 UNIQUE 0 textrecipients
multipartrecipients_2 UNIQUE 0 multipartrecipients
bouncecount_soft_2 UNIQUE 0 bouncecount_soft
bouncecount_hard_2 UNIQUE 0 bouncecount_hard
bouncecount_unknown_2 UNIQUE 0 bouncecount_unknown
unsubscribecount_2 UNIQUE 0 unsubscribecount
autoresponderid_2 UNIQUE 0 autoresponderid
linkclicks_2 UNIQUE 0 linkclicks
emailopens_2 UNIQUE 0 emailopens
emailforwards_2 UNIQUE 0 emailforwards
emailopens_unique_2 UNIQUE 0 emailopens_unique
htmlopens_2 UNIQUE 0 htmlopens
htmlopens_unique_2 UNIQUE 0 htmlopens_unique
textopens_2 UNIQUE 0 textopens
textopens_unique_2 UNIQUE 0 textopens_unique
hiddenby_2 UNIQUE 0 hiddenby
unsubscribecount_3 UNIQUE 0 unsubscribecount
hiddenby_3 UNIQUE 0 hiddenby
bouncecount_unknown_4 UNIQUE 0 bouncecount_unknown
bouncecount_soft_3 UNIQUE 0 bouncecount_soft
emailforwards_4 UNIQUE 0 emailforwards
multipartrecipients_4 UNIQUE 0 multipartrecipients
htmlrecipients_3 UNIQUE 0 htmlrecipients
linkclicks_3 UNIQUE 0 linkclicks
autoresponderid_3 UNIQUE 0 autoresponderid
emailopens_3 UNIQUE 0 emailopens
bouncecount_hard_3 UNIQUE 0 bouncecount_hard
htmlopens_unique_3 UNIQUE 0 htmlopens_unique
email_stats_autoresponders_statid_idx INDEX 0 statid
email_stats_autoresponders_autoresponderid_idx INDEX 0 autoresponderid
statid INDEX 0 statid
htmlrecipients INDEX 0 htmlrecipients
textrecipients INDEX 0 textrecipients
multipartrecipients INDEX 0 multipartrecipients
bouncecount_soft INDEX 0 bouncecount_soft
bouncecount_hard INDEX 0 bouncecount_hard
bouncecount_unknown INDEX 0 bouncecount_unknown
unsubscribecount INDEX 0 unsubscribecount
autoresponderid INDEX 0 autoresponderid
linkclicks INDEX 0 linkclicks
emailopens INDEX 0 emailopens
emailforwards INDEX 0 emailforwards
emailopens_unique INDEX 0 emailopens_unique
htmlopens INDEX 0 htmlopens
htmlopens_unique INDEX 0 htmlopens_unique
textopens INDEX 0 textopens
textopens_unique INDEX 0 textopens_unique
hiddenby INDEX 0 hiddenby
textopens_3 INDEX 0 textopens
bouncecount_unknown_3 INDEX 0 bouncecount_unknown
multipartrecipients_3 INDEX 0 multipartrecipients
hiddenby_4 INDEX 0 hiddenby
emailforwards_3 INDEX 0 emailforwards
textopens_unique_3 INDEX 0 textopens_unique
htmlrecipients_4 INDEX 0 htmlrecipients
linkclicks_4 INDEX 0 linkclicks
emailopens_4 INDEX 0 emailopens
unsubscribecount_4 INDEX 0 unsubscribecount
autoresponderid_4 INDEX 0 autoresponderid
emailopens_unique_3 INDEX 0 emailopens_unique


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format fixed
Rows 0
Creation Apr 08, 2018 at 03:12 AM