29,352
edits
Changes
→Table
Line 12:
Line 12:
|-+| tms
−| timestamp
−| YES
−|
−| CURRENT_TIMESTAMP
−|
−|
+
= 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}}
−|-
|-
| 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
+|}