Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 06:44 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_ads` PROCEDURE ANALYSE();
Rows: 44
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.ads_ads.ad_id | 6 | 10 | 1 | 2 | 0 | 0 | 8.0000 | 1.4142 | ENUM('6','7','8','9','10') NOT NULL |
puroparty.ads_ads.ad_status | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.ads_ads.ad_user_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.ads_ads.ad_category | 8 | 8 | 1 | 1 | 0 | 0 | 8.0000 | 0.0000 | ENUM('8') NOT NULL |
puroparty.ads_ads.ad_date_begin | 2007-09-18 | 2007-09-18 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2007-09-18') NOT NULL |
puroparty.ads_ads.ad_date_end | 2007-09-25 | 2007-10-18 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2007-09-25','2007-10-18') NOT NULL |
puroparty.ads_ads.ad_type | 9 | 9 | 1 | 1 | 0 | 0 | 9.0000 | 0.0000 | ENUM('9') NOT NULL |
puroparty.ads_ads.ad_title | las rosas | the meridian | 9 | 19 | 0 | 0 | 14.0000 | NULL | ENUM('las rosas','onion creek','sheltons tejano ba... |
puroparty.ads_ads.ad_description | all the crazy rock groups doing drugs and stuff ev... | elvis at las rosas tonight for the first time in 3... | 35 | 145 | 0 | 0 | 75.0000 | NULL | ENUM('all the crazy rock groups doing drugs and st... |
puroparty.ads_ads.ad_image1 | IMG_8704.jpg | t_page118.jpg | 10 | 21 | 0 | 0 | 14.2000 | NULL | ENUM('IMG_8704.jpg','page47.jpg','ppban120x60.jpg'... |
puroparty.ads_ads.ad_image2 | IMG_6372.jpg | puropartylogo286x150.jpg | 10 | 24 | 0 | 0 | 16.2000 | NULL | ENUM('IMG_6372.jpg','page130.jpg','page19.jpg','pp... |
puroparty.ads_ads.ad_image3 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_image4 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_image5 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_options | 1 | 36 | 1 | 2 | 1 | 0 | 13.8000 | 13.8188 | ENUM('0','1','9','23','36') NOT NULL |
puroparty.ads_ads.ad_optional_1 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_optional_2 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_optional_3 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_optional_4 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_optional_5 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional1 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional2 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional3 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional4 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional5 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional6 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional7 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional8 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional9 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_type_optional10 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_price | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_condition | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_ads.ad_views | 2 | 5 | 1 | 1 | 1 | 0 | 2.6000 | 1.7436 | ENUM('0','2','4','5') NOT NULL |
puroparty.ads_ads.ad_address | 112 chartres | 0 | 12 | 4 | 0 | 2.4000 | NULL | ENUM('','112 chartres') NOT NULL | |
puroparty.ads_ads.ad_city | houston | 0 | 7 | 4 | 0 | 1.4000 | NULL | ENUM('','houston') NOT NULL | |
puroparty.ads_ads.ad_state | tx | 0 | 2 | 4 | 0 | 0.4000 | NULL | ENUM('','tx') NOT NULL | |
puroparty.ads_ads.ad_postal | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_country | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_city_code | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_ads.ad_state_code | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_ads.ad_country_code | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_ads.ad_fee | 0.00 | 0.00 | 4 | 4 | 5 | 0 | 0.00 | 0.00 | ENUM('0.00') NOT NULL |
puroparty.ads_ads.ad_anon_name | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ads.ad_anon_email | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |