mysql.puroparty.com
puroparty
jos_categories
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_categories
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| parent_id | int(11) | No | 0 |
| title | varchar(255) | No | |
| name | varchar(255) | No | |
| alias | varchar(255) | No | |
| image | varchar(255) | No | |
| section | varchar(50) | No | |
| image_position | varchar(30) | No | |
| description | text | No | |
| published | tinyint(1) | No | 0 |
| checked_out | int(11) | No | 0 |
| checked_out_time | datetime | No | 0000-00-00 00:00:00 |
| editor | varchar(50) | Yes | NULL |
| ordering | int(11) | No | 0 |
| access | tinyint(3) | No | 0 |
| count | int(11) | No | 0 |
| params | text | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 22 | id | |
| id_2 | UNIQUE | 22 | id | |
| title_2 | UNIQUE | 22 | title | |
| id_4 | UNIQUE | 22 | id | |
| title_6 | UNIQUE | 22 | title | |
| cat_idx | INDEX | None | section | |
| published | ||||
| access | ||||
| idx_access | INDEX | None | access | |
| idx_checkout | INDEX | None | checked_out | |
| id | INDEX | None | id | |
| parent_id | INDEX | None | parent_id | |
| title | INDEX | None | title | |
| name | INDEX | None | name | |
| alias | INDEX | None | alias | |
| image | INDEX | None | image | |
| section | INDEX | None | section | |
| image_position | INDEX | None | image_position | |
| published | INDEX | None | published | |
| checked_out | INDEX | None | checked_out | |
| checked_out_time | INDEX | None | checked_out_time | |
| editor | INDEX | None | editor | |
| ordering | INDEX | None | ordering | |
| access | INDEX | None | access | |
| count | INDEX | None | count | |
| ordering_2 | INDEX | None | ordering | |
| id_3 | INDEX | None | id | |
| published_2 | INDEX | None | published | |
| parent_id_2 | INDEX | None | parent_id | |
| title_4 | INDEX | None | title | |
| name_3 | INDEX | None | name | |
| count_2 | INDEX | None | count | |
| image_position_4 | INDEX | None | image_position | |
| editor_4 | INDEX | None | editor | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| access_2 | INDEX | None | access | |
| image_4 | INDEX | None | image | |
| section_4 | INDEX | None | section | |
| checked_out_2 | INDEX | None | checked_out | |
| alias_4 | INDEX | None | alias | |
| editor_5 | INDEX | None | editor | |
| image_position_5 | INDEX | None | image_position | |
| count_3 | INDEX | None | count | |
| title_8 | INDEX | None | title | |
| ordering_3 | INDEX | None | ordering | |
| title_3 | INDEX | None | title | |
| name_2 | INDEX | None | name | |
| alias_2 | INDEX | None | alias | |
| image_2 | INDEX | None | image | |
| section_2 | INDEX | None | section | |
| image_position_2 | INDEX | None | image_position | |
| description | INDEX | None | description | |
| editor_2 | INDEX | None | editor | |
| params | INDEX | None | params | |
| editor_3 | INDEX | None | editor | |
| description_2 | INDEX | None | description | |
| image_3 | INDEX | None | image | |
| params_2 | INDEX | None | params | |
| image_position_3 | INDEX | None | image_position | |
| alias_3 | INDEX | None | alias | |
| title_5 | INDEX | None | title | |
| section_3 | INDEX | None | section | |
| name_4 | INDEX | None | name | |
| title_7 | INDEX | None | title | |
| alias_5 | INDEX | None | alias | |
| editor_6 | INDEX | None | editor | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||