Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.networkgirls.id |
1 |
107 |
1 |
3 |
0 |
0 |
54.0000 |
30.8869 |
TINYINT(3) UNSIGNED NOT NULL |
puroparty.networkgirls.fname |
Amanda |
Ximena |
3 |
10 |
0 |
0 |
5.8131 |
NULL |
ENUM('Amanda','Amarie','Amy','Andrea','Bea','Bessi... |
puroparty.networkgirls.lname |
Aguilar |
Zepeda |
3 |
16 |
0 |
0 |
6.5794 |
NULL |
ENUM('Aguilar','Aleman','Arriaga','Bernal','Bernar... |
puroparty.networkgirls.address |
1020 Pathfinder |
9898 Colonnade #9204 |
10 |
26 |
0 |
0 |
17.4206 |
NULL |
ENUM('1020 Pathfinder','105 W. Ruben Torres','1107... |
puroparty.networkgirls.city |
Amarillo |
Weslaco |
4 |
14 |
0 |
0 |
8.0280 |
NULL |
ENUM('Amarillo','Argyle','Austin','Brownsville','C... |
puroparty.networkgirls.state |
TX |
TX |
2 |
2 |
1 |
0 |
1.9813 |
NULL |
ENUM('','TX') NOT NULL |
puroparty.networkgirls.zip |
75125 |
79936 |
5 |
5 |
0 |
0 |
5.0000 |
NULL |
ENUM('75125','75211','76226','76904','76905','7701... |
puroparty.networkgirls.phone |
(806) 790-6479 |
972-345-1357 |
12 |
14 |
0 |
0 |
12.0561 |
NULL |
ENUM('(806) 790-6479','1-713-992-3291','210-219-18... |
puroparty.networkgirls.bilingual |
No\r |
Yes\r |
3 |
4 |
0 |
0 |
3.6355 |
NULL |
ENUM('No\r','Yes\r') NOT NULL |
puroparty.networkgirls.pic |
|
|
0 |
0 |
107 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |