Server: mysql.puroparty.com | Database: puroparty | Table: bak_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 | 1 | id | |
id_2 | UNIQUE | 1 | id | |
alias_2 | UNIQUE | 1 | alias | |
type_2 | UNIQUE | 1 | type | |
published_2 | UNIQUE | 1 | published | |
parent_2 | UNIQUE | 1 | parent | |
componentid_3 | UNIQUE | 1 | componentid | |
checked_out_2 | UNIQUE | 1 | checked_out | |
checked_out_time_2 | UNIQUE | 1 | checked_out_time | |
pollid_2 | UNIQUE | 1 | pollid | |
access_2 | UNIQUE | 1 | access | |
utaccess_2 | UNIQUE | 1 | utaccess | |
lft_2 | UNIQUE | 1 | lft | |
rgt_2 | UNIQUE | 1 | rgt | |
home_2 | UNIQUE | 1 | home | |
published_3 | UNIQUE | 1 | published | |
componentid_4 | UNIQUE | 1 | componentid | |
access_3 | UNIQUE | 1 | access | |
home_3 | UNIQUE | 1 | home | |
lft_4 | UNIQUE | 1 | lft | |
checked_out_3 | UNIQUE | 1 | checked_out | |
type_5 | UNIQUE | 1 | type | |
id_3 | UNIQUE | 1 | id | |
menutype_3 | UNIQUE | None | menutype | |
name_2 | UNIQUE | None | name | |
sublevel_2 | UNIQUE | None | sublevel | |
ordering_2 | UNIQUE | None | ordering | |
browserNav_2 | UNIQUE | None | browserNav | |
name_4 | 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 | |
menutype_5 | INDEX | None | menutype | |
published_4 | INDEX | None | published | |
lft_3 | INDEX | None | lft | |
utaccess_3 | INDEX | None | utaccess | |
name_5 | INDEX | None | name | |
browserNav_3 | INDEX | None | browserNav | |
menutype_4 | INDEX | None | menutype | |
name_3 | INDEX | None | name | |
alias_3 | INDEX | None | alias | |
link | INDEX | None | link | |
type_3 | INDEX | None | type | |
params | INDEX | None | params | |
params_2 | INDEX | None | params | |
type_4 | INDEX | None | type |
Space usage :
|
Row Statistic :
|