Difference between revisions of "Table llx boxes def"

Latest revision as of 07:37, 1 April 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 active boxes

Contient les boîtes actives

Contiene las cajas activas.

Structure

Table

Version Dolibarr 15

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
file	varchar(200)	NO				box file.php
entity	int(11)	NO		1		multi company id
fk_user	int(11)	NO		0		if widget is private to one given user
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
note	varchar(130)	YES		NULL		comments

Keys

Version 1.2 2009/10/17

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_boxes_def	UNIQUE	file,entity

@@ Line 3: / Line 3: @@
 {{ListOfTables}}
-= Content/Contenu/Contenido =
+=Content/Contenu/Contenido=
-{{flag en}} Contains the active boxes
+{{flag en}}
+ Contains the active boxes
-{{flag fr}} Contient les boîtes actives
+{{flag fr}}
+ Contient les boîtes actives
-{{flag sp}} Contiene las cajas activas.
+{{flag sp}}
+ Contiene las cajas activas.
-= Structure =
+=Structure=
-== Table ==
+==Table==
-'''Version 1.1 2009/10/07'''
+'''Version  Dolibarr 15'''
-{|  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"
+{| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
-  |style="background-color: #e9e9ef"| <b>Field</b>
+  | style="background-color: #e9e9ef" |<b>Field</b>
-  |style="background-color: #e9e9ef"| <b>Type</b>
+  | style="background-color: #e9e9ef" |<b>Type</b>
-  |style="background-color: #e9e9ef"| <b>Null</b>
+  | style="background-color: #e9e9ef" |<b>Null</b>
-  |style="background-color: #e9e9ef"| <b>Key</b>
+  | style="background-color: #e9e9ef" |<b>Key</b>
-  |style="background-color: #e9e9ef"| <b>Default</b>
+  | style="background-color: #e9e9ef" |<b>Default</b>
-  |style="background-color: #e9e9ef"| <b>Extra</b>
+  | style="background-color: #e9e9ef" |<b>Extra</b>
-  |style="background-color: #e9e9ef"| <b>Description</b>
+  | style="background-color: #e9e9ef" |<b>Description</b>
 |-
-| rowid
+|rowid
-| int(11)
+|int(11)
-| NO
+|NO
-| PRI
+|PRI
 |
-| auto_increment
+|auto_increment
-| technical index
+|technical index
 |-
-| file
+|file
-| varchar(255)
+|varchar(200)
-| NO
+|NO
 |
 |
 |
-| box file.php
+|box file.php
 |-
-| entity
+|entity
-| int(11)
+|int(11)
-| NO
+|NO
-| PRI
+|
-| 1
+|1
 |
-| multi company id
+|multi company id
 |-
-| tms
+|fk_user
-| timestamp
+|int(11)
-| NO
+|NO
 |
-| CURRENT_TIMESTAMP
+|0
 |
-| last update date
+|if widget is private to one given user
+{{FieldTms}}
 |-
-| note
+|note
-| text
+|varchar(130)
-| YES
+|YES
 |
-| NULL
+|NULL
 |
-| comments
+|comments
 |}&nbsp;
-== Keys ==
-'''Version 1.1 2009/10/07'''
+==Keys==
-{|  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"
+'''Version 1.2 2009/10/17'''
-  |style="background-color: #e9e9ef"| <b>Key</b>
+{| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
-  |style="background-color: #e9e9ef"| <b>Type</b>
+  | style="background-color: #e9e9ef" |<b>Key</b>
-  |style="background-color: #e9e9ef"| <b>Fields</b>
+  | style="background-color: #e9e9ef" |<b>Type</b>
+  | style="background-color: #e9e9ef" |<b>Fields</b>
+|-
+|PRIMARY
+|PRIMARY
+|rowid
 |-
-| PRIMARY
+|uk_boxes_def
-| PRIMARY
+|UNIQUE
-| rowid,entity
+|file,entity
 |}&nbsp;