| Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
| id |
integer |
NOT NULL |
|
PK |
auto_increment |
|
| menutype |
varchar(24) |
NOT NULL |
|
|
|
The type of menu for the item. FK to #__menu_types.menutype
|
| title |
varchar(255) |
NOT NULL |
|
|
|
The display title for the menu item.
|
| alias |
varchar(255) |
NOT NULL |
|
|
|
The SEF alias for the menu item.
|
| note |
varchar(255) |
NOT NULL |
|
|
|
|
| path |
varchar(1024) |
NOT NULL |
|
|
|
The computed path for the menu item based on the alias field.
|
| link |
varchar(1024) |
NOT NULL |
|
|
|
The actually link that the menu item references.
|
| type |
varchar(16) |
NOT NULL |
|
|
|
The type of link: Component, URL, Alias, Separator.
|
| published |
tinyint(4) |
NOT NULL |
0 |
|
|
The published state of the menu link.
|
| parent_id |
integer unsigned |
NOT NULL |
1 |
|
|
The parent menu item in the menu tree.
|
| level |
integer unsigned |
NOT NULL |
0 |
|
|
The relative level in the menu tree.
|
| component_id |
integer unsigned |
NOT NULL |
0 |
|
|
FK to #__extensions.id
|
| checked_out |
integer unsigned |
NOT NULL |
0 |
|
|
FK to #__users.id
|
| checked_out_time |
timestamp |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
The time the menu item was checked out.
|
| browserNav |
tinyint(4) |
NOT NULL |
0 |
|
|
The click behaviour for the link.
|
| access |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
The access level required to view the menu item.
|
| img |
varchar(255) |
NOT NULL |
|
|
|
The image of the menu item.
|
| template_style_id |
integer unsigned |
NOT NULL |
0 |
|
|
|
| params |
varchar(10240) |
NOT NULL |
|
|
|
JSON-encoded data for the menu item.
|
| lft |
integer |
NOT NULL |
0 |
|
|
Nested set lft.
|
| rgt |
integer |
NOT NULL |
0 |
|
|
Nested set rgt.
|
| home |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
Indicates if this menu item is the home or default page.
|
| language |
char(7) |
NOT NULL |
|
|
|
|
| client_id |
tinyint(4) |
NOT NULL |
0 |
|
|
|