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

extcal_categories

Table comments : Table for event categories

Field Type Null Default
cat_id  int(11) No   
cat_parent  int(11) No 
cat_name  varchar(150) No   
description  text No   
color  varchar(10) Yes  #000000 
bgcolor  varchar(10) Yes  #EEF0F0 
options  tinyint(4) Yes 
enabled  tinyint(4) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 9 cat_id
cat_id UNIQUE 9 cat_id
cat_id_3 UNIQUE 9 cat_id
cat_name_2 UNIQUE 9 cat_name
cat_name_6 UNIQUE 9 cat_name
cat_id_4 UNIQUE 9 cat_id
cat_name_7 UNIQUE 9 cat_name
cat_id_7 UNIQUE 9 cat_id
cat_name_10 UNIQUE 9 cat_name
cat_id_9 UNIQUE 9 cat_id
cat_id_10 UNIQUE 9 cat_id
cat_name_13 UNIQUE 9 cat_name
cat_name_14 UNIQUE 9 cat_name
cat_parent_5 UNIQUE 9 cat_parent
color_2 UNIQUE None color
color_5 UNIQUE None color
color_9 UNIQUE None color
color_10 UNIQUE None color
cat_id_2 INDEX None cat_id
cat_parent INDEX None cat_parent
cat_name INDEX None cat_name
color INDEX None color
bgcolor INDEX None bgcolor
options INDEX None options
enabled INDEX None enabled
cat_name_5 INDEX None cat_name
enabled_2 INDEX None enabled
options_2 INDEX None options
bgcolor_3 INDEX None bgcolor
cat_id_5 INDEX None cat_id
cat_parent_2 INDEX None cat_parent
color_6 INDEX None color
cat_id_6 INDEX None cat_id
cat_name_8 INDEX None cat_name
options_3 INDEX None options
bgcolor_6 INDEX None bgcolor
color_8 INDEX None color
cat_parent_3 INDEX None cat_parent
enabled_3 INDEX None enabled
cat_id_8 INDEX None cat_id
options_4 INDEX None options
enabled_4 INDEX None enabled
cat_name_11 INDEX None cat_name
bgcolor_8 INDEX None bgcolor
cat_parent_4 INDEX None cat_parent
color_12 INDEX None color
cat_name_3 INDEX None cat_name
description INDEX None description
color_3 INDEX None color
bgcolor_2 INDEX None bgcolor
cat_name_4 INDEX None cat_name
color_4 INDEX None color
description_2 INDEX None description
bgcolor_4 INDEX None bgcolor
color_7 INDEX None color
description_3 INDEX None description
bgcolor_5 INDEX None bgcolor
cat_name_9 INDEX None cat_name
bgcolor_7 INDEX None bgcolor
description_4 INDEX None description
color_11 INDEX None color
cat_name_12 INDEX None cat_name
bgcolor_9 INDEX None bgcolor
description_5 INDEX None description


 Space usage :
Type Usage
Data 456 Bytes
Index 3,072 Bytes
Total 3,528 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 9
Row length ø 50
Row size  ø 392 Bytes
Next Autoindex 10
Creation Feb 23, 2018 at 01:08 AM
Last update Mar 27, 2018 at 09:07 AM
Last check Apr 05, 2018 at 12:33 AM