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

email_form_pages

Table comments : InnoDB free: 777216 kB

Field Type Null Default
pageid  int(11) No   
formid  int(11) Yes 
pagetype  varchar(100) Yes  NULL 
html  longtext Yes  NULL 
url  varchar(255) Yes  NULL 
sendfromname  varchar(255) Yes  NULL 
sendfromemail  varchar(255) Yes  NULL 
replytoemail  varchar(255) Yes  NULL 
bounceemail  varchar(255) Yes  NULL 
emailsubject  varchar(255) Yes  NULL 
emailhtml  longtext Yes  NULL 
emailtext  longtext Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 9 pageid
pageid_2 UNIQUE 9 pageid
pageid_3 UNIQUE 9 pageid
pageid_6 UNIQUE 9 pageid
pageid_7 UNIQUE 9 pageid
pageid_10 UNIQUE 9 pageid
pageid_11 UNIQUE 9 pageid
pageid_14 UNIQUE 9 pageid
email_form_pages_formid_idx INDEX 9 formid
pageid INDEX 9 pageid
formid INDEX 9 formid
pagetype INDEX 9 pagetype
url INDEX 4 url
sendfromname INDEX 9 sendfromname
sendfromemail INDEX 9 sendfromemail
replytoemail INDEX 9 replytoemail
bounceemail INDEX 9 bounceemail
emailsubject INDEX 9 emailsubject
emailsubject_2 INDEX 9 emailsubject
pagetype_2 INDEX 9 pagetype
sendfromemail_2 INDEX 9 sendfromemail
url_2 INDEX 4 url
replytoemail_2 INDEX 9 replytoemail
formid_2 INDEX 9 formid
bounceemail_2 INDEX 9 bounceemail
sendfromname_2 INDEX 9 sendfromname
pageid_4 INDEX 9 pageid
url_3 INDEX 4 url
bounceemail_3 INDEX 9 bounceemail
sendfromname_3 INDEX 9 sendfromname
replytoemail_3 INDEX 9 replytoemail
sendfromemail_3 INDEX 9 sendfromemail
pageid_5 INDEX 9 pageid
formid_3 INDEX 9 formid
pagetype_3 INDEX 9 pagetype
emailsubject_3 INDEX 9 emailsubject
replytoemail_4 INDEX 9 replytoemail
pagetype_4 INDEX 9 pagetype
sendfromemail_4 INDEX 9 sendfromemail
emailsubject_4 INDEX 9 emailsubject
formid_4 INDEX 9 formid
url_4 INDEX 4 url
pageid_8 INDEX 9 pageid
sendfromname_4 INDEX 9 sendfromname
bounceemail_4 INDEX 9 bounceemail
replytoemail_5 INDEX 9 replytoemail
pagetype_5 INDEX 9 pagetype
formid_5 INDEX 9 formid
pageid_9 INDEX 9 pageid
bounceemail_5 INDEX 9 bounceemail
emailsubject_5 INDEX 9 emailsubject
replytoemail_6 INDEX 9 replytoemail
sendfromname_5 INDEX 9 sendfromname
url_5 INDEX 4 url
sendfromemail_5 INDEX 9 sendfromemail
emailsubject_6 INDEX 9 emailsubject
pagetype_6 INDEX 9 pagetype
sendfromemail_6 INDEX 9 sendfromemail
url_6 INDEX 4 url
formid_6 INDEX 9 formid
pageid_12 INDEX 9 pageid
sendfromemail_7 INDEX 9 sendfromemail
pagetype_7 INDEX 9 pagetype
pageid_13 INDEX 9 pageid


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 9
Row length ø 1,820
Row size  ø 116,508 Bytes
Next Autoindex 25
Creation May 31, 2018 at 08:56 PM