Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 08:16 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_jobs` PROCEDURE ANALYSE();
Rows: 13
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.email_jobs.jobid | 1 | 75 | 1 | 2 | 0 | 0 | 38.4638 | 21.7799 | TINYINT(2) UNSIGNED NOT NULL |
| puroparty.email_jobs.jobtype | send | send | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('send') NOT NULL |
| puroparty.email_jobs.jobstatus | c | p | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('c','i','p') NOT NULL |
| puroparty.email_jobs.jobtime | 1219292572 | 1269646401 | 10 | 10 | 0 | 0 | 1248072816.0290 | 0.0000 | INT(10) UNSIGNED NOT NULL |
| puroparty.email_jobs.jobdetails | a:19:{s:16:"NewsletterChosen";i:0;s:5:"Lists";a:1:{i:0;s:1:"1";}s:12:"SendCriteria";a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";}s:8:"SendSize";s:1:"1";s:9:"Multipart";i:1;s:10:"TrackOpens";i:1;s:10:"TrackLinks";i:1;s:11:"EmbedImages";i:0;s:10:"Newsletter";s:1:"1";s:12:"SendFromName";s:9:"PuroParty";s:13:"SendFromEmail";s:19:"ppcru@puroparty.com";s:12:"ReplyToEmail";s:19:"ppcru@puroparty.com";s:11:"BounceEmail";s:19:"ppcru@puroparty.com";s:12:"To_FirstName";b:0;s:11:"To_LastName";b:0;s:7:"Charset";s:5:"UTF-8";s:11:"NotifyOwner";i:0;s:13:"SendStartTime";i:1219292572;s:12:"EmailResults";a:3:{s:7:"success";i:0;s:5:"total";i:0;s:7:"failure";i:0;}} | a:22:{s:16:"NewsletterChosen";i:0;s:5:"Lists";a:1:{i:0;s:1:"2";}s:12:"SendCriteria";N;s:8:"SendSize";s:4:"1139";s:8:"Segments";a:1:{i:0;s:1:"8";}s:9:"Multipart";i:1;s:10:"TrackOpens";i:1;s:10:"TrackLinks";i:0;s:11:"EmbedImages";i:0;s:10:"Newsletter";s:2:"28";s:12:"SendFromName";s:9:"PuroParty";s:13:"SendFromEmail";s:23:"puroparty@puroparty.com";s:12:"ReplyToEmail";s:23:"puroparty@puroparty.com";s:11:"BounceEmail";s:20:"events@puroparty.com";s:12:"To_FirstName";b:0;s:11:"To_LastName";b:0;s:7:"Charset";s:5:"UTF-8";s:11:"NotifyOwner";i:0;s:13:"SendStartTime";i:1258683971;s:12:"EmailResults";a:3:{s:7:"success";i:0;s:5:"total";i:0;s:7:"failure";i:0;}s:6:"StatID";i:59;s:9:"SendQueue";s:2:"60";} | 641 | 774 | 0 | 0 | 694.4058 | NULL | TEXT NOT NULL |
| puroparty.email_jobs.fkid | 1 | 30 | 1 | 2 | 0 | 0 | 19.3478 | 9.4743 | ENUM('1','2','3','4','7','9','10','11','12','13','14','15','17','21','22','24','27','28','29','30') NOT NULL |
| puroparty.email_jobs.lastupdatetime | 1219292606 | 1269646414 | 10 | 10 | 0 | 0 | 1248076528.6087 | 0.0000 | INT(10) UNSIGNED NOT NULL |
| puroparty.email_jobs.fktype | newsletter | newsletter | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('newsletter') NOT NULL |
| puroparty.email_jobs.queueid | 2 | 77 | 1 | 2 | 0 | 0 | 39.9855 | 22.2095 | TINYINT(2) UNSIGNED NOT NULL |
| puroparty.email_jobs.ownerid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.email_jobs.approved | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.email_jobs.authorisedtosend | 0 | 0 | 1 | 1 | 69 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.email_jobs.resendcount | 0 | 1 | 1 | 1 | 68 | 0 | 0.0145 | 0.1195 | ENUM('0','1') NOT NULL |