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

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
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext 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
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     No    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 23  Edit Drop newsletterid
newsletterid_2 UNIQUE 23  Edit Drop newsletterid
newsletterid_3 UNIQUE 23  Edit Drop newsletterid
newsletterid_6 UNIQUE 23  Edit Drop newsletterid
newsletterid_7 UNIQUE 23  Edit Drop newsletterid
newsletterid_10 UNIQUE 23  Edit Drop newsletterid
newsletterid_12 UNIQUE 23  Edit Drop newsletterid
newsletterid_14 UNIQUE 23  Edit Drop newsletterid
name_2 UNIQUE 23  Edit Drop name
name_3 UNIQUE 23  Edit Drop name
name_6 UNIQUE 23  Edit Drop name
name_7 UNIQUE 23  Edit Drop name
name_10 UNIQUE 23  Edit Drop name
email_newsletters_owner_idx INDEX Edit Drop ownerid
newsletterid INDEX 23  Edit Drop newsletterid
name INDEX 23  Edit Drop name
format INDEX Edit Drop format
subject INDEX 23  Edit Drop subject
createdate INDEX 23  Edit Drop createdate
active INDEX Edit Drop active
archive INDEX Edit Drop archive
ownerid INDEX Edit Drop ownerid
subject_2 INDEX 23  Edit Drop subject
ownerid_2 INDEX Edit Drop ownerid
newsletterid_4 INDEX 23  Edit Drop newsletterid
createdate_2 INDEX 23  Edit Drop createdate
name_4 INDEX 23  Edit Drop name
active_2 INDEX Edit Drop active
archive_2 INDEX Edit Drop archive
format_2 INDEX Edit Drop format
name_5 INDEX 23  Edit Drop name
subject_3 INDEX 23  Edit Drop subject
format_3 INDEX Edit Drop format
ownerid_3 INDEX Edit Drop ownerid
newsletterid_5 INDEX 23  Edit Drop newsletterid
active_3 INDEX Edit Drop active
createdate_3 INDEX 23  Edit Drop createdate
archive_3 INDEX Edit Drop archive
ownerid_4 INDEX Edit Drop ownerid
subject_4 INDEX 23  Edit Drop subject
archive_4 INDEX Edit Drop archive
createdate_4 INDEX 23  Edit Drop createdate
active_4 INDEX Edit Drop active
newsletterid_8 INDEX 23  Edit Drop newsletterid
name_8 INDEX 23  Edit Drop name
format_4 INDEX Edit Drop format
archive_5 INDEX Edit Drop archive
archive_6 INDEX Edit Drop archive
subject_5 INDEX 23  Edit Drop subject
ownerid_5 INDEX Edit Drop ownerid
createdate_5 INDEX 23  Edit Drop createdate
newsletterid_9 INDEX 23  Edit Drop newsletterid
name_9 INDEX 23  Edit Drop name
active_5 INDEX Edit Drop active
subject_6 INDEX 23  Edit Drop subject
ownerid_6 INDEX Edit Drop ownerid
format_5 INDEX Edit Drop format
createdate_6 INDEX 23  Edit Drop createdate
active_6 INDEX Edit Drop active
name_11 INDEX 23  Edit Drop name
newsletterid_11 INDEX 23  Edit Drop newsletterid
ownerid_7 INDEX Edit Drop ownerid
subject_7 INDEX 23  Edit Drop subject
newsletterid_13 INDEX 23  Edit Drop newsletterid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 147,456 Bytes
Index 1,008 KB
Total 1,152 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 31
Creation Jun 08, 2018 at 02:20 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: