Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: ads_categoriesads_categories

ads_categories

Field Type Null Default
category_id  int(5) No   
category_order  int(3) No 
category_parent  int(5) No 
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 
category_listings  int(5) No 
banner_top  varchar(5) No   
banner_bottom  varchar(5) No   
category_related  varchar(255) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 13 category_id
category_id_3 UNIQUE 13 category_id
category_order_2 UNIQUE 13 category_order
category_title_2 UNIQUE 13 category_title
category_id_5 UNIQUE 13 category_id
category_order_4 UNIQUE 13 category_order
category_title_5 UNIQUE 13 category_title
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_related_3 INDEX None category_related
category_id_4 INDEX None category_id
category_order_3 INDEX None category_order
category_parent_2 INDEX None category_parent
category_title_4 INDEX None category_title
category_img_3 INDEX None category_img
category_ad_types_3 INDEX None category_ad_types
category_ad_prices_3 INDEX None category_ad_prices
category_optional_1_3 INDEX None category_optional_1
category_optional_1_def_3 INDEX None category_optional_1_def
category_title_3 INDEX None category_title
category_desc INDEX None category_desc
category_img_2 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_title_6 INDEX None category_title
category_desc_2 INDEX None category_desc
category_img_4 INDEX None category_img
category_ad_types_4 INDEX None category_ad_types
category_ad_prices_4 INDEX None category_ad_prices
category_optional_1_4 INDEX None category_optional_1


 Space usage :
Type Usage
Data 1,016 Bytes
Index 4,096 Bytes
Total 5,112 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 13
Row length ø 78
Row size  ø 393 Bytes
Next Autoindex 28
Creation Nov 12, 2017 at 01:03 AM
Last update Jun 18, 2018 at 07:08 PM
Last check Jun 18, 2018 at 07:08 PM