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

email_forms

Table comments : InnoDB free: 730112 kB

Field Type Null Default
formid  int(11) No   
name  varchar(255) Yes  NULL 
design  varchar(255) Yes  NULL 
formhtml  longtext Yes  NULL 
chooseformat  varchar(2) Yes  NULL 
changeformat  char(1) Yes 
sendthanks  char(1) Yes 
requireconfirm  char(1) Yes 
ownerid  int(11) Yes 
formtype  char(1) Yes  NULL 
createdate  int(11) Yes 
contactform  char(1) Yes 
usecaptcha  char(1) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 3 formid
formid_2 UNIQUE 3 formid
formid_3 UNIQUE 3 formid
formid_6 UNIQUE 3 formid
formid_7 UNIQUE 3 formid
name_2 UNIQUE 3 name
design_2 UNIQUE 3 design
createdate_2 UNIQUE 3 createdate
createdate_3 UNIQUE 3 createdate
name_3 UNIQUE 3 name
design_4 UNIQUE 3 design
name_6 UNIQUE 3 name
design_6 UNIQUE 3 design
name_7 UNIQUE 3 name
design_8 UNIQUE 3 design
createdate_6 UNIQUE 3 createdate
name_9 UNIQUE 3 name
design_9 UNIQUE 3 design
formid INDEX 3 formid
name INDEX 3 name
design INDEX 3 design
chooseformat INDEX 3 chooseformat
changeformat INDEX 3 changeformat
sendthanks INDEX 3 sendthanks
requireconfirm INDEX 3 requireconfirm
ownerid INDEX 3 ownerid
formtype INDEX 3 formtype
createdate INDEX 3 createdate
contactform INDEX 3 contactform
usecaptcha INDEX 3 usecaptcha
design_3 INDEX 3 design
usecaptcha_2 INDEX 3 usecaptcha
formtype_2 INDEX 3 formtype
createdate_4 INDEX 3 createdate
formid_4 INDEX 3 formid
requireconfirm_2 INDEX 3 requireconfirm
ownerid_2 INDEX 3 ownerid
chooseformat_2 INDEX 3 chooseformat
changeformat_2 INDEX 3 changeformat
sendthanks_2 INDEX 3 sendthanks
name_4 INDEX 3 name
contactform_2 INDEX 3 contactform
ownerid_3 INDEX 3 ownerid
formid_5 INDEX 3 formid
name_5 INDEX 3 name
design_5 INDEX 3 design
chooseformat_3 INDEX 3 chooseformat
changeformat_3 INDEX 3 changeformat
sendthanks_3 INDEX 3 sendthanks
requireconfirm_3 INDEX 3 requireconfirm
design_7 INDEX 3 design
formtype_3 INDEX 3 formtype
chooseformat_4 INDEX 3 chooseformat
requireconfirm_4 INDEX 3 requireconfirm
ownerid_4 INDEX 3 ownerid
createdate_5 INDEX 3 createdate
usecaptcha_3 INDEX 3 usecaptcha
formid_8 INDEX 3 formid
name_8 INDEX 3 name
contactform_3 INDEX 3 contactform
changeformat_4 INDEX 3 changeformat
sendthanks_4 INDEX 3 sendthanks
requireconfirm_5 INDEX 3 requireconfirm
formtype_4 INDEX 3 formtype


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 3
Row length ø 5,461
Row size  ø 349,525 Bytes
Next Autoindex 4
Creation Apr 25, 2024 at 04:50 PM