Table llx menu

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档可在页面上找到:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the menus. See also page Menus_system

Fr verysmall.png Contient les menus. Voir aussi la page Système_de_menus

Es verysmall.png Contiene los menús.

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
menu_handler varchar(16) NO UNI Menu handler name
entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
module varchar(64) YES NULL module name if record is added by a module
type varchar(4) NO MUL type of menu (top or left)
mainmenu varchar(100) NO Name family/module (home, companies, etc.)
fk_menu int(11) NO UNI 0 or Id of parent menu line
position int(11) NO sort order of entry
url varchar(255) NO UNI relative (or absolute) url to go
target varchar(100) YES NULL target of url link
titre varchar(255) NO key for menu translation
langs varchar(100) YES NULL lang file to load for translation
level smallint YES NULL only used by auguria menu. Do not use
leftmenu varchar(1) YES 1 Not used (deprecated)
perms varchar(255) YES NULL condition to show enabled or disabled (grayed menu) if field enabled is 1
enabled varchar(255) YES 1 condition to show or hide (completely hidden)
usertype int(11) NO 0 0 if menu for all users, 1 for external only, 2 for internal only
tms timestamp NO Current date Date of last modification. See page Field Tms.

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
idx_menu_uk_menu UNIQUE menu_handler,fk_menu,url,entity
idx_menu_menuhandler_type MULTIPLE menu_handler,type