Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_newslettersemail_newsletters
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

InnoDB free: 730112 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_newsletters`
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_newsletters.newsletterid 1 30 1 2 0 0 15.1364 9.1914 ENUM('1','2','3','4','7','8','9','10','11','12','1...
puroparty.email_newsletters.name 80s & 90s Fest Test 1 Campaign 5 37 0 0 21.6364 NULL ENUM('80s & 90s Fest','Alejandra, Little Texas at ...
puroparty.email_newsletters.format b b 1 1 0 0 1.0000 NULL ENUM('b') NOT NULL
puroparty.email_newsletters.subject Census Expo! Prizes and Entertainment! Smokin Tejanos at Frontier Fiesta Cook-off 20 50 0 0 29.5455 NULL ENUM('Census Expo! Prizes and Entertainment!','Jai...
puroparty.email_newsletters.textbody %%unsubscribelink%%Your email client cannot read t... Your email client cannot read this email.\r\nTo view... 148 167 0 0 149.7273 NULL ENUM('%%unsubscribelink%%Your email client cannot ...
puroparty.email_newsletters.htmlbody <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Trans... <html><head>\r\n<meta content="MSHTML 6.00.6000.1671... 1450 7018 0 0 3972.6364 NULL TEXT NOT NULL
puroparty.email_newsletters.createdate 1219291610 1269577689 10 10 0 0 1235124513.0909 0.0000 ENUM('1219291610','1220652505','1224237249','12248...
puroparty.email_newsletters.active 0 1 1 1 21 0 0.0455 0.2083 ENUM('0','1') NOT NULL
puroparty.email_newsletters.archive 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.email_newsletters.ownerid 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL


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