Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 11:39 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_categories` PROCEDURE ANALYSE();
Rows: 23
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.ads_categories.category_id | 8 | 27 | 1 | 2 | 0 | 0 | 19.0000 | 5.2769 | ENUM('8','13','14','15','16','19','20','21','22','23','24','25','27') NOT NULL |
puroparty.ads_categories.category_order | 1 | 14 | 1 | 2 | 0 | 0 | 7.5385 | 4.1808 | ENUM('1','2','3','4','5','6','8','9','10','11','12','13','14') NOT NULL |
puroparty.ads_categories.category_parent | 0 | 0 | 1 | 1 | 13 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_categories.category_title | clubs/bars | want to hire | 8 | 20 | 0 | 0 | 12.1538 | NULL | ENUM('clubs/bars','entertainers','festivals','free stuff','fundraisers/benefits','happy hour','indoor concerts','non-profits','outdoor concerts','services','stuff for sale','want to buy','want to hire') NOT NULL |
puroparty.ads_categories.category_desc | "annual" cookoffs, fairs,<br>festivals, bazaars | sell your 'good' stuff here! | 13 | 58 | 0 | 0 | 30.6923 | NULL | ENUM('"annual" cookoffs, fairs,<br>festivals, bazaars','501(c)orgs only!','al aire libre','ask, someone might have it','benefits, bbq teams, etc;','cheap drinks here!','clubs don’t count<br>’cept for rainouts','entertainers for hire, bands,<br> djs, mcs, booking agents','gigs, job offers,<br> need help, volunteers','icehouses, bars, clubs,<br> taverns, pubs','limos, cakes, flowers, etc;','NO pesos required!','sell your \'good\' stuff here!') NOT NULL |
puroparty.ads_categories.category_img | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_ad_types | 9, | 0 | 2 | 12 | 0 | 0.1538 | NULL | ENUM('','9,') NOT NULL | |
puroparty.ads_categories.category_ad_prices | 0.00, | 0 | 5 | 12 | 0 | 0.3846 | NULL | ENUM('','0.00,') NOT NULL | |
puroparty.ads_categories.category_optional_1 | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_1_def | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_2 | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_2_def | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_3 | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_3_def | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_4 | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_4_def | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_5 | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_optional_5_def | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_subs | 0 | 0 | 1 | 1 | 13 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.ads_categories.category_listings | 0 | 5 | 1 | 1 | 12 | 0 | 0.3846 | 1.3323 | ENUM('0','5') NOT NULL |
puroparty.ads_categories.banner_top | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.banner_bottom | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_categories.category_related | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |