Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.photopost_photos.id |
1 |
5 |
1 |
1 |
0 |
0 |
3.0000 |
1.4142 |
ENUM('1','2','3','4','5') NOT NULL |
puroparty.photopost_photos.user |
puroparty |
puroparty |
9 |
9 |
0 |
0 |
9.0000 |
NULL |
ENUM('puroparty') NOT NULL |
puroparty.photopost_photos.userid |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.photopost_photos.cat |
2 |
500 |
1 |
3 |
0 |
0 |
201.2000 |
243.9692 |
ENUM('2','500') NOT NULL |
puroparty.photopost_photos.storeid |
0 |
0 |
1 |
1 |
5 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_photos.storecat |
0 |
0 |
1 |
1 |
5 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_photos.date |
1209961909 |
1209963519 |
10 |
10 |
0 |
0 |
1209962759.2000 |
1214800199.9906 |
ENUM('1209961909','1209962011','1209962840','12099... |
puroparty.photopost_photos.title |
50_Cent_-_Curtis |
Forest |
6 |
16 |
0 |
0 |
10.0000 |
NULL |
ENUM('50_Cent_-_Curtis','alicia','Desert_Landscape... |
puroparty.photopost_photos.description |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.keywords |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.bigimage |
50_Cent_-_Curtis.jpg |
Forest.jpg |
10 |
20 |
0 |
0 |
14.0000 |
NULL |
ENUM('50_Cent_-_Curtis.jpg','alicia.jpg','Desert_L... |
puroparty.photopost_photos.width |
240 |
1024 |
3 |
4 |
0 |
0 |
677.6000 |
343.2326 |
ENUM('240','300','800','1024') NOT NULL |
puroparty.photopost_photos.height |
184 |
768 |
3 |
3 |
0 |
0 |
514.6000 |
254.0894 |
ENUM('184','240','613','768') NOT NULL |
puroparty.photopost_photos.filesize |
21649 |
664489 |
5 |
6 |
0 |
0 |
204805.2000 |
241182.3023 |
ENUM('21649','43683','65342','228863','664489') NO... |
puroparty.photopost_photos.views |
1 |
3 |
1 |
1 |
2 |
0 |
1.2000 |
1.1662 |
ENUM('0','1','2','3') NOT NULL |
puroparty.photopost_photos.medwidth |
600 |
600 |
3 |
3 |
2 |
0 |
360.0000 |
293.9388 |
ENUM('0','600') NOT NULL |
puroparty.photopost_photos.medheight |
450 |
459 |
3 |
3 |
2 |
0 |
271.8000 |
221.9481 |
ENUM('0','450','459') NOT NULL |
puroparty.photopost_photos.medsize |
37345 |
64626 |
5 |
5 |
2 |
0 |
28572.4000 |
25144.9103 |
ENUM('0','37345','40891','64626') NOT NULL |
puroparty.photopost_photos.approved |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.photopost_photos.lastpost |
1209961909 |
1209963519 |
10 |
10 |
0 |
0 |
1209962759.2000 |
1214800199.9906 |
ENUM('1209961909','1209962011','1209962840','12099... |
puroparty.photopost_photos.rating |
0.00 |
0.00 |
4 |
4 |
5 |
0 |
0.00 |
0.00 |
ENUM('0.00') NOT NULL |
puroparty.photopost_photos.watermarked |
no |
no |
2 |
2 |
0 |
0 |
2.0000 |
NULL |
ENUM('no') NOT NULL |
puroparty.photopost_photos.allowprint |
yes |
yes |
3 |
3 |
0 |
0 |
3.0000 |
NULL |
ENUM('yes') NOT NULL |
puroparty.photopost_photos.extra1 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.extra2 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.extra3 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.extra4 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.extra5 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.extra6 |
|
|
0 |
0 |
5 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.photopost_photos.disporder |
99999 |
99999 |
5 |
5 |
0 |
0 |
99999.0000 |
0.0000 |
ENUM('99999') NOT NULL |
puroparty.photopost_photos.ipaddress |
99.158.44.10 |
99.158.44.10 |
12 |
12 |
0 |
0 |
12.0000 |
NULL |
ENUM('99.158.44.10') NOT NULL |
puroparty.photopost_photos.numcom |
0 |
0 |
1 |
1 |
5 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_photos.lastposter |
NULL |
NULL |
0 |
0 |
0 |
5 |
0.0 |
NULL |
CHAR(0) |
puroparty.photopost_photos.lastpid |
0 |
0 |
1 |
1 |
5 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.photopost_photos.allowrate |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.photopost_photos.allowcoms |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |