mysql.puroparty.com
puroparty
jos_menu
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_menu
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| menutype | varchar(75) | Yes | NULL |
| name | varchar(255) | Yes | NULL |
| alias | varchar(255) | No | |
| link | text | Yes | NULL |
| type | varchar(50) | No | |
| published | tinyint(1) | No | 0 |
| parent | int(11) | No | 0 |
| componentid | int(11) | No | 0 |
| sublevel | int(11) | Yes | 0 |
| ordering | int(11) | Yes | 0 |
| checked_out | int(11) | No | 0 |
| checked_out_time | datetime | No | 0000-00-00 00:00:00 |
| pollid | int(11) | No | 0 |
| browserNav | tinyint(4) | Yes | 0 |
| access | tinyint(3) | No | 0 |
| utaccess | tinyint(3) | No | 0 |
| params | text | No | |
| lft | int(11) | No | 0 |
| rgt | int(11) | No | 0 |
| home | int(1) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 29 | id | |
| id_2 | UNIQUE | 29 | id | |
| alias_2 | UNIQUE | 29 | alias | |
| id_4 | UNIQUE | 29 | id | |
| alias_4 | UNIQUE | 29 | alias | |
| name_2 | UNIQUE | None | name | |
| name_5 | UNIQUE | None | name | |
| componentid | INDEX | None | componentid | |
| menutype | ||||
| published | ||||
| access | ||||
| menutype | INDEX | None | menutype | |
| id | INDEX | None | id | |
| menutype_2 | INDEX | None | menutype | |
| name | INDEX | None | name | |
| alias | INDEX | None | alias | |
| type | INDEX | None | type | |
| published | INDEX | None | published | |
| parent | INDEX | None | parent | |
| componentid_2 | INDEX | None | componentid | |
| sublevel | INDEX | None | sublevel | |
| ordering | INDEX | None | ordering | |
| checked_out | INDEX | None | checked_out | |
| checked_out_time | INDEX | None | checked_out_time | |
| pollid | INDEX | None | pollid | |
| browserNav | INDEX | None | browserNav | |
| access | INDEX | None | access | |
| utaccess | INDEX | None | utaccess | |
| lft | INDEX | None | lft | |
| rgt | INDEX | None | rgt | |
| home | INDEX | None | home | |
| id_3 | INDEX | None | id | |
| utaccess_2 | INDEX | None | utaccess | |
| name_4 | INDEX | None | name | |
| access_2 | INDEX | None | access | |
| home_2 | INDEX | None | home | |
| menutype_4 | INDEX | None | menutype | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| lft_2 | INDEX | None | lft | |
| pollid_2 | INDEX | None | pollid | |
| componentid_3 | INDEX | None | componentid | |
| ordering_2 | INDEX | None | ordering | |
| sublevel_2 | INDEX | None | sublevel | |
| browserNav_2 | INDEX | None | browserNav | |
| type_3 | INDEX | None | type | |
| parent_2 | INDEX | None | parent | |
| published_2 | INDEX | None | published | |
| rgt_2 | INDEX | None | rgt | |
| alias_6 | INDEX | None | alias | |
| checked_out_2 | INDEX | None | checked_out | |
| checked_out_time_3 | INDEX | None | checked_out_time | |
| lft_3 | INDEX | None | lft | |
| access_3 | INDEX | None | access | |
| menutype_3 | INDEX | None | menutype | |
| name_3 | INDEX | None | name | |
| alias_3 | INDEX | None | alias | |
| link | INDEX | None | link | |
| type_2 | INDEX | None | type | |
| params | INDEX | None | params | |
| link_2 | INDEX | None | link | |
| menutype_5 | INDEX | None | menutype | |
| params_2 | INDEX | None | params | |
| name_6 | INDEX | None | name | |
| alias_5 | INDEX | None | alias | |
| type_4 | INDEX | None | type | |
| alias_7 | INDEX | None | alias | |
| link_3 | INDEX | None | link | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||