mysql.puroparty.com
puroparty
email_stats_newsletters
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: email_stats_newsletters
|
| Field | Type | Null | Default |
|---|---|---|---|
| statid | int(11) | No | 0 |
| queueid | int(11) | Yes | 0 |
| jobid | int(11) | Yes | 0 |
| starttime | int(11) | Yes | 0 |
| finishtime | int(11) | Yes | 0 |
| htmlrecipients | int(11) | Yes | 0 |
| textrecipients | int(11) | Yes | 0 |
| multipartrecipients | int(11) | Yes | 0 |
| trackopens | char(1) | Yes | 0 |
| tracklinks | char(1) | Yes | 0 |
| bouncecount_soft | int(11) | Yes | 0 |
| bouncecount_hard | int(11) | Yes | 0 |
| bouncecount_unknown | int(11) | Yes | 0 |
| unsubscribecount | int(11) | Yes | 0 |
| newsletterid | int(11) | Yes | 0 |
| sendfromname | varchar(200) | Yes | NULL |
| sendfromemail | varchar(200) | Yes | NULL |
| bounceemail | varchar(200) | Yes | NULL |
| replytoemail | varchar(200) | Yes | NULL |
| charset | varchar(200) | Yes | NULL |
| sendinformation | mediumtext | Yes | NULL |
| sendsize | int(11) | Yes | 0 |
| sentby | int(11) | Yes | 0 |
| notifyowner | char(1) | Yes | 0 |
| linkclicks | int(11) | Yes | 0 |
| emailopens | int(11) | Yes | 0 |
| emailforwards | int(11) | Yes | 0 |
| emailopens_unique | int(11) | Yes | 0 |
| htmlopens | int(11) | Yes | 0 |
| htmlopens_unique | int(11) | Yes | 0 |
| textopens | int(11) | Yes | 0 |
| textopens_unique | int(11) | Yes | 0 |
| hiddenby | int(11) | Yes | 0 |
| sendtestmode | int(11) | Yes | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 13 | statid | |
| statid_2 | UNIQUE | 13 | statid | |
| queueid_2 | UNIQUE | 13 | queueid | |
| jobid_2 | UNIQUE | 13 | jobid | |
| starttime_2 | UNIQUE | 13 | starttime | |
| queueid_3 | UNIQUE | 13 | queueid | |
| starttime_3 | UNIQUE | 13 | starttime | |
| jobid_4 | UNIQUE | 13 | jobid | |
| email_stats_newsletters_queue_idx | INDEX | 13 | queueid | |
| email_stats_newsletters_sentby_idx | INDEX | 2 | sentby | |
| statid | INDEX | 13 | statid | |
| queueid | INDEX | 13 | queueid | |
| jobid | INDEX | 13 | jobid | |
| starttime | INDEX | 13 | starttime | |
| finishtime | INDEX | 13 | finishtime | |
| htmlrecipients | INDEX | 2 | htmlrecipients | |
| textrecipients | INDEX | 2 | textrecipients | |
| multipartrecipients | INDEX | 13 | multipartrecipients | |
| trackopens | INDEX | 2 | trackopens | |
| tracklinks | INDEX | 4 | tracklinks | |
| bouncecount_soft | INDEX | 2 | bouncecount_soft | |
| bouncecount_hard | INDEX | 2 | bouncecount_hard | |
| bouncecount_unknown | INDEX | 2 | bouncecount_unknown | |
| unsubscribecount | INDEX | 13 | unsubscribecount | |
| newsletterid | INDEX | 13 | newsletterid | |
| sendfromname | INDEX | 13 | sendfromname | |
| sendfromemail | INDEX | 6 | sendfromemail | |
| bounceemail | INDEX | 6 | bounceemail | |
| replytoemail | INDEX | 6 | replytoemail | |
| charset | INDEX | 2 | charset | |
| sendsize | INDEX | 13 | sendsize | |
| sentby | INDEX | 2 | sentby | |
| notifyowner | INDEX | 2 | notifyowner | |
| linkclicks | INDEX | 13 | linkclicks | |
| emailopens | INDEX | 13 | emailopens | |
| emailforwards | INDEX | 2 | emailforwards | |
| emailopens_unique | INDEX | 13 | emailopens_unique | |
| htmlopens | INDEX | 13 | htmlopens | |
| htmlopens_unique | INDEX | 13 | htmlopens_unique | |
| textopens | INDEX | 2 | textopens | |
| textopens_unique | INDEX | 2 | textopens_unique | |
| hiddenby | INDEX | 4 | hiddenby | |
| sendtestmode | INDEX | 2 | sendtestmode | |
| bouncecount_unknown_2 | INDEX | 2 | bouncecount_unknown | |
| multipartrecipients_2 | INDEX | 13 | multipartrecipients | |
| textopens_2 | INDEX | 2 | textopens | |
| sendfromname_2 | INDEX | 13 | sendfromname | |
| sendtestmode_2 | INDEX | 2 | sendtestmode | |
| emailopens_2 | INDEX | 13 | emailopens | |
| charset_2 | INDEX | 2 | charset | |
| trackopens_2 | INDEX | 2 | trackopens | |
| statid_3 | INDEX | 13 | statid | |
| htmlrecipients_2 | INDEX | 2 | htmlrecipients | |
| jobid_3 | INDEX | 13 | jobid | |
| emailopens_unique_2 | INDEX | 13 | emailopens_unique | |
| finishtime_2 | INDEX | 13 | finishtime | |
| tracklinks_2 | INDEX | 4 | tracklinks | |
| notifyowner_2 | INDEX | 2 | notifyowner | |
| bounceemail_2 | INDEX | 6 | bounceemail | |
| starttime_4 | INDEX | 13 | starttime | |
| queueid_4 | INDEX | 13 | queueid | |
| unsubscribecount_2 | INDEX | 13 | unsubscribecount | |
| bouncecount_soft_2 | INDEX | 2 | bouncecount_soft | |
| sentby_2 | INDEX | 2 | sentby | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||