Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.extcal_1users.user_id |
1 |
15 |
1 |
2 |
0 |
0 |
8.0000 |
4.3205 |
ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_1users.username |
angel1150 |
reyesbe |
4 |
13 |
0 |
0 |
7.6667 |
NULL |
ENUM('angel1150','anon','bidaddylou210','Camel','d... |
puroparty.extcal_1users.password |
9abec23ea7ab584b377cfc6e419e60be |
f9815a7103c124304263de8276c13143 |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('9abec23ea7ab584b377cfc6e419e60be','a6ebe407f... |
puroparty.extcal_1users.firstname |
Ana |
Mr. |
3 |
9 |
4 |
0 |
4.2667 |
NULL |
ENUM('','Ana','angel','Bernice','Cynthia','Deanna'... |
puroparty.extcal_1users.lastname |
Administrator |
Saenz |
5 |
13 |
4 |
0 |
5.5333 |
NULL |
ENUM('','Administrator','bustamante','Castillo','E... |
puroparty.extcal_1users.group_id |
1 |
6 |
1 |
1 |
0 |
0 |
3.0667 |
1.1813 |
ENUM('1','3','5','6') NOT NULL |
puroparty.extcal_1users.lastvisit |
2007-04-08 23:13:45 |
2007-11-08 01:28:02 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2007-04-08 23:13:45','2007-04-08 23:18:35','... |
puroparty.extcal_1users.email |
angel1150@hotmail.com |
rsoto@puroparty.com |
16 |
29 |
0 |
0 |
20.6000 |
NULL |
ENUM('angel1150@hotmail.com','bernice.reyes@UBS.CO... |
puroparty.extcal_1users.user_regdate |
2007-04-08 12:41:53 |
2007-11-08 01:28:02 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2007-04-08 12:41:53','2007-04-08 23:01:08','... |
puroparty.extcal_1users.user_lang |
|
|
0 |
0 |
15 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.extcal_1users.user_website |
|
n/a |
0 |
19 |
12 |
0 |
1.6667 |
NULL |
ENUM('','mcm07@sbcglobal.net','msn','n/a') NOT NUL... |
puroparty.extcal_1users.user_location |
|
san antonio,tx |
0 |
14 |
9 |
0 |
4.1333 |
NULL |
ENUM('','Arizona','houston','Houston, texas','hous... |
puroparty.extcal_1users.user_occupation |
|
production operator |
0 |
26 |
9 |
0 |
6.4000 |
NULL |
ENUM('','accordion player','Bank Specialist','corn... |
puroparty.extcal_1users.reg_key |
106056fadb405d90980ed207ca2a40f2 |
f1784cea2f29ae66cce71f3c0f0a2cd2 |
32 |
32 |
4 |
1 |
22.8571 |
NULL |
ENUM('','106056fadb405d90980ed207ca2a40f2','1cf095... |
puroparty.extcal_1users.user_status |
1 |
1 |
1 |
1 |
6 |
0 |
0.6000 |
0.4899 |
ENUM('0','1') NOT NULL |