Line 12:
Line 12:
= Structure =
= Structure =
−
{| 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"
+
== Table ==
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|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 23:
Line 24:
| rowid
| rowid
| int(11)
| int(11)
−
|
+
| NO
| PRI
| PRI
−
| NULL
+
|
| auto_increment
| auto_increment
| technical index
| technical index
Line 35:
Line 36:
| NULL
| NULL
|
|
−
|
+
| creation date
−
|-
+
{{FieldTms}}
−
| tms
−
| timestamp
−
| YES
−
|
−
| CURRENT_TIMESTAMP
−
|
−
|
|-
|-
| label
| label
| varchar(255)
| varchar(255)
−
|
+
| NO
| UNI
| UNI
|
|
|
|
−
|
+
| label of warehouse
+
|-
+
| entity
+
| int(11)
+
| NO
+
| UNI
+
| 1
+
|
+
| multi company id
|-
|-
| description
| description
Line 59:
Line 61:
| NULL
| NULL
|
|
−
|
+
| description of warehouse
|-
|-
| lieu
| lieu
Line 67:
Line 69:
| NULL
| NULL
|
|
−
|
+
| brief explanation of warehouse situation
|-
|-
| address
| address
Line 75:
Line 77:
| NULL
| NULL
|
|
−
|
+
| address of warehouse
|-
|-
| cp
| cp
Line 83:
Line 85:
| NULL
| NULL
|
|
−
|
+
| postal code of warehouse
|-
|-
| ville
| ville
Line 91:
Line 93:
| NULL
| NULL
|
|
−
|
+
| city of warehouse
|-
|-
| fk_pays
| fk_pays
Line 99:
Line 101:
| 0
| 0
|
|
−
|
+
| ID country of warehouse ([[Table llx_c_pays|llx_c_pays]]->rowid)
|-
|-
| statut
| statut
Line 107:
Line 109:
| 1
| 1
|
|
−
|
+
| is the warehouse open (1=open, 0=closed)?
+
|-
+
| valo_pmp
+
| float(12,4)
+
| YES
+
|
+
| NULL
+
|
+
| stock warehouse valorisation in PMP
|-
|-
| fk_user_author
| fk_user_author
Line 115:
Line 125:
| NULL
| NULL
|
|
−
|
+
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
−
|}
+
|}
+
+
== Keys ==
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+
|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_entrepot_label
+
| UNIQUE
+
| label,entity
+
|}