Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id_order_detail | int(10) unsigned | NO | PRI | auto_increment | |
| id_order | int(10) unsigned | NO | MUL | ||
| id_order_invoice | int(11) | YES | |||
| id_warehouse | int(10) unsigned | YES | 0 | ||
| id_shop | int(11) unsigned | NO | |||
| product_id | int(10) unsigned | NO | MUL | ||
| product_attribute_id | int(10) unsigned | YES | MUL | ||
| id_customization | int(10) unsigned | YES | 0 | ||
| product_name | mediumtext | NO | |||
| product_quantity | int(10) unsigned | NO | 0 | ||
| product_quantity_in_stock | int(10) | NO | 0 | ||
| product_quantity_refunded | int(10) unsigned | NO | 0 | ||
| product_quantity_return | int(10) unsigned | NO | 0 | ||
| product_quantity_reinjected | int(10) unsigned | NO | 0 | ||
| product_price | decimal(20,6) | NO | 0.000000 | ||
| reduction_percent | decimal(5,2) | NO | 0.00 | ||
| reduction_amount | decimal(20,6) | NO | 0.000000 | ||
| reduction_amount_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| reduction_amount_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| group_reduction | decimal(5,2) | NO | 0.00 | ||
| product_quantity_discount | decimal(20,6) | NO | 0.000000 | ||
| product_ean13 | varchar(13) | YES | |||
| product_isbn | varchar(32) | YES | |||
| product_upc | varchar(12) | YES | |||
| product_mpn | varchar(40) | YES | |||
| product_reference | varchar(64) | YES | |||
| product_supplier_reference | varchar(64) | YES | |||
| product_weight | decimal(20,6) | NO | |||
| id_tax_rules_group | int(11) unsigned | YES | MUL | 0 | |
| tax_computation_method | tinyint(1) unsigned | NO | 0 | ||
| tax_name | varchar(16) | NO | |||
| tax_rate | decimal(10,3) | NO | 0.000 | ||
| ecotax | decimal(17,6) | NO | 0.000000 | ||
| ecotax_tax_rate | decimal(5,3) | NO | 0.000 | ||
| discount_quantity_applied | tinyint(1) | NO | 0 | ||
| download_hash | varchar(255) | YES | |||
| download_nb | int(10) unsigned | YES | 0 | ||
| download_deadline | datetime | YES | |||
| total_price_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| total_price_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| unit_price_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| unit_price_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_shipping_price_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| total_shipping_price_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| purchase_supplier_price | decimal(20,6) | NO | 0.000000 | ||
| original_product_price | decimal(20,6) | NO | 0.000000 | ||
| original_wholesale_price | decimal(20,6) | NO | 0.000000 | ||
| total_refunded_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_refunded_tax_incl | decimal(20,6) | NO | 0.000000 |
| id_order_detail | id_order | id_order_invoice | id_warehouse | id_shop | product_id | product_attribute_id | id_customization | product_name | product_quantity | product_quantity_in_stock | product_quantity_refunded | product_quantity_return | product_quantity_reinjected | product_price | reduction_percent | reduction_amount | reduction_amount_tax_incl | reduction_amount_tax_excl | group_reduction | product_quantity_discount | product_ean13 | product_isbn | product_upc | product_mpn | product_reference | product_supplier_reference | product_weight | id_tax_rules_group | tax_computation_method | tax_name | tax_rate | ecotax | ecotax_tax_rate | discount_quantity_applied | download_hash | download_nb | download_deadline | total_price_tax_incl | total_price_tax_excl | unit_price_tax_incl | unit_price_tax_excl | total_shipping_price_tax_incl | total_shipping_price_tax_excl | purchase_supplier_price | original_product_price | original_wholesale_price | total_refunded_tax_excl | total_refunded_tax_incl |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | Hummingbird printed t-shirt - Color : White, Size : S | 1 | 1 | 0 | 0 | 0 | 23.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_1 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 23.900000 | 23.900000 | 23.900000 | 23.900000 | 0.000000 | 0.000000 | 0.000000 | 23.900000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 2 | 1 | 0 | 0 | 1 | 2 | 9 | 0 | Hummingbird printed sweater - Color : White, Size : S | 1 | 1 | 0 | 0 | 0 | 35.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_3 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 35.900000 | 35.900000 | 35.900000 | 35.900000 | 0.000000 | 0.000000 | 0.000000 | 35.900000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 3 | 2 | 0 | 0 | 1 | 4 | 18 | 0 | The adventure begins Framed poster - Size : 80x120cm | 2 | 3 | 0 | 0 | 0 | 79.000000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_5 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 158.000000 | 158.000000 | 79.000000 | 79.000000 | 0.000000 | 0.000000 | 0.000000 | 79.000000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 4 | 2 | 0 | 0 | 1 | 8 | 0 | 0 | Mug Today is a good day | 1 | 1 | 0 | 0 | 0 | 11.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_13 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 11.900000 | 11.900000 | 11.900000 | 11.900000 | 0.000000 | 0.000000 | 0.000000 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 5 | 3 | 0 | 0 | 1 | 16 | 28 | 0 | Mountain fox notebook Style : Ruled | 1 | 1 | 0 | 0 | 0 | 12.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_8 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 12.900000 | 12.900000 | 12.900000 | 12.900000 | 0.000000 | 0.000000 | 0.000000 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 6 | 4 | 0 | 0 | 1 | 16 | 29 | 0 | Mountain fox notebook Style : Plain | 1 | 1 | 0 | 0 | 0 | 12.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_8 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 12.900000 | 12.900000 | 12.900000 | 12.900000 | 0.000000 | 0.000000 | 0.000000 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | |||||||
| 7 | 5 | 0 | 0 | 1 | 10 | 25 | 0 | Brown bear cushion Color : Black | 1 | 1 | 0 | 0 | 0 | 18.900000 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | demo_16 | 0.000000 | 0 | 0 | 0.000 | 0.000000 | 0.000 | 0 | 0 | 0000-00-00 00:00:00 | 18.900000 | 18.900000 | 18.900000 | 18.900000 | 0.000000 | 0.000000 | 0.000000 | 18.900000 | 5.490000 | 0.000000 | 0.000000 |