Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bosdevUUSbosdevUUS

SQL-query
SQL-query: 
SELECT *
FROM `bosdevUUS`
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.bosdevUUS.id 1 123 1 3 0 0 62.0000 35.5059 TINYINT(3) UNSIGNED NOT NULL
puroparty.bosdevUUS.username AGarcia vero0902 2 29 0 0 8.5935 NULL ENUM('AGarcia','alice nieto','Angela','angelalopez...
puroparty.bosdevUUS.password 01fd609c6cdd5287736f39c7c7182859 fff56fa2f71b1bffda901e41803f4fdc 32 32 0 0 32.0000 NULL ENUM('01fd609c6cdd5287736f39c7c7182859','02a567e55...
puroparty.bosdevUUS.email a.munoz@ssss.com will1392@hotmail.com 14 35 0 0 21.6179 NULL ENUM('a.munoz@ssss.com','admin@thejohnnybravoband....
puroparty.bosdevUUS.status 1 1 1 1 38 0 0.6911 0.4621 ENUM('0','1') NOT NULL
puroparty.bosdevUUS.last_login 0000-00-00 2010-03-08 10 10 0 0 10.0000 NULL ENUM('0000-00-00','2007-09-21','2007-10-03','2007-...
puroparty.bosdevUUS.bd1 0 0 1 1 123 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bosdevUUS.bd2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bd3     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bd4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bd5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bc1 1 2 1 1 119 0 0.0569 0.3201 ENUM('0','1','2') NOT NULL
puroparty.bosdevUUS.bc2 0 1 1 1 0 0 1.0000 NULL ENUM('0','1') NOT NULL
puroparty.bosdevUUS.bc3 0.00 240, 4 4 120 0 0.0976 NULL ENUM('','0.00','240,') NOT NULL
puroparty.bosdevUUS.bc4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bc5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bdir1 0 0 1 1 123 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bosdevUUS.bdir2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bdir3     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bdir4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bdir5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bm1 0 0 1 1 123 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bosdevUUS.bm2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bm3     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bm4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bm5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bn1 0 0 1 1 123 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bosdevUUS.bn2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bn3     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bn4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bn5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bf1     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bf2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bf3     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bf4     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bf5     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.bdl     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.extraFName   Roy 0 5 119 0 0.1301 NULL ENUM('','Alex','Elsa','Jesse','Roy') NOT NULL
puroparty.bosdevUUS.extraLName   Rodriguez 0 9 119 0 0.2114 NULL ENUM('','Garibay','Meza','Molano','Rodriguez') NOT...
puroparty.bosdevUUS.extraAddr1   3507 Penwood Way 0 24 121 0 0.3252 NULL ENUM('','1421 Preston @ La Branch','3507 Penwood W...
puroparty.bosdevUUS.extraAddr2     0 0 123 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.bosdevUUS.extraCity   Houston 0 7 120 0 0.1707 NULL ENUM('','Houston') NOT NULL
puroparty.bosdevUUS.extraState   Tx 0 5 120 0 0.0976 NULL ENUM('','Texas','Tx') NOT NULL
puroparty.bosdevUUS.extraPostal   77023 0 5 121 0 0.0813 NULL ENUM('','77002','77023') NOT NULL
puroparty.bosdevUUS.extraHPhone   713-641-5781 0 12 121 0 0.1951 NULL ENUM('','713 236 1300','713-641-5781') NOT NULL
puroparty.bosdevUUS.extraMPhone   832-289-8311 0 12 119 0 0.3740 NULL ENUM('','713-498-5776','7134786418','832 661 8814'...



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