Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 02:05 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_customfields` PROCEDURE ANALYSE();
Rows: 8
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.email_customfields.fieldid | 1 | 10 | 1 | 2 | 0 | 0 | 5.6667 | 2.9814 | ENUM('1','2','3','5','6','7','8','9','10') NOT NUL... |
puroparty.email_customfields.name | Address 1 | Zip Code | 3 | 10 | 0 | 0 | 7.0000 | NULL | ENUM('Address 1','Address 2','Age','City','First N... |
puroparty.email_customfields.fieldtype | dropdown | text | 4 | 8 | 0 | 0 | 4.8889 | NULL | ENUM('dropdown','number','text') NOT NULL |
puroparty.email_customfields.defaultvalue | Select | Select | 6 | 6 | 8 | 0 | 0.6667 | NULL | ENUM('','Select') NOT NULL |
puroparty.email_customfields.required | 0 | 0 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0') NOT NULL |
puroparty.email_customfields.fieldsettings | a:2:{s:3:"Key";a:2:{i:0;s:1:"m";i:1;s:1:"f";}s:5:"... | a:3:{s:9:"MinLength";s:1:"7";s:9:"MaxLength";s:1:"... | 79 | 88 | 0 | 0 | 82.1111 | NULL | ENUM('a:2:{s:3:"Key";a:2:{i:0;s:1:"m";i:1;s:1:"f";... |
puroparty.email_customfields.createdate | 1219289893 | 1221690702 | 10 | 10 | 0 | 0 | 1221002790.5556 | 0.0000 | ENUM('1219289893','1219796448','1219796487','12216... |
puroparty.email_customfields.ownerid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |