Difference between revisions of "Table llx user param"
Jump to navigation
Jump to search
m |
|||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Table SQL]] | [[Category:Table SQL]] | ||
| − | + | [[Category:Core]] | |
| − | + | [[Category:Noyau]] | |
| + | [[Category:Básico]] | ||
| + | {{ListOfTables}} | ||
| − | = Contenu = | + | = Content/Contenu/Contenido = |
| − | + | {{flag_en}} Contains a list of parameters for each user. More information on page [[Constants]]. | |
| − | + | {{flag_fr}} Contient la liste des paramétrages propres aux utilisateurs. Plus d'information sur la page [[Constantes]]. | |
| + | |||
| + | {{flag_sp}} Contiene la lista de parámetros para cada usuario. Más información en la página [[Constantes ES|Constantes]]. | ||
= Structure = | = Structure = | ||
| + | == Table == | ||
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
| + | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Null</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Key</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Default</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Extra</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Description</b> | ||
| + | |- | ||
| + | | fk_user | ||
| + | | int(11) | ||
| + | | NO | ||
| + | | UNI | ||
| + | | | ||
| + | | | ||
| + | | ID of user ([[Table llx_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 == | ||
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
| + | |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 | ||
| + | |} | ||
Latest revision as of 16:01, 19 July 2011
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.
Structure
Table
| 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
| Key | Type | Fields |
| uk_user_param | UNIQUE | fk_user,param,entity |