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

extcal_2categories

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


 Space usage :
Type Usage
Data 452 Bytes
Index 3,072 Bytes
Total 3,524 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 7
Row length ø 64
Row size  ø 503 Bytes
Next Autoindex 1,971
Creation Mar 10, 2018 at 02:52 PM
Last update Apr 02, 2018 at 07:48 PM
Last check Apr 09, 2018 at 08:51 AM