mysql.puroparty.com
puroparty
bos_categories
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: bos_categories
|
| Field | Type | Null | Default |
|---|---|---|---|
| category_id | int(5) | No | |
| category_order | int(3) | No | 0 |
| category_parent | int(5) | No | 0 |
| category_title | varchar(255) | No | |
| category_desc | text | No | |
| category_img | varchar(255) | No | |
| category_ad_types | varchar(255) | No | |
| category_ad_prices | varchar(255) | No | |
| category_optional_1 | varchar(255) | No | |
| category_optional_1_def | varchar(255) | No | |
| category_optional_2 | varchar(255) | No | |
| category_optional_2_def | varchar(255) | No | |
| category_optional_3 | varchar(255) | No | |
| category_optional_3_def | varchar(255) | No | |
| category_optional_4 | varchar(255) | No | |
| category_optional_4_def | varchar(255) | No | |
| category_optional_5 | varchar(255) | No | |
| category_optional_5_def | varchar(255) | No | |
| category_subs | int(5) | No | 0 |
| category_listings | int(5) | No | 0 |
| banner_top | varchar(5) | No | |
| banner_bottom | varchar(5) | No | |
| category_related | varchar(255) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 7 | category_id | |
| category_id_3 | UNIQUE | 7 | category_id | |
| category_order_2 | UNIQUE | 7 | category_order | |
| category_title_2 | UNIQUE | 7 | category_title | |
| category_img_2 | UNIQUE | 7 | category_img | |
| category_img_5 | UNIQUE | 7 | category_img | |
| category_order_4 | UNIQUE | 7 | category_order | |
| category_optional_1_4 | UNIQUE | 7 | category_optional_1 | |
| category_id | INDEX | None | category_id | |
| category_id_2 | INDEX | None | category_id | |
| category_order | INDEX | None | category_order | |
| category_parent | INDEX | None | category_parent | |
| category_title | INDEX | None | category_title | |
| category_img | INDEX | None | category_img | |
| category_ad_types | INDEX | None | category_ad_types | |
| category_ad_prices | INDEX | None | category_ad_prices | |
| category_optional_1 | INDEX | None | category_optional_1 | |
| category_optional_1_def | INDEX | None | category_optional_1_def | |
| category_optional_2 | INDEX | None | category_optional_2 | |
| category_optional_2_def | INDEX | None | category_optional_2_def | |
| category_optional_3 | INDEX | None | category_optional_3 | |
| category_optional_3_def | INDEX | None | category_optional_3_def | |
| category_optional_4 | INDEX | None | category_optional_4 | |
| category_optional_4_def | INDEX | None | category_optional_4_def | |
| category_optional_5 | INDEX | None | category_optional_5 | |
| category_optional_5_def | INDEX | None | category_optional_5_def | |
| category_subs | INDEX | None | category_subs | |
| category_listings | INDEX | None | category_listings | |
| banner_top | INDEX | None | banner_top | |
| banner_bottom | INDEX | None | banner_bottom | |
| category_related | INDEX | None | category_related | |
| category_optional_5_def_3 | INDEX | None | category_optional_5_def | |
| category_img_4 | INDEX | None | category_img | |
| category_optional_1_3 | INDEX | None | category_optional_1 | |
| category_optional_3_3 | INDEX | None | category_optional_3 | |
| category_id_4 | INDEX | None | category_id | |
| category_optional_2_def_3 | INDEX | None | category_optional_2_def | |
| category_optional_5_3 | INDEX | None | category_optional_5 | |
| category_order_3 | INDEX | None | category_order | |
| category_related_3 | INDEX | None | category_related | |
| banner_bottom_3 | INDEX | None | banner_bottom | |
| category_title_3 | INDEX | None | category_title | |
| category_desc | INDEX | None | category_desc | |
| category_img_3 | INDEX | None | category_img | |
| category_ad_types_2 | INDEX | None | category_ad_types | |
| category_ad_prices_2 | INDEX | None | category_ad_prices | |
| category_optional_1_2 | INDEX | None | category_optional_1 | |
| category_optional_1_def_2 | INDEX | None | category_optional_1_def | |
| category_optional_2_2 | INDEX | None | category_optional_2 | |
| category_optional_2_def_2 | INDEX | None | category_optional_2_def | |
| category_optional_3_2 | INDEX | None | category_optional_3 | |
| category_optional_3_def_2 | INDEX | None | category_optional_3_def | |
| category_optional_4_2 | INDEX | None | category_optional_4 | |
| category_optional_4_def_2 | INDEX | None | category_optional_4_def | |
| category_optional_5_2 | INDEX | None | category_optional_5 | |
| category_optional_5_def_2 | INDEX | None | category_optional_5_def | |
| banner_top_2 | INDEX | None | banner_top | |
| banner_bottom_2 | INDEX | None | banner_bottom | |
| category_related_2 | INDEX | None | category_related | |
| category_optional_4_def_3 | INDEX | None | category_optional_4_def | |
| category_desc_2 | INDEX | None | category_desc | |
| category_ad_types_3 | INDEX | None | category_ad_types | |
| category_ad_prices_3 | INDEX | None | category_ad_prices | |
| category_optional_1_def_3 | INDEX | None | category_optional_1_def | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||