Line 1:
Line 1:
−
[[Catégorie:Table SQL]]
+
[[Category:Table SQL]]
−
Cette table contient la liste des paramétrages propres aux utilisateurs
+
[[Category:Core]]
+
[[Category:Noyau]]
+
[[Category:Básico]]
+
{{ListOfTables}}
+
+
= 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 =
+
== 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
+
|}