Line 15:
Line 15:
= Structure =
= Structure =
== Table ==
== Table ==
−
'''Version 1.1 2009/10/07'''
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
{| 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>
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>
Line 32:
Line 31:
| auto_increment
| auto_increment
| technical index
| technical index
−
|-
+
{{FieldTms}}
−
| tms
−
| timestamp
−
| NO
−
|
−
| CURRENT_TIMESTAMP
−
|
−
| last update date
|-
|-
| ref
| ref
Line 56:
Line 48:
|
|
| multi company id
| multi company id
+
|-
+
| ref_customer
+
| varchar(30)
+
| YES
+
|
+
| NULL
+
|
+
| ref. customer number
|-
|-
| fk_soc
| fk_soc
Line 201:
Line 201:
| Model PDF to print
| Model PDF to print
|}
|}
+
== Keys ==
== Keys ==
−
'''Version 1.1 2009/10/07'''
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
{| 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>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>