| id_order |
int(10)
|
|
|
|
| reference |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| id_shop_group |
int(11)
|
|
|
|
| id_shop |
int(11)
|
|
|
|
| id_carrier |
int(10)
|
|
|
|
| id_lang |
int(10)
|
|
|
|
| id_customer |
int(10)
|
|
|
|
| id_cart |
int(10)
|
|
|
|
| id_currency |
int(10)
|
|
|
|
| id_address_delivery |
int(10)
|
|
|
|
| id_address_invoice |
int(10)
|
|
|
|
| current_state |
int(10)
|
|
|
|
| secure_key |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| payment |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| conversion_rate |
decimal(13,6)
|
|
|
|
| module |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| recyclable |
tinyint(1)
|
|
|
|
| gift |
tinyint(1)
|
|
|
|
| gift_message |
mediumtext
|
utf8mb4_general_ci
|
|
|
| mobile_theme |
tinyint(1)
|
|
|
|
| total_discounts |
decimal(20,6)
|
|
|
|
| total_discounts_tax_incl |
decimal(20,6)
|
|
|
|
| total_discounts_tax_excl |
decimal(20,6)
|
|
|
|
| total_paid |
decimal(20,6)
|
|
|
|
| total_paid_tax_incl |
decimal(20,6)
|
|
|
|
| total_paid_tax_excl |
decimal(20,6)
|
|
|
|
| total_paid_real |
decimal(20,6)
|
|
|
|
| total_products |
decimal(20,6)
|
|
|
|
| total_products_wt |
decimal(20,6)
|
|
|
|
| total_shipping |
decimal(20,6)
|
|
|
|
| total_shipping_tax_incl |
decimal(20,6)
|
|
|
|
| total_shipping_tax_excl |
decimal(20,6)
|
|
|
|
| carrier_tax_rate |
decimal(10,3)
|
|
|
|
| total_wrapping |
decimal(20,6)
|
|
|
|
| total_wrapping_tax_incl |
decimal(20,6)
|
|
|
|
| total_wrapping_tax_excl |
decimal(20,6)
|
|
|
|
| round_mode |
tinyint(1)
|
|
|
|
| round_type |
tinyint(1)
|
|
|
|
| invoice_number |
int(10)
|
|
|
|
| delivery_number |
int(10)
|
|
|
|
| invoice_date |
datetime
|
|
|
|
| delivery_date |
datetime
|
|
|
|
| valid |
int(1)
|
|
|
|
| date_add |
datetime
|
|
|
|
| date_upd |
datetime
|
|
|
|
| note |
mediumtext
|
utf8mb4_general_ci
|
|
|
