Table llx boxes def: Difference between revisions

← Older edit

Table llx boxes def (view source)

Revision as of 07:37, 1 April 2022

1,363 bytes added , 4 years ago

m

no edit summary

VisualWikitext

Eldy

Bureaucrats, Interface administrators, Administrators

31,029

edits

@@ Line 1: / Line 1: @@
-[[Catégorie:Table SQL]]
+[[Category:Table SQL]]
-  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
-  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+{{ListOfTables}}
-= Contenu =
+=Content/Contenu/Contenido=
+{{flag en}}
+ Contains the active boxes
-= Structure =
+{{flag fr}}
+ Contient les boîtes actives
+{{flag sp}}
+ Contiene las cajas activas.
+=Structure=
+==Table==
+'''Version  Dolibarr 15'''
+{| 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>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
+|-
+|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
+{{FieldTms}}
+|-
+|note
+|varchar(130)
+|YES
+|
+|NULL
+|
+|comments
+|}&nbsp;
+==Keys==
+'''Version 1.2 2009/10/17'''
+{| 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>Key</b>
+ | style="background-color: #e9e9ef" |<b>Type</b>
+ | style="background-color: #e9e9ef" |<b>Fields</b>
+|-
+|PRIMARY
+|PRIMARY
+|rowid
+|-
+|uk_boxes_def
+|UNIQUE
+|file,entity
+|}&nbsp;