Table llx user entrepot: Difference between revisions

← Older edit

Table llx user entrepot (view source)

Revision as of 16:01, 19 July 2011

1,071 bytes added , 15 years ago

→‎Structure

VisualWikitext

Simnandez

Bureaucrats, Administrators

4,395

edits

@@ Line 1: / Line 1: @@
-[[Catégorie:Stock]][[Catégorie:Utilisateur]][[Catégorie:Table SQL]]
+[[Category:Stock]]
+[[Category:Table SQL]]
+[[Category:Utilisateurs]]
+[[Category:Users]]
+[[Category:Usuarios]]
+{{ListOfTables}}
-La table '''llx_user_entrepot''' permet d'affecter un stock à un utilisateur avec des permissions spécifiques
+= Content/Contenu/Contenido =
-create table llx_user_entrepot
+{{flag_en}} Allows to assign a stock to a user with specific permissions.
-(
-  rowid        integer AUTO_INCREMENT PRIMARY KEY,
+{{flag_fr}} Permet d'affecter un stock à un utilisateur avec des permissions spécifiques.
-  fk_entrepot  integer UNSIGNED, -- pointe sur llx_entrepot
-  fk_user      integer UNSIGNED, -- pointe sur llx_user
+{{flag_sp}} Permite asignar un stock a un usuario con permisos específicos.
-  consult      tinyint(1) UNSIGNED,
-  send         tinyint(1) UNSIGNED
+= Structure =
-)type=innodb;
+== 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>
+|-
+| rowid
+| int(11)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| fk_entrepot
+| int(10)
+| YES
+|
+| NULL
+|
+| ID of warehouse ([[Table llx_entrepot|llx_entrepot]]->rowid)
+|-
+| fk_user
+| int(10)
+| YES
+|
+| NULL
+|
+| ID of user ([[Table llx_user|llx_user]]->rowid)
+|-
+| consult
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|-
+| send
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|}&nbsp;
+== 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>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|}&nbsp;