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

InnoDB free: 775168 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
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   text 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
   varchar(255) 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)     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 64  Edit Drop jobid
jobid_2 UNIQUE 64  Edit Drop jobid
jobid_4 UNIQUE 64  Edit Drop jobid
jobid_6 UNIQUE 64  Edit Drop jobid
jobid_8 UNIQUE 64  Edit Drop jobid
jobtime_2 UNIQUE 64  Edit Drop jobtime
lastupdatetime_2 UNIQUE 64  Edit Drop lastupdatetime
queueid_2 UNIQUE 64  Edit Drop queueid
lastupdatetime_3 UNIQUE 64  Edit Drop lastupdatetime
queueid_4 UNIQUE 64  Edit Drop queueid
jobtime_4 UNIQUE 64  Edit Drop jobtime
queueid_6 UNIQUE 64  Edit Drop queueid
lastupdatetime_6 UNIQUE 64  Edit Drop lastupdatetime
jobtime_6 UNIQUE 64  Edit Drop jobtime
queueid_7 UNIQUE 64  Edit Drop queueid
email_jobs_fkid_idx INDEX 64  Edit Drop fkid
email_jobs_jobtime_idx INDEX 64  Edit Drop jobtime
email_jobs_queue_idx INDEX 64  Edit Drop queueid
email_jobs_owner_idx INDEX Edit Drop ownerid
jobid INDEX 64  Edit Drop jobid
jobtype INDEX Edit Drop jobtype
jobstatus INDEX Edit Drop jobstatus
jobtime INDEX 64  Edit Drop jobtime
fkid INDEX 64  Edit Drop fkid
lastupdatetime INDEX 64  Edit Drop lastupdatetime
fktype INDEX Edit Drop fktype
queueid INDEX 64  Edit Drop queueid
ownerid INDEX Edit Drop ownerid
approved INDEX Edit Drop approved
authorisedtosend INDEX Edit Drop authorisedtosend
resendcount INDEX Edit Drop resendcount
jobstatus_2 INDEX Edit Drop jobstatus
ownerid_2 INDEX Edit Drop ownerid
resendcount_2 INDEX Edit Drop resendcount
approved_2 INDEX Edit Drop approved
queueid_3 INDEX 64  Edit Drop queueid
jobtime_3 INDEX 64  Edit Drop jobtime
fkid_2 INDEX 64  Edit Drop fkid
lastupdatetime_4 INDEX 64  Edit Drop lastupdatetime
jobtype_2 INDEX Edit Drop jobtype
jobid_3 INDEX 64  Edit Drop jobid
authorisedtosend_2 INDEX Edit Drop authorisedtosend
fktype_2 INDEX Edit Drop fktype
jobid_5 INDEX 64  Edit Drop jobid
resendcount_3 INDEX Edit Drop resendcount
fkid_3 INDEX 64  Edit Drop fkid
lastupdatetime_5 INDEX 64  Edit Drop lastupdatetime
queueid_5 INDEX 64  Edit Drop queueid
jobtime_5 INDEX 64  Edit Drop jobtime
ownerid_3 INDEX Edit Drop ownerid
jobstatus_3 INDEX Edit Drop jobstatus
approved_3 INDEX Edit Drop approved
jobid_7 INDEX 64  Edit Drop jobid
authorisedtosend_3 INDEX Edit Drop authorisedtosend
jobtype_3 INDEX Edit Drop jobtype
fktype_3 INDEX Edit Drop fktype
resendcount_4 INDEX Edit Drop resendcount
fkid_4 INDEX 64  Edit Drop fkid
fktype_4 INDEX Edit Drop fktype
authorisedtosend_4 INDEX Edit Drop authorisedtosend
lastupdatetime_7 INDEX 64  Edit Drop lastupdatetime
jobtype_4 INDEX Edit Drop jobtype
queueid_8 INDEX 64  Edit Drop queueid
fkid_5 INDEX 64  Edit Drop fkid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 98,304 Bytes
Index 1,008 KB
Total 1,104 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 76
Creation May 20, 2018 at 01:50 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: