Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.phorum_messages.message_id |
1 |
3 |
1 |
1 |
0 |
0 |
2.0000 |
0.8165 |
ENUM('1','2','3') NOT NULL |
puroparty.phorum_messages.forum_id |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.phorum_messages.thread |
1 |
3 |
1 |
1 |
0 |
0 |
1.6667 |
0.9428 |
ENUM('1','3') NOT NULL |
puroparty.phorum_messages.parent_id |
0 |
1 |
1 |
1 |
2 |
0 |
0.3333 |
0.4714 |
ENUM('0','1') NOT NULL |
puroparty.phorum_messages.author |
Phorum Installer |
ppcru |
5 |
16 |
0 |
0 |
8.6667 |
NULL |
ENUM('Phorum Installer','ppcru') NOT NULL |
puroparty.phorum_messages.subject |
Another Test |
Test Message |
12 |
16 |
0 |
0 |
13.3333 |
NULL |
ENUM('Another Test','Re: Test Message','Test Messa... |
puroparty.phorum_messages.body |
another tester |
This is a test message. You can delete it after i... |
7 |
88 |
0 |
0 |
36.3333 |
NULL |
ENUM('another tester','test #2','This is a test me... |
puroparty.phorum_messages.email |
|
|
0 |
0 |
3 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.phorum_messages.ip |
127.0.0.1 |
adsl-70-240-102-97.dsl.hstntx.swbell.net |
9 |
40 |
0 |
0 |
29.6667 |
NULL |
ENUM('127.0.0.1','adsl-70-240-102-97.dsl.hstntx.sw... |
puroparty.phorum_messages.status |
2 |
2 |
1 |
1 |
0 |
0 |
2.0000 |
0.0000 |
ENUM('2') NOT NULL |
puroparty.phorum_messages.msgid |
|
7f9d447641d4a155bba36f406ba300a2.TestForum |
0 |
42 |
1 |
0 |
28.0000 |
NULL |
ENUM('','430c38de1da94adb23180f35a6371a07.TestForu... |
puroparty.phorum_messages.modifystamp |
1182891684 |
1182893859 |
10 |
10 |
1 |
0 |
788595181.0000 |
557621000.0968 |
ENUM('0','1182891684','1182893859') NOT NULL |
puroparty.phorum_messages.user_id |
0 |
1 |
1 |
1 |
1 |
0 |
0.6667 |
0.4714 |
ENUM('0','1') NOT NULL |
puroparty.phorum_messages.thread_count |
1 |
2 |
1 |
1 |
1 |
0 |
1.0000 |
0.8165 |
ENUM('0','1','2') NOT NULL |
puroparty.phorum_messages.moderator_post |
0 |
1 |
1 |
1 |
1 |
0 |
0.6667 |
0.4714 |
ENUM('0','1') NOT NULL |
puroparty.phorum_messages.sort |
2 |
2 |
1 |
1 |
0 |
0 |
2.0000 |
0.0000 |
ENUM('2') NOT NULL |
puroparty.phorum_messages.datestamp |
1182891420 |
1182893859 |
10 |
10 |
0 |
0 |
1182892321.0000 |
1431655765.3338 |
ENUM('1182891420','1182891684','1182893859') NOT N... |
puroparty.phorum_messages.meta |
a:0:{} |
a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1"... |
6 |
196 |
0 |
0 |
127.3333 |
NULL |
ENUM('a:0:{}','a:3:{s:11:"recent_post";a:3:{s:7:"u... |
puroparty.phorum_messages.viewcount |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.phorum_messages.closed |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |