Table llx user entrepot: Difference between revisions

Table llx user entrepot (view source)

606 bytes added , 17 years ago

4,395

edits

@@ Line 11: / Line 11: @@
 = Structure =
-create table llx_user_entrepot
+{|  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>
-  rowid        integer AUTO_INCREMENT PRIMARY KEY,
+ |style="background-color: #e9e9ef"| <b>Type</b>
-  fk_entrepot  integer UNSIGNED, -- pointe sur llx_entrepot
+ |style="background-color: #e9e9ef"| <b>Null</b>
-  fk_user      integer UNSIGNED, -- pointe sur llx_user
+ |style="background-color: #e9e9ef"| <b>Key</b>
-  consult      tinyint(1) UNSIGNED,
+ |style="background-color: #e9e9ef"| <b>Default</b>
-  send         tinyint(1) UNSIGNED
+ |style="background-color: #e9e9ef"| <b>Extra</b>
-)type=innodb;
+  |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+| &nbsp;
+| PRI
+| NULL
+| auto_increment
+| index technique
+|-
+| fk_entrepot
+| int(10)
+| YES
+|
+| NULL
+|
+| pointe sur llx_entrepot
+|-
+| fk_user
+| int(10)
+| YES
+|
+| NULL
+|
+| pointe sur llx_user
+|-
+| consult
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|-
+| send
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|}