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

asLinks_categories

Field Type Null Default
id  smallint(10) No   
name  varchar(255) Yes  NULL 
parent  smallint(10) No 
counter  smallint(10) No 
subCategories  smallint(10) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 6 id
id_2 UNIQUE 6 id
id_3 UNIQUE 6 id
id_6 UNIQUE 6 id
id_8 UNIQUE 6 id
id_10 UNIQUE 6 id
id_12 UNIQUE 6 id
id_14 UNIQUE 6 id
id_15 UNIQUE 6 id
id_17 UNIQUE 6 id
name_2 UNIQUE None name
name_5 UNIQUE None name
name_8 UNIQUE None name
name_11 UNIQUE None name
name_14 UNIQUE None name
name_17 UNIQUE None name
name_20 UNIQUE None name
id INDEX None id
name INDEX None name
parent INDEX None parent
counter INDEX None counter
subCategories INDEX None subCategories
counter_2 INDEX None counter
id_4 INDEX None id
subCategories_2 INDEX None subCategories
name_4 INDEX None name
parent_2 INDEX None parent
subCategories_3 INDEX None subCategories
id_5 INDEX None id
name_7 INDEX None name
parent_3 INDEX None parent
counter_3 INDEX None counter
subCategories_4 INDEX None subCategories
id_7 INDEX None id
name_10 INDEX None name
parent_4 INDEX None parent
counter_4 INDEX None counter
subCategories_5 INDEX None subCategories
id_9 INDEX None id
name_13 INDEX None name
parent_5 INDEX None parent
counter_5 INDEX None counter
subCategories_6 INDEX None subCategories
id_11 INDEX None id
subCategories_7 INDEX None subCategories
name_16 INDEX None name
counter_6 INDEX None counter
parent_6 INDEX None parent
id_13 INDEX None id
subCategories_8 INDEX None subCategories
subCategories_9 INDEX None subCategories
name_19 INDEX None name
parent_7 INDEX None parent
name_22 INDEX None name
counter_7 INDEX None counter
id_16 INDEX None id
name_23 INDEX None name
name_3 INDEX None name
name_6 INDEX None name
name_9 INDEX None name
name_12 INDEX None name
name_15 INDEX None name
name_18 INDEX None name
name_21 INDEX None name


 Space usage :
Type Usage
Data 152 Bytes
Index 3,072 Bytes
Total 3,224 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 6
Row length ø 25
Row size  ø 537 Bytes
Next Autoindex 9
Creation Mar 09, 2018 at 08:41 AM
Last update Mar 09, 2018 at 08:41 AM