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

InnoDB free: 777216 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    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
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 Edit Drop fieldid
fieldid_2 UNIQUE Edit Drop fieldid
fieldid_4 UNIQUE Edit Drop fieldid
fieldid_6 UNIQUE Edit Drop fieldid
fieldid_7 UNIQUE Edit Drop fieldid
fieldid_9 UNIQUE Edit Drop fieldid
fieldid_12 UNIQUE Edit Drop fieldid
name_2 UNIQUE Edit Drop name
createdate_2 UNIQUE Edit Drop createdate
name_3 UNIQUE Edit Drop name
createdate_4 UNIQUE Edit Drop createdate
createdate_5 UNIQUE Edit Drop createdate
name_6 UNIQUE Edit Drop name
createdate_7 UNIQUE Edit Drop createdate
name_7 UNIQUE Edit Drop name
createdate_9 UNIQUE Edit Drop createdate
name_10 UNIQUE Edit Drop name
createdate_11 UNIQUE Edit Drop createdate
createdate_12 UNIQUE Edit Drop createdate
email_customfields_owner_idx INDEX Edit Drop ownerid
email_customfield_id_name INDEX Edit Drop fieldid
name
fieldid INDEX Edit Drop fieldid
name INDEX Edit Drop name
fieldtype INDEX Edit Drop fieldtype
defaultvalue INDEX Edit Drop defaultvalue
required INDEX Edit Drop required
createdate INDEX Edit Drop createdate
ownerid INDEX Edit Drop ownerid
fieldid_3 INDEX Edit Drop fieldid
createdate_3 INDEX Edit Drop createdate
ownerid_2 INDEX Edit Drop ownerid
defaultvalue_2 INDEX Edit Drop defaultvalue
required_2 INDEX Edit Drop required
fieldtype_2 INDEX Edit Drop fieldtype
name_4 INDEX Edit Drop name
fieldid_5 INDEX Edit Drop fieldid
name_5 INDEX Edit Drop name
fieldtype_3 INDEX Edit Drop fieldtype
defaultvalue_3 INDEX Edit Drop defaultvalue
required_3 INDEX Edit Drop required
createdate_6 INDEX Edit Drop createdate
ownerid_3 INDEX Edit Drop ownerid
required_4 INDEX Edit Drop required
ownerid_4 INDEX Edit Drop ownerid
defaultvalue_4 INDEX Edit Drop defaultvalue
createdate_8 INDEX Edit Drop createdate
fieldtype_4 INDEX Edit Drop fieldtype
name_8 INDEX Edit Drop name
fieldid_8 INDEX Edit Drop fieldid
ownerid_5 INDEX Edit Drop ownerid
name_9 INDEX Edit Drop name
required_5 INDEX Edit Drop required
required_6 INDEX Edit Drop required
createdate_10 INDEX Edit Drop createdate
ownerid_6 INDEX Edit Drop ownerid
defaultvalue_5 INDEX Edit Drop defaultvalue
fieldtype_5 INDEX Edit Drop fieldtype
fieldtype_6 INDEX Edit Drop fieldtype
defaultvalue_6 INDEX Edit Drop defaultvalue
name_11 INDEX Edit Drop name
createdate_13 INDEX Edit Drop createdate
fieldid_10 INDEX Edit Drop fieldid
fieldid_11 INDEX Edit Drop fieldid
name_12 INDEX Edit Drop name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 11
Creation Jun 19, 2018 at 10:10 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: