Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.extcal2_users.user_id |
1 |
4 |
1 |
1 |
0 |
0 |
2.5000 |
1.1180 |
ENUM('1','2','3','4') NOT NULL |
puroparty.extcal2_users.username |
layla |
thebigblogger |
5 |
13 |
0 |
0 |
8.5000 |
NULL |
ENUM('layla','puroparty','test123','thebigblogger'... |
puroparty.extcal2_users.password |
098f6bcd4621d373cade4e832627b4f6 |
e31d751f28059199c5fb61cb3e3997cb |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('098f6bcd4621d373cade4e832627b4f6','9d5e3ecde... |
puroparty.extcal2_users.firstname |
charlie |
Mr. |
3 |
7 |
1 |
0 |
3.7500 |
NULL |
ENUM('','charlie','layla','Mr.') NOT NULL |
puroparty.extcal2_users.lastname |
Administrator |
t |
1 |
13 |
1 |
0 |
5.5000 |
NULL |
ENUM('','Administrator','cardenas','t') NOT NULL |
puroparty.extcal2_users.group_id |
1 |
5 |
1 |
1 |
0 |
0 |
3.0000 |
1.4142 |
ENUM('1','3','5') NOT NULL |
puroparty.extcal2_users.lastvisit |
2007-01-02 22:17:01 |
2007-01-02 23:33:44 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2007-01-02 22:17:01','2007-01-02 23:07:44','... |
puroparty.extcal2_users.email |
layla@puroparty.com |
robert@puroparty.com |
18 |
20 |
0 |
0 |
19.2500 |
NULL |
ENUM('layla@puroparty.com','news@puroparty.com','r... |
puroparty.extcal2_users.user_regdate |
2006-12-21 15:59:09 |
2007-01-02 22:17:01 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2006-12-21 15:59:09','2006-12-29 18:00:59','... |
puroparty.extcal2_users.user_lang |
|
|
0 |
0 |
4 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.extcal2_users.user_website |
|
|
0 |
0 |
4 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.extcal2_users.user_location |
|
houston |
0 |
9 |
2 |
0 |
4.0000 |
NULL |
ENUM('','bellville','houston') NOT NULL |
puroparty.extcal2_users.user_occupation |
|
story teller |
0 |
13 |
2 |
0 |
6.2500 |
NULL |
ENUM('','picker/packer','story teller') NOT NULL |
puroparty.extcal2_users.reg_key |
340a86cbeb0f504fcab4a24cfe07dbc4 |
3f41ced368afdebd34578aea1e3af729 |
32 |
32 |
0 |
2 |
32.0000 |
NULL |
ENUM('340a86cbeb0f504fcab4a24cfe07dbc4','3f41ced36... |
puroparty.extcal2_users.user_status |
1 |
1 |
1 |
1 |
1 |
0 |
0.7500 |
0.4330 |
ENUM('0','1') NOT NULL |