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

jos_sections

Field Type Null Default
id  int(11) No   
title  varchar(255) No   
name  varchar(255) No   
alias  varchar(255) No   
image  text No   
scope  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 
ordering  int(11) No 
access  tinyint(3) No 
count  int(11) No 
params  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 3 id
id_2 UNIQUE 3 id
title_2 UNIQUE 3 title
alias_2 UNIQUE 3 alias
ordering_2 UNIQUE 3 ordering
count_2 UNIQUE 3 count
title_4 UNIQUE 3 title
count_4 UNIQUE 3 count
id_3 UNIQUE 3 id
alias_6 UNIQUE 3 alias
ordering_4 UNIQUE 3 ordering
count_5 UNIQUE 3 count
alias_8 UNIQUE 3 alias
scope_5 UNIQUE 3 scope
idx_scope INDEX None scope
id INDEX None id
title INDEX None title
name INDEX None name
alias INDEX None alias
scope INDEX None scope
image_position INDEX None image_position
published INDEX None published
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
ordering INDEX None ordering
access INDEX None access
count INDEX None count
ordering_3 INDEX None ordering
checked_out_time_2 INDEX None checked_out_time
alias_4 INDEX None alias
image_position_3 INDEX None image_position
count_3 INDEX None count
published_2 INDEX None published
access_2 INDEX None access
scope_3 INDEX None scope
title_6 INDEX None title
name_4 INDEX None name
id_4 INDEX None id
checked_out_2 INDEX None checked_out
checked_out_3 INDEX None checked_out
alias_7 INDEX None alias
image_position_5 INDEX None image_position
ordering_5 INDEX None ordering
published_3 INDEX None published
title_3 INDEX None title
name_2 INDEX None name
alias_3 INDEX None alias
image INDEX None image
scope_2 INDEX None scope
image_position_2 INDEX None image_position
description INDEX None description
params INDEX None params
description_2 INDEX None description
image_2 INDEX None image
name_3 INDEX None name
params_2 INDEX None params
title_5 INDEX None title
alias_5 INDEX None alias
image_position_4 INDEX None image_position
scope_4 INDEX None scope
description_3 INDEX None description
params_3 INDEX None params
image_3 INDEX None image
title_7 INDEX None title


 Space usage :
Type Usage
Data 400 Bytes
Index 4,096 Bytes
Total 4,496 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 3
Row length ø 133
Row size  ø 1,499 Bytes
Next Autoindex 5
Creation Nov 04, 2017 at 05:34 PM
Last update Mar 31, 2018 at 06:43 AM
Last check Mar 07, 2024 at 11:00 AM