29,030
edits
Changes
Jump to navigation
Jump to search
m
no edit summary
Line 3:
Line 3:
{{ListOfTables}}
{{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
−| varchar(255)
+|varchar(130)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| comments
+|comments
|}
|}
−== Keys ==
+==Keys==
'''Version 1.2 2009/10/17'''
'''Version 1.2 2009/10/17'''
−{| 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>Key</b>
+ | style="background-color: #e9e9ef" |<b>Key</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
+ | style="background-color: #e9e9ef" |<b>Type</b>
− |style="background-color: #e9e9ef"| <b>Fields</b>
+ | style="background-color: #e9e9ef" |<b>Fields</b>
|-
|-
−| PRIMARY
+|PRIMARY
−| PRIMARY
+|PRIMARY
−| rowid
+|rowid
|-
|-
−| uk_boxes_def
+|uk_boxes_def
−| UNIQUE
+|UNIQUE
−| file,entity
+|file,entity
|}
|}