Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.jos_banner.bid |
1 |
8 |
1 |
1 |
0 |
0 |
4.5000 |
2.2913 |
ENUM('1','2','3','4','5','6','7','8') NOT NULL |
puroparty.jos_banner.cid |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.jos_banner.type |
banner |
banner |
6 |
6 |
6 |
0 |
1.5000 |
NULL |
ENUM('','banner') NOT NULL |
puroparty.jos_banner.name |
Joomla! |
OSM 2 |
5 |
19 |
0 |
0 |
11.7500 |
NULL |
ENUM('Joomla!','Joomla! Extensions','Joomla! Promo... |
puroparty.jos_banner.alias |
joomla |
osm-2 |
5 |
18 |
0 |
0 |
11.1250 |
NULL |
ENUM('joomla','joomla-extensions','joomla-promo-bo... |
puroparty.jos_banner.imptotal |
0 |
0 |
1 |
1 |
8 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.jos_banner.impmade |
43 |
8429 |
2 |
4 |
0 |
0 |
3498.7500 |
3036.5273 |
ENUM('43','49','2777','2782','8351','8429') NOT NU... |
puroparty.jos_banner.clicks |
0 |
1656 |
1 |
4 |
2 |
0 |
693.0000 |
513.0870 |
ENUM('0','625','663','718','730','1152','1656') NO... |
puroparty.jos_banner.imageurl |
osmbanner1.png |
shop-ad.jpg |
11 |
17 |
4 |
0 |
7.0000 |
NULL |
ENUM('','osmbanner1.png','osmbanner2.png','shop-ad... |
puroparty.jos_banner.clickurl |
http://extensions.joomla.org |
http://www.opensourcematters.org |
21 |
48 |
0 |
0 |
28.2500 |
NULL |
ENUM('http://extensions.joomla.org','http://joomla... |
puroparty.jos_banner.date |
2004-07-07 15:31:29 |
2007-09-19 17:28:01 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('2004-07-07 15:31:29','2006-05-29 14:19:26','... |
puroparty.jos_banner.showBanner |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |
puroparty.jos_banner.checked_out |
0 |
0 |
1 |
1 |
8 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.jos_banner.checked_out_time |
0000-00-00 00:00:00 |
0000-00-00 00:00:00 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('0000-00-00 00:00:00') NOT NULL |
puroparty.jos_banner.editor |
|
|
0 |
0 |
8 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.jos_banner.custombannercode |
|
<a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<... |
0 |
134 |
4 |
0 |
57.0000 |
NULL |
ENUM('','<a href="{CLICKURL}" target="_blank">{NAM... |
puroparty.jos_banner.catid |
13 |
33 |
2 |
2 |
0 |
0 |
18.5000 |
8.3815 |
ENUM('13','14','33') NOT NULL |
puroparty.jos_banner.description |
|
|
0 |
0 |
8 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.jos_banner.sticky |
0 |
0 |
1 |
1 |
8 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.jos_banner.ordering |
1 |
4 |
1 |
1 |
0 |
0 |
2.5000 |
1.1180 |
ENUM('1','2','3','4') NOT NULL |
puroparty.jos_banner.publish_up |
0000-00-00 00:00:00 |
0000-00-00 00:00:00 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('0000-00-00 00:00:00') NOT NULL |
puroparty.jos_banner.publish_down |
0000-00-00 00:00:00 |
0000-00-00 00:00:00 |
19 |
19 |
0 |
0 |
19.0000 |
NULL |
ENUM('0000-00-00 00:00:00') NOT NULL |
puroparty.jos_banner.tags |
|
|
0 |
0 |
8 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.jos_banner.params |
|
|
0 |
0 |
8 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |