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

InnoDB free: 777216 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_jobs`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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



Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport