Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 09:52 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_forms` 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_forms.formid | 1 | 3 | 1 | 1 | 0 | 0 | 2.0000 | 0.8165 | ENUM('1','2','3') NOT NULL |
puroparty.email_forms.name | Hispanic Democrats For McCain | site subscribe | 14 | 29 | 0 | 0 | 20.6667 | NULL | ENUM('Hispanic Democrats For McCain','PuroParty Subscribe','site subscribe') NOT NULL |
puroparty.email_forms.design | blue | Simple Blue | 4 | 21 | 0 | 0 | 12.0000 | NULL | ENUM('blue','HTML Only (No design)','Simple Blue') NOT NULL |
puroparty.email_forms.formhtml | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.email_forms.chooseformat | c | fh | 1 | 2 | 0 | 0 | 1.6667 | NULL | ENUM('c','fh') NOT NULL |
puroparty.email_forms.changeformat | 0 | 0 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0') NOT NULL |
puroparty.email_forms.sendthanks | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('1') NOT NULL |
puroparty.email_forms.requireconfirm | 0 | 1 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0','1') NOT NULL |
puroparty.email_forms.ownerid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.email_forms.formtype | s | s | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('s') NOT NULL |
puroparty.email_forms.createdate | 1219289720 | 1239001045 | 10 | 10 | 0 | 0 | 1226444827.6667 | 1431683474.9555 | ENUM('1219289720','1221043718','1239001045') NOT NULL |
puroparty.email_forms.contactform | 0 | 1 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0','1') NOT NULL |
puroparty.email_forms.usecaptcha | 0 | 0 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0') NOT NULL |