Difference between revisions of "Table llx menu"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 31: Line 31:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| menu_handler
 +
| varchar(16)
 +
| NO
 +
|
 +
| NULL
 +
|
 +
| Menu handler name
 +
|-
 +
| entity
 +
| int(11)
 +
|  
 +
|
 +
| 1
 +
|
 +
| multi company id
 +
|-
 +
| module
 +
| varchar(64)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| module name if record is added by a module
 +
|-
 +
| type
 +
| varchar(4)
 +
| NO
 +
|
 +
|
 +
|
 +
| type of menu (top or left)
 +
|-
 +
| mainmenu
 +
| varchar(100)
 +
| NO
 +
|
 +
|
 +
|
 +
| Name family/module (home, companies, etc.)
 +
|-
 +
| fk_menu
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| 0 or Id of mother menu line
 +
|-
 +
| position
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| sort order of entry
 +
|-
 +
| url
 +
| varchar(255)
 +
| NO
 +
|
 +
|
 +
|
 +
| relative (or absolute) url to go
 +
|-
 +
| tarjet
 +
| 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
 +
| tint(1)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| only used by auguria menu. Do not use
 +
|-
 +
| leftmenu
 +
| varchar(1)
 +
| YES
 +
|
 +
| 1
 +
|
 +
| say if left menu defined in pre.inc.php and used by top menu must be overwritten by dynamic databse menu (1=yes by default)
 +
|-
 +
| perms
 +
| varchar(255)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| condition to show enabled or disabled
 +
|-
 +
| enabled
 +
| varchar(255)
 +
| YES
 +
|
 +
| 1
 +
|
 +
| condition to show or hide
 +
|-
 +
| user
 +
| int(11)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| 0 if menu for all users, 1 for external only, 2 for internal only
 +
|-
 +
| tms
 +
| timestamp
 +
| NO
 +
|
 +
| CURRENT_TIMESTAMP
 +
|
 +
| last update date
 
|}
 
|}

Revision as of 13:57, 4 August 2009


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the menus.

Fr verysmall.png Contient les menus.

Es verysmall.png Contiene los menús.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
menu_handler varchar(16) NO NULL Menu handler name
entity int(11)   1 multi company id
module varchar(64) YES NULL module name if record is added by a module
type varchar(4) NO type of menu (top or left)
mainmenu varchar(100) NO Name family/module (home, companies, etc.)
fk_menu int(11) NO 0 or Id of mother menu line
position int(11) NO sort order of entry
url varchar(255) NO relative (or absolute) url to go
tarjet 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 tint(1) YES NULL only used by auguria menu. Do not use
leftmenu varchar(1) YES 1 say if left menu defined in pre.inc.php and used by top menu must be overwritten by dynamic databse menu (1=yes by default)
perms varchar(255) YES NULL condition to show enabled or disabled
enabled varchar(255) YES 1 condition to show or hide
user int(11) NO 0 0 if menu for all users, 1 for external only, 2 for internal only
tms timestamp NO CURRENT_TIMESTAMP last update date
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_menu&oldid=13559"