| id_order_detail |
int(10)
|
|
|
|
| id_order |
int(10)
|
|
|
|
| id_order_invoice |
int(11)
|
|
|
|
| id_warehouse |
int(10)
|
|
|
|
| id_shop |
int(11)
|
|
|
|
| product_id |
int(10)
|
|
|
|
| product_attribute_id |
int(10)
|
|
|
|
| id_customization |
int(10)
|
|
|
|
| product_name |
mediumtext
|
utf8mb4_general_ci
|
|
|
| product_quantity |
int(10)
|
|
|
|
| product_quantity_in_stock |
int(10)
|
|
|
|
| product_quantity_refunded |
int(10)
|
|
|
|
| product_quantity_return |
int(10)
|
|
|
|
| product_quantity_reinjected |
int(10)
|
|
|
|
| product_price |
decimal(20,6)
|
|
|
|
| reduction_percent |
decimal(5,2)
|
|
|
|
| reduction_amount |
decimal(20,6)
|
|
|
|
| reduction_amount_tax_incl |
decimal(20,6)
|
|
|
|
| reduction_amount_tax_excl |
decimal(20,6)
|
|
|
|
| group_reduction |
decimal(5,2)
|
|
|
|
| product_quantity_discount |
decimal(20,6)
|
|
|
|
| product_ean13 |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| product_isbn |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| product_upc |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| product_mpn |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| product_reference |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| product_supplier_reference |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| product_weight |
decimal(20,6)
|
|
|
|
| id_tax_rules_group |
int(11)
|
|
|
|
| tax_computation_method |
tinyint(1)
|
|
|
|
| tax_name |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| tax_rate |
decimal(10,3)
|
|
|
|
| ecotax |
decimal(17,6)
|
|
|
|
| ecotax_tax_rate |
decimal(5,3)
|
|
|
|
| discount_quantity_applied |
tinyint(1)
|
|
|
|
| download_hash |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| download_nb |
int(10)
|
|
|
|
| download_deadline |
datetime
|
|
|
|
| total_price_tax_incl |
decimal(20,6)
|
|
|
|
| total_price_tax_excl |
decimal(20,6)
|
|
|
|
| unit_price_tax_incl |
decimal(20,6)
|
|
|
|
| unit_price_tax_excl |
decimal(20,6)
|
|
|
|
| total_shipping_price_tax_incl |
decimal(20,6)
|
|
|
|
| total_shipping_price_tax_excl |
decimal(20,6)
|
|
|
|
| purchase_supplier_price |
decimal(20,6)
|
|
|
|
| original_product_price |
decimal(20,6)
|
|
|
|
| original_wholesale_price |
decimal(20,6)
|
|
|
|
| total_refunded_tax_excl |
decimal(20,6)
|
|
|
|
| total_refunded_tax_incl |
decimal(20,6)
|
|
|
|
