Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.photopost_categories.id |
1 |
500 |
1 |
3 |
0 |
0 |
167.6667 |
234.9955 |
ENUM('1','2','500') NOT NULL |
puroparty.photopost_categories.catname |
A Category |
Member Galleries |
4 |
16 |
0 |
0 |
10.0000 |
NULL |
ENUM('A Category','Main','Member Galleries') NOT N... |
puroparty.photopost_categories.description |
|
Photos of a particular subject |
0 |
46 |
1 |
0 |
25.3333 |
NULL |
ENUM('','Individual user galleries - any photo cat... |
puroparty.photopost_categories.catorder |
1 |
2 |
1 |
1 |
0 |
0 |
1.3333 |
0.4714 |
ENUM('1','2') NOT NULL |
puroparty.photopost_categories.thumbs |
no |
yes |
2 |
3 |
0 |
0 |
2.6667 |
NULL |
ENUM('no','yes') NOT NULL |
puroparty.photopost_categories.parent |
0 |
1 |
1 |
1 |
2 |
0 |
0.3333 |
0.4714 |
ENUM('0','1') NOT NULL |
puroparty.photopost_categories.header |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.footer |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.headtags |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.private |
no |
no |
2 |
2 |
0 |
0 |
2.0000 |
NULL |
ENUM('no') NOT NULL |
puroparty.photopost_categories.ugnoview |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.ugnoupload |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.ugnopost |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.ugnovote |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.ugnoanno |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.children |
2 |
2 |
1 |
1 |
2 |
0 |
0.3333 |
NULL |
ENUM('','2') NOT NULL |
puroparty.photopost_categories.albums |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.subalbum |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.lastpost |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.lastphoto |
5 |
5 |
1 |
1 |
0 |
0 |
5.0000 |
0.0000 |
ENUM('5') NOT NULL |
puroparty.photopost_categories.photos |
0 |
5 |
1 |
1 |
1 |
0 |
2.6667 |
2.0548 |
ENUM('0','3','5') NOT NULL |
puroparty.photopost_categories.posts |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.password |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.cattype |
c |
c |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('c') NOT NULL |
puroparty.photopost_categories.theme |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.thumbtype |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.catdepth |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.watermark |
|
|
0 |
0 |
3 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_categories.sortorder |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.photopost_categories.extra1 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.extra2 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.extra3 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.extra4 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.extra5 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.extra6 |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.thumbnail |
0 |
3 |
1 |
1 |
2 |
0 |
1.0000 |
1.4142 |
ENUM('0','3') NOT NULL |
puroparty.photopost_categories.maximages |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.canzip |
no |
no |
2 |
2 |
0 |
0 |
2.0000 |
NULL |
ENUM('no') NOT NULL |
puroparty.photopost_categories.frames |
0 |
0 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('0') NOT NULL |
puroparty.photopost_categories.intro |
no |
no |
2 |
2 |
0 |
0 |
2.0000 |
NULL |
ENUM('no') NOT NULL |
puroparty.photopost_categories.introtitle |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.introcopy |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.moderators |
NULL |
NULL |
0 |
0 |
0 |
3 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_categories.numextra |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.ratingtype |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.takevotes |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_categories.ismember |
0 |
0 |
1 |
1 |
3 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |