mysql.puroparty.com
puroparty
email_stats_linkclicks
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: email_stats_linkclicks
|
| Field | Type | Null | Default |
|---|---|---|---|
| clickid | int(11) | No | |
| clicktime | int(11) | Yes | 0 |
| clickip | varchar(20) | Yes | NULL |
| subscriberid | int(11) | Yes | 0 |
| statid | int(11) | Yes | 0 |
| linkid | int(11) | Yes | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 3987 | clickid | |
| clickid_2 | UNIQUE | 3987 | clickid | |
| clickid_4 | UNIQUE | 3987 | clickid | |
| clickid_5 | UNIQUE | 3987 | clickid | |
| clickid_7 | UNIQUE | 3987 | clickid | |
| clickid_9 | UNIQUE | 3987 | clickid | |
| clickid_12 | UNIQUE | 3987 | clickid | |
| clickid_13 | UNIQUE | 3987 | clickid | |
| clickid_15 | UNIQUE | 3987 | clickid | |
| email_stats_linkclicks_subscriberid_idx | INDEX | 3987 | subscriberid | |
| email_stats_linkclicks_statid_idx | INDEX | 72 | statid | |
| email_stats_linkclicks_linkid_idx | INDEX | 66 | linkid | |
| email_stats_linkclicks_subscriberid | INDEX | 3987 | subscriberid | |
| clickid | INDEX | 3987 | clickid | |
| clicktime | INDEX | 3987 | clicktime | |
| clickip | INDEX | 3987 | clickip | |
| subscriberid | INDEX | 3987 | subscriberid | |
| statid | INDEX | 72 | statid | |
| linkid | INDEX | 65 | linkid | |
| clickip_2 | INDEX | 3987 | clickip | |
| clickid_3 | INDEX | 3987 | clickid | |
| statid_2 | INDEX | 81 | statid | |
| clicktime_2 | INDEX | 3987 | clicktime | |
| subscriberid_2 | INDEX | 3987 | subscriberid | |
| linkid_2 | INDEX | 65 | linkid | |
| clickip_3 | INDEX | 3987 | clickip | |
| linkid_3 | INDEX | 66 | linkid | |
| statid_3 | INDEX | 110 | statid | |
| subscriberid_3 | INDEX | 3987 | subscriberid | |
| clicktime_3 | INDEX | 3987 | clicktime | |
| clickid_6 | INDEX | 3987 | clickid | |
| linkid_4 | INDEX | 65 | linkid | |
| clickip_4 | INDEX | 3987 | clickip | |
| clicktime_4 | INDEX | 3987 | clicktime | |
| subscriberid_4 | INDEX | 3987 | subscriberid | |
| clickid_8 | INDEX | 3987 | clickid | |
| linkid_5 | INDEX | 65 | linkid | |
| clickip_5 | INDEX | 3987 | clickip | |
| statid_4 | INDEX | 72 | statid | |
| subscriberid_5 | INDEX | 3987 | subscriberid | |
| clicktime_5 | INDEX | 3987 | clicktime | |
| statid_5 | INDEX | 110 | statid | |
| clickid_10 | INDEX | 3987 | clickid | |
| linkid_6 | INDEX | 65 | linkid | |
| clickid_11 | INDEX | 3987 | clickid | |
| clicktime_6 | INDEX | 3987 | clicktime | |
| clickip_6 | INDEX | 3987 | clickip | |
| subscriberid_6 | INDEX | 3987 | subscriberid | |
| statid_6 | INDEX | 110 | statid | |
| linkid_7 | INDEX | 65 | linkid | |
| linkid_8 | INDEX | 66 | linkid | |
| statid_7 | INDEX | 76 | statid | |
| subscriberid_7 | INDEX | 3987 | subscriberid | |
| clicktime_7 | INDEX | 3987 | clicktime | |
| linkid_9 | INDEX | 65 | linkid | |
| clickip_7 | INDEX | 3987 | clickip | |
| clickid_14 | INDEX | 3987 | clickid | |
| statid_8 | INDEX | 71 | statid | |
| subscriberid_8 | INDEX | 3987 | subscriberid | |
| clicktime_8 | INDEX | 3987 | clicktime | |
| linkid_10 | INDEX | 65 | linkid | |
| clickid_16 | INDEX | 3987 | clickid | |
| clickip_8 | INDEX | 3987 | clickip | |
| clickid_17 | INDEX | 3987 | clickid | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||