Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 07:46 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_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.bos_categories.category_id | 72 | 92 | 2 | 2 | 0 | 0 | 83.2857 | 8.4467 | ENUM('72','73','76','89','90','91','92') NOT NULL |
| puroparty.bos_categories.category_order | 1 | 7 | 1 | 1 | 0 | 0 | 4.0000 | 2.0000 | ENUM('1','2','3','4','5','6','7') NOT NULL |
| puroparty.bos_categories.category_parent | 0 | 0 | 1 | 1 | 7 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.bos_categories.category_title | Austin | Victoria | 6 | 18 | 0 | 0 | 10.4286 | NULL | ENUM('Austin','Corpus Christi','Dallas/FW','Housto... |
| puroparty.bos_categories.category_desc | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_img | aussky.jpg | vicsky.jpg | 9 | 10 | 1 | 0 | 8.2857 | NULL | ENUM('','aussky.jpg','ccsky.jpg','dalsky.jpg','hou... |
| puroparty.bos_categories.category_ad_types | 12,19,20,21,22,23,24,25, | 12,22,23,24,25,19,20,21, | 24 | 24 | 0 | 0 | 24.0000 | NULL | ENUM('12,19,20,21,22,23,24,25,','12,22,23,24,25,19... |
| puroparty.bos_categories.category_ad_prices | 0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00, | 0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00, | 40 | 40 | 0 | 0 | 40.0000 | NULL | ENUM('0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,') N... |
| puroparty.bos_categories.category_optional_1 | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_1_def | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_2 | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_2_def | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_3 | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_3_def | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_4 | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_4_def | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_5 | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_optional_5_def | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_subs | 0 | 0 | 1 | 1 | 7 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.bos_categories.category_listings | 0 | 0 | 1 | 1 | 7 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.bos_categories.banner_top | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.banner_bottom | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.bos_categories.category_related | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |