mysql.puroparty.com
puroparty
extcal_categories
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: extcal_categories
|
| 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 | 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 :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||