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

extcal2_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 10 cat_id
cat_id UNIQUE 10 cat_id
cat_id_3 UNIQUE 10 cat_id
cat_name_2 UNIQUE 10 cat_name
cat_id_5 UNIQUE 10 cat_id
cat_name_4 UNIQUE 10 cat_name
cat_id_7 UNIQUE 10 cat_id
cat_name_8 UNIQUE 10 cat_name
cat_id_9 UNIQUE 10 cat_id
cat_name_12 UNIQUE 10 cat_name
cat_id_11 UNIQUE 10 cat_id
color_2 UNIQUE None color
color_4 UNIQUE None color
color_8 UNIQUE None color
color_12 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
bgcolor_3 INDEX None bgcolor
cat_id_4 INDEX None cat_id
options_2 INDEX None options
cat_parent_2 INDEX None cat_parent
cat_name_5 INDEX None cat_name
color_6 INDEX None color
enabled_2 INDEX None enabled
cat_id_6 INDEX None cat_id
bgcolor_7 INDEX None bgcolor
options_3 INDEX None options
color_9 INDEX None color
cat_parent_3 INDEX None cat_parent
cat_name_7 INDEX None cat_name
enabled_3 INDEX None enabled
cat_id_8 INDEX None cat_id
cat_name_11 INDEX None cat_name
cat_id_10 INDEX None cat_id
bgcolor_8 INDEX None bgcolor
enabled_4 INDEX None enabled
options_4 INDEX None options
color_13 INDEX None color
cat_parent_4 INDEX None cat_parent
color_14 INDEX None color
cat_name_3 INDEX None cat_name
description INDEX None description
color_3 INDEX None color
bgcolor_2 INDEX None bgcolor
description_2 INDEX None description
bgcolor_4 INDEX None bgcolor
color_5 INDEX None color
cat_name_6 INDEX None cat_name
bgcolor_5 INDEX None bgcolor
description_3 INDEX None description
color_7 INDEX None color
bgcolor_6 INDEX None bgcolor
cat_name_9 INDEX None cat_name
color_10 INDEX None color
description_4 INDEX None description
color_11 INDEX None color
cat_name_10 INDEX None cat_name
bgcolor_9 INDEX None bgcolor
bgcolor_10 INDEX None bgcolor


 Space usage :
Type Usage
Data 776 Bytes
Index 3,072 Bytes
Total 3,848 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 10
Row length ø 77
Row size  ø 385 Bytes
Next Autoindex 11
Creation Mar 18, 2018 at 05:36 AM
Last update Mar 18, 2018 at 09:40 PM
Last check Mar 26, 2018 at 09:53 AM