4,395
edits
Changes
→Structure
Line 14:
Line 14:
= Structure =
= Structure =
+== Table ==
+'''Version 1.2 2009/10/23'''
{| 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"
{| 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"
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Field</b>
Line 25:
Line 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 57:
Line 59:
| fk_remise_except
| fk_remise_except
| int(11)
| int(11)
−|
+| YES
|
|
| NULL
| NULL
Line 67:
Line 69:
| YES
| YES
|
|
−| NULL
+| 0.000
|
|
| VAT taxes
| VAT taxes
|-
|-
| qty
| qty
−| double
+| real
| YES
| YES
|
|
Line 80:
Line 82:
|-
|-
| remise_percent
| remise_percent
−| double
+| real
| YES
| YES
|
|
Line 88:
Line 90:
|-
|-
| remise
| remise
−| double
+| real
| YES
| YES
|
|
Line 96:
Line 98:
|-
|-
| price
| price
−| double
+| real
| YES
| YES
|
|
Line 107:
Line 109:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| price before discount
| price before discount
Line 115:
Line 117:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total excluding tax
| total excluding tax
Line 123:
Line 125:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total tax
| total tax
Line 131:
Line 133:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total with tax
| total with tax
Line 171:
Line 173:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| purchase price HT
| purchase price HT
Line 179:
Line 181:
| YES
| YES
|
|
−| 0.00
+| 0.000
|
|
| margin (margin on purchase price)
| margin (margin on purchase price)
Line 187:
Line 189:
| YES
| YES
|
|
−| 0.00
+| 0.000
|
|
| mark rate (margin on selling price)
| mark rate (margin on selling price)
Line 206:
Line 208:
|
|
| order view
| order view
−|}
+|}
+== Keys ==
+'''Version 1.2 2009/10/23'''
+{| 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"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|}