Server: mysql.puroparty.com | Database: puroparty | Table: email_segments |
Field | Type | Null | Default |
---|---|---|---|
segmentid | int(11) | No | |
segmentname | varchar(255) | No | |
createdate | int(11) | Yes | 0 |
ownerid | int(11) | No | 0 |
searchinfo | text | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 10 | segmentid | |
segmentid_2 | UNIQUE | 10 | segmentid | |
segmentname_2 | UNIQUE | 10 | segmentname | |
segmentid_4 | UNIQUE | 10 | segmentid | |
segmentname_3 | UNIQUE | 10 | segmentname | |
segmentid_6 | UNIQUE | 10 | segmentid | |
segmentname_5 | UNIQUE | 10 | segmentname | |
segmentname_7 | UNIQUE | 10 | segmentname | |
segmentid_9 | UNIQUE | 10 | segmentid | |
segmentid_10 | UNIQUE | 10 | segmentid | |
segmentname_9 | UNIQUE | 10 | segmentname | |
segmentid_12 | UNIQUE | 10 | segmentid | |
segmentname_11 | UNIQUE | 10 | segmentname | |
segmentid_14 | UNIQUE | 10 | segmentid | |
segmentname_14 | UNIQUE | 10 | segmentname | |
segmentid_15 | UNIQUE | 10 | segmentid | |
segmentname_15 | UNIQUE | 10 | segmentname | |
segmentname_17 | UNIQUE | 10 | segmentname | |
segmentid_17 | UNIQUE | 10 | segmentid | |
createdate_2 | UNIQUE | 10 | createdate | |
createdate_4 | UNIQUE | 10 | createdate | |
createdate_6 | UNIQUE | 10 | createdate | |
createdate_7 | UNIQUE | 10 | createdate | |
createdate_9 | UNIQUE | 10 | createdate | |
createdate_12 | UNIQUE | 10 | createdate | |
createdate_14 | UNIQUE | 10 | createdate | |
createdate_16 | UNIQUE | 10 | createdate | |
createdate_18 | UNIQUE | 10 | createdate | |
segmentid | INDEX | 10 | segmentid | |
segmentname | INDEX | 10 | segmentname | |
createdate | INDEX | 10 | createdate | |
ownerid | INDEX | 2 | ownerid | |
segmentid_3 | INDEX | 10 | segmentid | |
ownerid_2 | INDEX | 2 | ownerid | |
createdate_3 | INDEX | 10 | createdate | |
segmentname_4 | INDEX | 10 | segmentname | |
ownerid_3 | INDEX | 2 | ownerid | |
createdate_5 | INDEX | 10 | createdate | |
segmentid_5 | INDEX | 10 | segmentid | |
segmentname_6 | INDEX | 10 | segmentname | |
ownerid_4 | INDEX | 2 | ownerid | |
createdate_8 | INDEX | 10 | createdate | |
segmentid_7 | INDEX | 10 | segmentid | |
segmentid_8 | INDEX | 10 | segmentid | |
ownerid_5 | INDEX | 2 | ownerid | |
segmentname_8 | INDEX | 10 | segmentname | |
createdate_10 | INDEX | 10 | createdate | |
ownerid_6 | INDEX | 2 | ownerid | |
segmentid_11 | INDEX | 10 | segmentid | |
segmentname_10 | INDEX | 10 | segmentname | |
createdate_11 | INDEX | 10 | createdate | |
ownerid_7 | INDEX | 2 | ownerid | |
segmentname_12 | INDEX | 10 | segmentname | |
segmentid_13 | INDEX | 10 | segmentid | |
segmentname_13 | INDEX | 10 | segmentname | |
createdate_13 | INDEX | 10 | createdate | |
ownerid_8 | INDEX | 2 | ownerid | |
segmentid_16 | INDEX | 10 | segmentid | |
createdate_15 | INDEX | 10 | createdate | |
segmentname_16 | INDEX | 10 | segmentname | |
ownerid_9 | INDEX | 2 | ownerid | |
ownerid_10 | INDEX | 2 | ownerid | |
segmentid_18 | INDEX | 10 | segmentid | |
createdate_17 | INDEX | 10 | createdate |
Space usage :
|
Row Statistic :
|