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

InnoDB free: 773120 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 13  Edit Drop statid
statid_2 UNIQUE 13  Edit Drop statid
queueid_2 UNIQUE 13  Edit Drop queueid
jobid_2 UNIQUE 13  Edit Drop jobid
starttime_2 UNIQUE 13  Edit Drop starttime
queueid_3 UNIQUE 13  Edit Drop queueid
starttime_3 UNIQUE 13  Edit Drop starttime
jobid_4 UNIQUE 13  Edit Drop jobid
email_stats_newsletters_queue_idx INDEX 13  Edit Drop queueid
email_stats_newsletters_sentby_idx INDEX Edit Drop sentby
statid INDEX 13  Edit Drop statid
queueid INDEX 13  Edit Drop queueid
jobid INDEX 13  Edit Drop jobid
starttime INDEX 13  Edit Drop starttime
finishtime INDEX 13  Edit Drop finishtime
htmlrecipients INDEX Edit Drop htmlrecipients
textrecipients INDEX Edit Drop textrecipients
multipartrecipients INDEX 13  Edit Drop multipartrecipients
trackopens INDEX Edit Drop trackopens
tracklinks INDEX Edit Drop tracklinks
bouncecount_soft INDEX Edit Drop bouncecount_soft
bouncecount_hard INDEX Edit Drop bouncecount_hard
bouncecount_unknown INDEX Edit Drop bouncecount_unknown
unsubscribecount INDEX 13  Edit Drop unsubscribecount
newsletterid INDEX 13  Edit Drop newsletterid
sendfromname INDEX 13  Edit Drop sendfromname
sendfromemail INDEX Edit Drop sendfromemail
bounceemail INDEX Edit Drop bounceemail
replytoemail INDEX Edit Drop replytoemail
charset INDEX Edit Drop charset
sendsize INDEX 13  Edit Drop sendsize
sentby INDEX Edit Drop sentby
notifyowner INDEX Edit Drop notifyowner
linkclicks INDEX 13  Edit Drop linkclicks
emailopens INDEX 13  Edit Drop emailopens
emailforwards INDEX Edit Drop emailforwards
emailopens_unique INDEX 13  Edit Drop emailopens_unique
htmlopens INDEX 13  Edit Drop htmlopens
htmlopens_unique INDEX 13  Edit Drop htmlopens_unique
textopens INDEX Edit Drop textopens
textopens_unique INDEX Edit Drop textopens_unique
hiddenby INDEX Edit Drop hiddenby
sendtestmode INDEX Edit Drop sendtestmode
bouncecount_unknown_2 INDEX Edit Drop bouncecount_unknown
multipartrecipients_2 INDEX 13  Edit Drop multipartrecipients
textopens_2 INDEX Edit Drop textopens
sendfromname_2 INDEX 13  Edit Drop sendfromname
sendtestmode_2 INDEX Edit Drop sendtestmode
emailopens_2 INDEX 13  Edit Drop emailopens
charset_2 INDEX Edit Drop charset
trackopens_2 INDEX Edit Drop trackopens
statid_3 INDEX 13  Edit Drop statid
htmlrecipients_2 INDEX Edit Drop htmlrecipients
jobid_3 INDEX 13  Edit Drop jobid
emailopens_unique_2 INDEX 13  Edit Drop emailopens_unique
finishtime_2 INDEX 13  Edit Drop finishtime
tracklinks_2 INDEX Edit Drop tracklinks
notifyowner_2 INDEX Edit Drop notifyowner
bounceemail_2 INDEX Edit Drop bounceemail
starttime_4 INDEX 13  Edit Drop starttime
queueid_4 INDEX 13  Edit Drop queueid
unsubscribecount_2 INDEX 13  Edit Drop unsubscribecount
bouncecount_soft_2 INDEX Edit Drop bouncecount_soft
sentby_2 INDEX Edit Drop sentby
Create an index on  columns  
 
Space usage: 
Type Usage
Data 65,536 Bytes
Index 1,008 KB
Total 1,072 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Jun 03, 2018 at 03:33 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: