Line 1:
Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
[[Category:Expedition]]
[[Category:Expedition]]
+
[[Category:Shipment]]
+
[[Category:Expediciones]]
−
La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
{{ListOfTables}}
−
= Contenu =
+
= Content/Contenu/Contenido =
+
{{flag en}} Contains the list of shipping methods
+
{{flag fr}} Contient la liste des methodes de expeditions
+
+
{{flag sp}} Contiene la lista de los métodos de envío
= Structure =
= Structure =
+
== 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>Type</b>
+
|style="background-color: #e9e9ef"| <b>Null</b>
+
|style="background-color: #e9e9ef"| <b>Key</b>
+
|style="background-color: #e9e9ef"| <b>Default</b>
+
|style="background-color: #e9e9ef"| <b>Extra</b>
+
|style="background-color: #e9e9ef"| <b>Description</b>
+
|-
+
| rowid
+
| int(11)
+
| NO
+
| PRI
+
|
+
| auto_increment
+
| technical index
+
|-
+
| tms
+
| timestamp
+
| NO
+
|
+
| CURRENT_TIMESTAMP
+
|
+
| last update date
+
|-
+
| code
+
| varchar(30)
+
| NO
+
|
+
|
+
|
+
| code of shipping method
+
|-
+
| libelle
+
| varchar(50)
+
| NO
+
|
+
|
+
|
+
| label of shipping method
+
|-
+
| description
+
| text
+
| YES
+
|
+
| NULL
+
|
+
| description of shipping method
+
|-
+
| active
+
| tinyint(4)
+
| YES
+
|
+
| 0
+
|
+
| is the shipping method active(1=Yes, 0=No)?
+
|}
+
== 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
+
|}