Table llx entrepot: Difference between revisions

 
(3 intermediate revisions by one other user not shown)
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)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
Line 36: Line 37:
|
|
| creation date
| creation date
|-
{{FieldTms}}
| tms
| timestamp
| YES
|
| CURRENT_TIMESTAMP
|
| last update date
|-
|-
| label  
| label  
| varchar(255)  
| varchar(255)  
|
| NO
| UNI  
| UNI  
|
|
Line 55: Line 49:
| entity
| entity
| int(11)  
| int(11)  
| &nbsp;
| NO
|  
| UNI
| 1
| 1
|  
|  
Line 107: Line 101:
| 0
| 0
|
|
| country of warehouse
| ID country of warehouse ([[Table llx_c_pays|llx_c_pays]]->rowid)
|-
|-
| statut  
| statut  
Line 121: Line 115:
| YES
| YES
|  
|  
| NULL
|  
|  
|  
| stock warehouse valorisation in PMP
| sotck warehouse valorisation PMP
|-
|-
| fk_user_author  
| fk_user_author  
Line 132: Line 126:
|  
|  
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
|}
|}&nbsp;
 
== 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
|}&nbsp;