Latest revision as of 22:33, 31 March 2022

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

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the order position of active boxes

Contient la position des boîtes actives

Contiene la ordenación de las cajas activas.

Structure

Table

Version Dolibarr 15

#	Field	Type	Null	Key	Default	Extra	Description
1	rowid	int(11)	NO	PRI	NULL	auto_increment	technical index
2	entity	int(11)	NO		1
3	box_id	int(11)	NO	UNI			ID of box (llx_boxes_def->rowid)
4	position	smallint(6)	NO	UNI			Position of box
5	box_order	varchar(3)	NO				Order of box
6	fk_user	int(11)	NO	UNI	0		ID of user that affect the box order (llx_user->rowid)
7	maxline	int(11)	YES		NULL
8	params	varchar(255)	YES		NULL

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_boxes	UNIQUE	box_id,position,fk_user
idx_boxes_boxid	MULTIPLE	box_id
idx_boxes_fk_user	MULTIPLE	fk_user

@@ Line 3: / Line 3: @@
 {{ListOfTables}}
-= Contenu =
+=Content/Contenu/Contenido=
+{{flag en}}
+ Contains the order position of active boxes
-= Structure =
+{{flag fr}}
+ Contient la position des boîtes actives
-{|  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"
+{{flag sp}}
-  |style="background-color: #e9e9ef"| <b>Field</b>
+ Contiene la ordenación de las cajas activas.
-  |style="background-color: #e9e9ef"| <b>Type</b>
-  |style="background-color: #e9e9ef"| <b>Null</b>
+=Structure=
-  |style="background-color: #e9e9ef"| <b>Key</b>
+==Table==
-  |style="background-color: #e9e9ef"| <b>Default</b>
-  |style="background-color: #e9e9ef"| <b>Extra</b>
-  |style="background-color: #e9e9ef"| <b>Description</b>
+Version  Dolibarr 15
+<br />
+{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
+  |#
+| 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>
+|-
+|1
+|rowid
+|int(11)
+|NO
+|PRI
+|NULL
+|auto_increment
+|technical index
+|-
+|2
+|entity
+|int(11)
+|NO
+|
+|1
+|
+|
+|-
+|3
+|box_id
+|int(11)
+|NO
+|UNI
+|
+|
+|ID of box ([[Boxes def (Table SQL)|llx_boxes_def]]->rowid)
+|-
+|4
+|position
+|smallint(6)
+|NO
+|UNI
+|
+|
+|Position of box
+|-
+|5
+|box_order
+|varchar(3)
+|NO
+|
+|
+|
+|Order of box
+|-
+|6
+|fk_user
+|int(11)
+|NO
+|UNI
+|0
+|
+|ID of user that affect the box order ([[Table llx_user|llx_user]]->rowid)
+|-
+|7
+|maxline
+|int(11)
+|YES
+|
+|NULL
+|
+|
+|-
+|8
+|params
+|varchar(255)
+|YES
+|
+|NULL
+|
+|
+|}&nbsp;
+==Keys==
+{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
+  | style="background-color: #e9e9ef" |<b>Key</b>
+  | style="background-color: #e9e9ef" |<b>Type</b>
+  | style="background-color: #e9e9ef" |<b>Fields</b>
 |-
-| rowid
+|PRIMARY
-| int(11)
+|PRIMARY
-| &nbsp;
+|rowid
-| PRI
+|-
-| NULL
+|uk_boxes
-| auto_increment
+|UNIQUE
-| index technique
+|box_id,position,fk_user
-|}
+|-
+|idx_boxes_boxid
-A complèter
+|MULTIPLE
+|box_id
+|-
+|idx_boxes_fk_user
+|MULTIPLE
+|fk_user
+|}&nbsp;

Table llx boxes: Difference between revisions

Latest revision as of 22:33, 31 March 2022

Content/Contenu/Contenido

Structure

Table

Keys