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

email_autoresponders

Table comments : InnoDB free: 775168 kB

Field Type Null Default
autoresponderid  int(11) No   
name  varchar(255) Yes  NULL 
subject  varchar(255) Yes  NULL 
format  char(1) Yes  NULL 
textbody  longtext Yes  NULL 
htmlbody  longtext Yes  NULL 
createdate  int(11) Yes 
active  int(11) Yes 
hoursaftersubscription  int(11) Yes 
ownerid  int(11) No 
searchcriteria  mediumtext Yes  NULL 
listid  int(11) Yes 
tracklinks  char(1) Yes 
trackopens  char(1) Yes 
multipart  char(1) Yes 
queueid  int(11) Yes 
sendfromname  varchar(255) Yes  NULL 
sendfromemail  varchar(255) Yes  NULL 
replytoemail  varchar(255) Yes  NULL 
bounceemail  varchar(255) Yes  NULL 
charset  varchar(255) Yes  NULL 
embedimages  char(1) Yes 
to_firstname  int(11) Yes 
to_lastname  int(11) Yes 
autorespondersize  int(11) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 autoresponderid
autoresponderid_2 UNIQUE 0 autoresponderid
ownerid_2 UNIQUE 0 ownerid
autoresponderid_3 UNIQUE 0 autoresponderid
name_2 UNIQUE 0 name
subject_2 UNIQUE 0 subject
format_2 UNIQUE 0 format
createdate_2 UNIQUE 0 createdate
active_2 UNIQUE 0 active
hoursaftersubscription_2 UNIQUE 0 hoursaftersubscription
listid_2 UNIQUE 0 listid
tracklinks_2 UNIQUE 0 tracklinks
trackopens_2 UNIQUE 0 trackopens
multipart_2 UNIQUE 0 multipart
queueid_2 UNIQUE 0 queueid
sendfromname_2 UNIQUE 0 sendfromname
sendfromemail_2 UNIQUE 0 sendfromemail
replytoemail_2 UNIQUE 0 replytoemail
bounceemail_2 UNIQUE 0 bounceemail
charset_2 UNIQUE 0 charset
embedimages_2 UNIQUE 0 embedimages
to_firstname_2 UNIQUE 0 to_firstname
to_lastname_2 UNIQUE 0 to_lastname
autorespondersize_2 UNIQUE 0 autorespondersize
bounceemail_3 UNIQUE 0 bounceemail
format_3 UNIQUE 0 format
multipart_3 UNIQUE 0 multipart
trackopens_3 UNIQUE 0 trackopens
name_4 UNIQUE 0 name
createdate_3 UNIQUE 0 createdate
email_autoresponders_owner_idx INDEX 0 ownerid
email_autoresponders_list_idx INDEX 0 listid
email_autoresponders_queue_idx INDEX 0 queueid
autoresponderid INDEX 0 autoresponderid
name INDEX 0 name
subject INDEX 0 subject
format INDEX 0 format
createdate INDEX 0 createdate
active INDEX 0 active
hoursaftersubscription INDEX 0 hoursaftersubscription
ownerid INDEX 0 ownerid
listid INDEX 0 listid
tracklinks INDEX 0 tracklinks
trackopens INDEX 0 trackopens
multipart INDEX 0 multipart
queueid INDEX 0 queueid
sendfromname INDEX 0 sendfromname
sendfromemail INDEX 0 sendfromemail
replytoemail INDEX 0 replytoemail
bounceemail INDEX 0 bounceemail
charset INDEX 0 charset
embedimages INDEX 0 embedimages
to_firstname INDEX 0 to_firstname
to_lastname INDEX 0 to_lastname
autorespondersize INDEX 0 autorespondersize
name_3 INDEX 0 name
autorespondersize_3 INDEX 0 autorespondersize
sendfromemail_3 INDEX 0 sendfromemail
active_3 INDEX 0 active
tracklinks_3 INDEX 0 tracklinks
to_lastname_3 INDEX 0 to_lastname
queueid_3 INDEX 0 queueid
ownerid_3 INDEX 0 ownerid
subject_3 INDEX 0 subject


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Mar 04, 2018 at 03:21 PM