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

email_customfields

Table comments : InnoDB free: 780288 kB

Field Type Null Default
fieldid  int(11) No   
name  varchar(255) Yes  NULL 
fieldtype  varchar(100) Yes  NULL 
defaultvalue  varchar(255) Yes  NULL 
required  char(1) Yes 
fieldsettings  mediumtext Yes  NULL 
createdate  int(11) Yes 
ownerid  int(11) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 9 fieldid
fieldid_2 UNIQUE 9 fieldid
fieldid_4 UNIQUE 9 fieldid
fieldid_6 UNIQUE 9 fieldid
fieldid_7 UNIQUE 9 fieldid
fieldid_9 UNIQUE 9 fieldid
fieldid_12 UNIQUE 9 fieldid
name_2 UNIQUE 9 name
createdate_2 UNIQUE 9 createdate
name_3 UNIQUE 9 name
createdate_4 UNIQUE 9 createdate
createdate_5 UNIQUE 9 createdate
name_6 UNIQUE 9 name
createdate_7 UNIQUE 9 createdate
name_7 UNIQUE 9 name
createdate_9 UNIQUE 9 createdate
name_10 UNIQUE 9 name
createdate_11 UNIQUE 9 createdate
createdate_12 UNIQUE 9 createdate
email_customfields_owner_idx INDEX 2 ownerid
email_customfield_id_name INDEX 9 fieldid
name
fieldid INDEX 9 fieldid
name INDEX 9 name
fieldtype INDEX 9 fieldtype
defaultvalue INDEX 4 defaultvalue
required INDEX 2 required
createdate INDEX 9 createdate
ownerid INDEX 2 ownerid
fieldid_3 INDEX 9 fieldid
createdate_3 INDEX 9 createdate
ownerid_2 INDEX 2 ownerid
defaultvalue_2 INDEX 4 defaultvalue
required_2 INDEX 2 required
fieldtype_2 INDEX 9 fieldtype
name_4 INDEX 9 name
fieldid_5 INDEX 9 fieldid
name_5 INDEX 9 name
fieldtype_3 INDEX 9 fieldtype
defaultvalue_3 INDEX 4 defaultvalue
required_3 INDEX 2 required
createdate_6 INDEX 9 createdate
ownerid_3 INDEX 2 ownerid
required_4 INDEX 2 required
ownerid_4 INDEX 2 ownerid
defaultvalue_4 INDEX 4 defaultvalue
createdate_8 INDEX 9 createdate
fieldtype_4 INDEX 9 fieldtype
name_8 INDEX 9 name
fieldid_8 INDEX 9 fieldid
ownerid_5 INDEX 2 ownerid
name_9 INDEX 9 name
required_5 INDEX 2 required
required_6 INDEX 2 required
createdate_10 INDEX 9 createdate
ownerid_6 INDEX 2 ownerid
defaultvalue_5 INDEX 4 defaultvalue
fieldtype_5 INDEX 9 fieldtype
fieldtype_6 INDEX 9 fieldtype
defaultvalue_6 INDEX 4 defaultvalue
name_11 INDEX 9 name
createdate_13 INDEX 9 createdate
fieldid_10 INDEX 9 fieldid
fieldid_11 INDEX 9 fieldid
name_12 INDEX 9 name


 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 11
Creation Apr 14, 2018 at 05:57 PM