Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 02:58 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_newsletters` PROCEDURE ANALYSE();
Rows: 10
| 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 |