mysql.puroparty.com
puroparty
email_stats_emailopens
| 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 | 27262 | openid | |
| openid_2 | UNIQUE | 27262 | openid | |
| openid_4 | UNIQUE | 27262 | openid | |
| openid_5 | UNIQUE | 27262 | openid | |
| openid_9 | UNIQUE | 27262 | openid | |
| openid_10 | UNIQUE | 27262 | openid | |
| openid_11 | UNIQUE | 27262 | openid | |
| openid_13 | UNIQUE | 27262 | openid | |
| openid_15 | UNIQUE | 27262 | openid | |
| email_stats_emailopens_subscriberid_idx | INDEX | 9087 | subscriberid | |
| email_stats_emailopens_statid_idx | INDEX | 225 | statid | |
| email_open_statid_subscriberid | INDEX | 27262 | subscriberid | |
| statid | ||||
| openid | INDEX | 27262 | openid | |
| subscriberid | INDEX | 13631 | subscriberid | |
| statid | INDEX | 98 | statid | |
| opentime | INDEX | 27262 | opentime | |
| openip | INDEX | 13631 | openip | |
| fromlink | INDEX | 1 | fromlink | |
| opentype | INDEX | 1 | opentype | |
| openip_2 | INDEX | 13631 | openip | |
| opentype_2 | INDEX | 1 | opentype | |
| statid_2 | INDEX | 50 | statid | |
| openid_3 | INDEX | 27262 | openid | |
| opentime_2 | INDEX | 27262 | opentime | |
| fromlink_2 | INDEX | 1 | fromlink | |
| subscriberid_2 | INDEX | 13631 | subscriberid | |
| statid_3 | INDEX | 50 | statid | |
| fromlink_3 | INDEX | 1 | fromlink | |
| openip_3 | INDEX | 13631 | openip | |
| opentype_3 | INDEX | 1 | opentype | |
| openid_6 | INDEX | 27262 | openid | |
| opentime_3 | INDEX | 27262 | opentime | |
| subscriberid_3 | INDEX | 13631 | subscriberid | |
| openid_7 | INDEX | 27262 | openid | |
| opentype_4 | INDEX | 1 | opentype | |
| opentype_5 | INDEX | 1 | opentype | |
| openid_8 | INDEX | 27262 | openid | |
| subscriberid_4 | INDEX | 13631 | subscriberid | |
| openip_4 | INDEX | 27262 | openip | |
| statid_4 | INDEX | 98 | statid | |
| fromlink_4 | INDEX | 7 | fromlink | |
| fromlink_5 | INDEX | 1 | fromlink | |
| opentime_4 | INDEX | 27262 | opentime | |
| openip_5 | INDEX | 6815 | openip | |
| statid_5 | INDEX | 98 | statid | |
| openip_6 | INDEX | 13631 | openip | |
| fromlink_6 | INDEX | 7 | fromlink | |
| statid_6 | INDEX | 225 | statid | |
| opentime_5 | INDEX | 27262 | opentime | |
| openid_12 | INDEX | 27262 | openid | |
| subscriberid_5 | INDEX | 13631 | subscriberid | |
| statid_7 | INDEX | 50 | statid | |
| opentime_6 | INDEX | 27262 | opentime | |
| openip_7 | INDEX | 13631 | openip | |
| fromlink_7 | INDEX | 7 | fromlink | |
| opentype_6 | INDEX | 1 | opentype | |
| subscriberid_6 | INDEX | 13631 | subscriberid | |
| opentime_7 | INDEX | 27262 | opentime | |
| subscriberid_7 | INDEX | 13631 | subscriberid | |
| subscriberid_8 | INDEX | 9087 | subscriberid | |
| openid_14 | INDEX | 27262 | openid | |
| statid_8 | INDEX | 50 | statid | |
| openip_8 | INDEX | 27262 | openip | |
| opentime_8 | INDEX | 27262 | opentime | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||