29,279
edits
Changes
→Structure
Line 1:
Line 1:
+
[[Category:Table SQL]]
[[Category:Table SQL]]
[[Category:Expedition]]
[[Category:Expedition]]
+[[Category:Shipment]]
+[[Category:Expediciones]]
+
{{ListOfTables}}
{{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
+|}