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

InnoDB free: 739328 kB

SQL-query
SQL-query: 
SELECT *
FROM `email_customfields`
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_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


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