menu Table (#__menu)
| 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 |
| ordering |
integer |
NOT NULL |
0 |
|
|
The relative ordering of the menu item in the tree. |
| 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 |
|
|
|
|
