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

jos_categories

Field Type Null Default
id  int(11) No   
parent_id  int(11) No 
title  varchar(255) No   
name  varchar(255) No   
alias  varchar(255) No   
image  varchar(255) No   
section  varchar(50) No   
image_position  varchar(30) No   
description  text No   
published  tinyint(1) No 
checked_out  int(11) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
editor  varchar(50) Yes  NULL 
ordering  int(11) No 
access  tinyint(3) No 
count  int(11) No 
params  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 22 id
id_2 UNIQUE 22 id
title_2 UNIQUE 22 title
id_4 UNIQUE 22 id
title_6 UNIQUE 22 title
cat_idx INDEX None section
published
access
idx_access INDEX None access
idx_checkout INDEX None checked_out
id INDEX None id
parent_id INDEX None parent_id
title INDEX None title
name INDEX None name
alias INDEX None alias
image INDEX None image
section INDEX None section
image_position INDEX None image_position
published INDEX None published
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
editor INDEX None editor
ordering INDEX None ordering
access INDEX None access
count INDEX None count
ordering_2 INDEX None ordering
id_3 INDEX None id
published_2 INDEX None published
parent_id_2 INDEX None parent_id
title_4 INDEX None title
name_3 INDEX None name
count_2 INDEX None count
image_position_4 INDEX None image_position
editor_4 INDEX None editor
checked_out_time_2 INDEX None checked_out_time
access_2 INDEX None access
image_4 INDEX None image
section_4 INDEX None section
checked_out_2 INDEX None checked_out
alias_4 INDEX None alias
editor_5 INDEX None editor
image_position_5 INDEX None image_position
count_3 INDEX None count
title_8 INDEX None title
ordering_3 INDEX None ordering
title_3 INDEX None title
name_2 INDEX None name
alias_2 INDEX None alias
image_2 INDEX None image
section_2 INDEX None section
image_position_2 INDEX None image_position
description INDEX None description
editor_2 INDEX None editor
params INDEX None params
editor_3 INDEX None editor
description_2 INDEX None description
image_3 INDEX None image
params_2 INDEX None params
image_position_3 INDEX None image_position
alias_3 INDEX None alias
title_5 INDEX None title
section_3 INDEX None section
name_4 INDEX None name
title_7 INDEX None title
alias_5 INDEX None alias
editor_6 INDEX None editor


 Space usage :
Type Usage
Data 1,760 Bytes
Index 4,096 Bytes
Total 5,856 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 22
Row length ø 80
Row size  ø 266 Bytes
Next Autoindex 34
Creation Dec 14, 2017 at 11:54 AM
Last update Mar 13, 2018 at 07:31 AM
Last check Mar 26, 2018 at 03:25 PM