Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_segmentsemail_segments

email_segments

Table comments : InnoDB free: 775168 kB

Field Type Null Default
segmentid  int(11) No   
segmentname  varchar(255) No   
createdate  int(11) Yes 
ownerid  int(11) No 
searchinfo  text No   


 Indexes :
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 :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 10
Row length ø 1,638
Row size  ø 104,858 Bytes
Next Autoindex 13
Creation Jun 20, 2018 at 05:07 PM