Difference between revisions of "Table llx user param"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
| + | == Table == | ||
| + | '''Version 1.1 2009/10/07''' | ||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 22: | Line 24: | ||
|style="background-color: #e9e9ef"| <b>Extra</b> | |style="background-color: #e9e9ef"| <b>Extra</b> | ||
|style="background-color: #e9e9ef"| <b>Description</b> | |style="background-color: #e9e9ef"| <b>Description</b> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| fk_user | | fk_user | ||
| int(11) | | int(11) | ||
| NO | | NO | ||
| − | | | + | | UNI |
| | | | ||
| | | | ||
| Line 42: | Line 36: | ||
| int(11) | | int(11) | ||
| NO | | NO | ||
| − | | | + | | UNI |
| 1 | | 1 | ||
| | | | ||
| Line 50: | Line 44: | ||
| varchar(64) | | varchar(64) | ||
| NO | | NO | ||
| − | | | + | | UNI |
| | | | ||
| | | | ||
| Line 62: | Line 56: | ||
| | | | ||
| parameter value | | parameter value | ||
| − | |} | + | |} |
| + | == Keys == | ||
| + | '''Version 1.1 2009/10/07''' | ||
| + | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
| + | |style="background-color: #e9e9ef"| <b>Key</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Fields</b> | ||
| + | |- | ||
| + | | uk_user_param | ||
| + | | UNIQUE | ||
| + | | fk_user,param,entity | ||
| + | |} | ||
Revision as of 14:23, 9 November 2009
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains a list of parameters for each user. More information on page Constants.
Contient la liste des paramétrages propres aux utilisateurs. Plus d'information sur la page Constantes.
Contiene la lista de parámetros para cada usuario. Más información en la página Constantes ES.
Structure
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| fk_user | int(11) | NO | UNI | ID of user (llx_user->rowid) | ||
| entity | int(11) | NO | UNI | 1 | multi company id | |
| param | varchar(64) | NO | UNI | parameter | ||
| value | varchar(255) | NO | parameter value |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| uk_user_param | UNIQUE | fk_user,param,entity |