mysql.puroparty.com
puroparty
email_jobs
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: email_jobs
|
| Field | Type | Null | Default |
|---|---|---|---|
| jobid | int(11) | No | |
| jobtype | varchar(255) | Yes | NULL |
| jobstatus | char(1) | Yes | NULL |
| jobtime | int(11) | Yes | 0 |
| jobdetails | text | Yes | NULL |
| fkid | int(11) | Yes | 0 |
| lastupdatetime | int(11) | Yes | 0 |
| fktype | varchar(255) | Yes | NULL |
| queueid | int(11) | Yes | 0 |
| ownerid | int(11) | Yes | 0 |
| approved | int(11) | Yes | 0 |
| authorisedtosend | int(11) | Yes | 0 |
| resendcount | int(11) | Yes | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 72 | jobid | |
| jobid_2 | UNIQUE | 72 | jobid | |
| jobid_4 | UNIQUE | 72 | jobid | |
| jobid_6 | UNIQUE | 72 | jobid | |
| jobid_8 | UNIQUE | 72 | jobid | |
| jobtime_2 | UNIQUE | 72 | jobtime | |
| lastupdatetime_2 | UNIQUE | 72 | lastupdatetime | |
| queueid_2 | UNIQUE | 72 | queueid | |
| lastupdatetime_3 | UNIQUE | 72 | lastupdatetime | |
| queueid_4 | UNIQUE | 72 | queueid | |
| jobtime_4 | UNIQUE | 72 | jobtime | |
| queueid_6 | UNIQUE | 72 | queueid | |
| lastupdatetime_6 | UNIQUE | 72 | lastupdatetime | |
| jobtime_6 | UNIQUE | 72 | jobtime | |
| queueid_7 | UNIQUE | 72 | queueid | |
| email_jobs_fkid_idx | INDEX | 36 | fkid | |
| email_jobs_jobtime_idx | INDEX | 72 | jobtime | |
| email_jobs_queue_idx | INDEX | 72 | queueid | |
| email_jobs_owner_idx | INDEX | 1 | ownerid | |
| jobid | INDEX | 72 | jobid | |
| jobtype | INDEX | 1 | jobtype | |
| jobstatus | INDEX | 6 | jobstatus | |
| jobtime | INDEX | 72 | jobtime | |
| fkid | INDEX | 36 | fkid | |
| lastupdatetime | INDEX | 72 | lastupdatetime | |
| fktype | INDEX | 1 | fktype | |
| queueid | INDEX | 72 | queueid | |
| ownerid | INDEX | 1 | ownerid | |
| approved | INDEX | 1 | approved | |
| authorisedtosend | INDEX | 1 | authorisedtosend | |
| resendcount | INDEX | 3 | resendcount | |
| jobstatus_2 | INDEX | 6 | jobstatus | |
| ownerid_2 | INDEX | 1 | ownerid | |
| resendcount_2 | INDEX | 3 | resendcount | |
| approved_2 | INDEX | 1 | approved | |
| queueid_3 | INDEX | 72 | queueid | |
| jobtime_3 | INDEX | 72 | jobtime | |
| fkid_2 | INDEX | 36 | fkid | |
| lastupdatetime_4 | INDEX | 72 | lastupdatetime | |
| jobtype_2 | INDEX | 1 | jobtype | |
| jobid_3 | INDEX | 72 | jobid | |
| authorisedtosend_2 | INDEX | 1 | authorisedtosend | |
| fktype_2 | INDEX | 1 | fktype | |
| jobid_5 | INDEX | 72 | jobid | |
| resendcount_3 | INDEX | 3 | resendcount | |
| fkid_3 | INDEX | 36 | fkid | |
| lastupdatetime_5 | INDEX | 72 | lastupdatetime | |
| queueid_5 | INDEX | 72 | queueid | |
| jobtime_5 | INDEX | 72 | jobtime | |
| ownerid_3 | INDEX | 1 | ownerid | |
| jobstatus_3 | INDEX | 6 | jobstatus | |
| approved_3 | INDEX | 1 | approved | |
| jobid_7 | INDEX | 72 | jobid | |
| authorisedtosend_3 | INDEX | 1 | authorisedtosend | |
| jobtype_3 | INDEX | 1 | jobtype | |
| fktype_3 | INDEX | 1 | fktype | |
| resendcount_4 | INDEX | 3 | resendcount | |
| fkid_4 | INDEX | 36 | fkid | |
| fktype_4 | INDEX | 1 | fktype | |
| authorisedtosend_4 | INDEX | 1 | authorisedtosend | |
| lastupdatetime_7 | INDEX | 72 | lastupdatetime | |
| jobtype_4 | INDEX | 1 | jobtype | |
| queueid_8 | INDEX | 72 | queueid | |
| fkid_5 | INDEX | 36 | fkid | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||