Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 10:48 PM
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','... |
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... |
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... |
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, baza... |
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 |