Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.phorum_users.user_id |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.phorum_users.username |
ppcru |
ppcru |
5 |
5 |
0 |
0 |
5.0000 |
NULL |
ENUM('ppcru') NOT NULL |
puroparty.phorum_users.password |
e31d751f28059199c5fb61cb3e3997cb |
e31d751f28059199c5fb61cb3e3997cb |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('e31d751f28059199c5fb61cb3e3997cb') NOT NULL |
puroparty.phorum_users.cookie_sessid_lt |
4face78eadbf6d3988bd8c6df0ff5699 |
4face78eadbf6d3988bd8c6df0ff5699 |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('4face78eadbf6d3988bd8c6df0ff5699') NOT NULL |
puroparty.phorum_users.sessid_st |
|
|
0 |
0 |
1 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.phorum_users.sessid_st_timeout |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.password_temp |
e31d751f28059199c5fb61cb3e3997cb |
e31d751f28059199c5fb61cb3e3997cb |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('e31d751f28059199c5fb61cb3e3997cb') NOT NULL |
puroparty.phorum_users.email |
robert1999@gmail.com |
robert1999@gmail.com |
20 |
20 |
0 |
0 |
20.0000 |
NULL |
ENUM('robert1999@gmail.com') NOT NULL |
puroparty.phorum_users.email_temp |
|
|
0 |
0 |
1 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.phorum_users.hide_email |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.active |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.phorum_users.user_data |
NULL |
NULL |
0 |
0 |
0 |
1 |
0.0 |
NULL |
CHAR(0) |
puroparty.phorum_users.signature |
NULL |
NULL |
0 |
0 |
0 |
1 |
0.0 |
NULL |
CHAR(0) |
puroparty.phorum_users.threaded_list |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.posts |
2 |
2 |
1 |
1 |
0 |
0 |
2.0000 |
0.0000 |
ENUM('2') NOT NULL |
puroparty.phorum_users.admin |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.phorum_users.threaded_read |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.date_added |
1182891458 |
1182891458 |
10 |
10 |
0 |
0 |
1182891458.0000 |
0.0000 |
ENUM('1182891458') NOT NULL |
puroparty.phorum_users.date_last_active |
1182891458 |
1182891458 |
10 |
10 |
0 |
0 |
1182891458.0000 |
0.0000 |
ENUM('1182891458') NOT NULL |
puroparty.phorum_users.last_active_forum |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.hide_activity |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.show_signature |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.email_notify |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.pm_email_notify |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.phorum_users.tz_offset |
-99 |
-99 |
3 |
3 |
0 |
0 |
-99.0000 |
0.0000 |
ENUM('-99') NOT NULL |
puroparty.phorum_users.is_dst |
0 |
0 |
1 |
1 |
1 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_users.user_language |
|
|
0 |
0 |
1 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.phorum_users.user_template |
|
|
0 |
0 |
1 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.phorum_users.moderator_data |
NULL |
NULL |
0 |
0 |
0 |
1 |
0.0 |
NULL |
CHAR(0) |
puroparty.phorum_users.moderation_email |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |