Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 06:58 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:... | a:22:{s:16:"NewsletterChosen";i:0;s:5:"Lists";a:1:... | 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','... |
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 |