Server: mysql.puroparty.com | Database: puroparty | Table: email_stats_emailopens |
Field | Type | Null | Default |
---|---|---|---|
openid | int(11) | No | |
subscriberid | int(11) | Yes | 0 |
statid | int(11) | Yes | 0 |
opentime | int(11) | Yes | 0 |
openip | varchar(20) | Yes | NULL |
fromlink | char(1) | Yes | 0 |
opentype | char(1) | Yes | u |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 26564 | openid | |
openid_2 | UNIQUE | 26564 | openid | |
openid_4 | UNIQUE | 26564 | openid | |
openid_5 | UNIQUE | 26564 | openid | |
openid_9 | UNIQUE | 26564 | openid | |
openid_10 | UNIQUE | 26564 | openid | |
openid_11 | UNIQUE | 26564 | openid | |
openid_13 | UNIQUE | 26564 | openid | |
openid_15 | UNIQUE | 26564 | openid | |
email_stats_emailopens_subscriberid_idx | INDEX | 13282 | subscriberid | |
email_stats_emailopens_statid_idx | INDEX | 168 | statid | |
email_open_statid_subscriberid | INDEX | 26564 | subscriberid | |
statid | ||||
openid | INDEX | 26564 | openid | |
subscriberid | INDEX | 8854 | subscriberid | |
statid | INDEX | 119 | statid | |
opentime | INDEX | 26564 | opentime | |
openip | INDEX | 13282 | openip | |
fromlink | INDEX | 1 | fromlink | |
opentype | INDEX | 1 | opentype | |
openip_2 | INDEX | 26564 | openip | |
opentype_2 | INDEX | 1 | opentype | |
statid_2 | INDEX | 99 | statid | |
openid_3 | INDEX | 26564 | openid | |
opentime_2 | INDEX | 26564 | opentime | |
fromlink_2 | INDEX | 1 | fromlink | |
subscriberid_2 | INDEX | 8854 | subscriberid | |
statid_3 | INDEX | 99 | statid | |
fromlink_3 | INDEX | 1 | fromlink | |
openip_3 | INDEX | 26564 | openip | |
opentype_3 | INDEX | 1 | opentype | |
openid_6 | INDEX | 26564 | openid | |
opentime_3 | INDEX | 26564 | opentime | |
subscriberid_3 | INDEX | 13282 | subscriberid | |
openid_7 | INDEX | 26564 | openid | |
opentype_4 | INDEX | 1 | opentype | |
opentype_5 | INDEX | 1 | opentype | |
openid_8 | INDEX | 26564 | openid | |
subscriberid_4 | INDEX | 13282 | subscriberid | |
openip_4 | INDEX | 8854 | openip | |
statid_4 | INDEX | 119 | statid | |
fromlink_4 | INDEX | 1 | fromlink | |
fromlink_5 | INDEX | 1 | fromlink | |
opentime_4 | INDEX | 26564 | opentime | |
openip_5 | INDEX | 26564 | openip | |
statid_5 | INDEX | 119 | statid | |
openip_6 | INDEX | 26564 | openip | |
fromlink_6 | INDEX | 1 | fromlink | |
statid_6 | INDEX | 80 | statid | |
opentime_5 | INDEX | 26564 | opentime | |
openid_12 | INDEX | 26564 | openid | |
subscriberid_5 | INDEX | 8854 | subscriberid | |
statid_7 | INDEX | 99 | statid | |
opentime_6 | INDEX | 26564 | opentime | |
openip_7 | INDEX | 26564 | openip | |
fromlink_7 | INDEX | 1 | fromlink | |
opentype_6 | INDEX | 1 | opentype | |
subscriberid_6 | INDEX | 8854 | subscriberid | |
opentime_7 | INDEX | 26564 | opentime | |
subscriberid_7 | INDEX | 8854 | subscriberid | |
subscriberid_8 | INDEX | 13282 | subscriberid | |
openid_14 | INDEX | 26564 | openid | |
statid_8 | INDEX | 99 | statid | |
openip_8 | INDEX | 26564 | openip | |
opentime_8 | INDEX | 26564 | opentime |
Space usage :
|
Row Statistic :
|