Server: mysql.puroparty.com | Database: puroparty | Table: extcal_2categories |
Field | Type | Null | Default |
---|---|---|---|
cat_id | int(11) | No | |
cat_parent | int(11) | No | 0 |
cat_name | varchar(150) | No | |
description | text | No | |
color | varchar(10) | Yes | #000000 |
bgcolor | varchar(10) | Yes | #EEF0F0 |
options | tinyint(4) | Yes | 0 |
enabled | tinyint(4) | Yes | 0 |
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 :
|
Row Statistic :
|