Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.extcal_users.user_id |
1 |
25 |
1 |
2 |
0 |
0 |
13.0000 |
7.2111 |
ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_users.username |
amellado |
test2 |
4 |
13 |
0 |
0 |
7.7600 |
NULL |
ENUM('amellado','Annabad','badame','bar0404','chri... |
puroparty.extcal_users.password |
098f6bcd4621d373cade4e832627b4f6 |
f80b2a97b5f7f20297356c88fea52cb7 |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('098f6bcd4621d373cade4e832627b4f6','16b5f0187... |
puroparty.extcal_users.firstname |
admin |
test |
3 |
9 |
7 |
0 |
3.9200 |
NULL |
ENUM('','admin','Alice','Anna','Barbara','Dana','d... |
puroparty.extcal_users.lastname |
|
VILLARREAL |
0 |
10 |
8 |
0 |
4.6000 |
NULL |
ENUM('','Benavidez','coronado','Espinoza','Flores'... |
puroparty.extcal_users.group_id |
1 |
5 |
1 |
1 |
0 |
0 |
2.9200 |
0.6882 |
ENUM('1','3','5') NOT NULL |
puroparty.extcal_users.lastvisit |
2006-02-09 19:56:06 |
2007-01-02 23:03:29 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2006-02-09 19:56:06','2006-02-14 14:50:44','... |
puroparty.extcal_users.email |
allofusforever@yahoo.com |
vettyrcian@yahoo.com |
13 |
32 |
0 |
0 |
21.8000 |
NULL |
ENUM('allofusforever@yahoo.com','amellado@houston.... |
puroparty.extcal_users.user_regdate |
2006-01-04 10:17:47 |
2006-12-21 10:20:09 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2006-01-04 10:17:47','2006-01-04 10:45:56','... |
puroparty.extcal_users.user_lang |
|
|
0 |
0 |
25 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.extcal_users.user_website |
|
yahoo |
0 |
5 |
23 |
0 |
0.3600 |
NULL |
ENUM('','test','yahoo') NOT NULL |
puroparty.extcal_users.user_location |
|
test |
0 |
27 |
14 |
0 |
4.4800 |
NULL |
ENUM('','Bellaire/West U','Houston','houston, texa... |
puroparty.extcal_users.user_occupation |
|
youth alcohol/drug prevention instructor |
0 |
40 |
12 |
0 |
7.5200 |
NULL |
ENUM('','Bartender','Bookkeeper','bus driver','Com... |
puroparty.extcal_users.reg_key |
|
|
0 |
0 |
23 |
2 |
0.0000 |
NULL |
CHAR(0) |
puroparty.extcal_users.user_status |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |