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_invoice | int(11) unsigned | NO | PRI | auto_increment | |
| id_order | int(11) | NO | MUL | ||
| number | int(11) | NO | |||
| delivery_number | int(11) | NO | |||
| delivery_date | datetime | YES | |||
| total_discount_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_discount_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| total_paid_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_paid_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| total_products | decimal(20,6) | NO | 0.000000 | ||
| total_products_wt | decimal(20,6) | NO | 0.000000 | ||
| total_shipping_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_shipping_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| shipping_tax_computation_method | int(10) unsigned | NO | |||
| total_wrapping_tax_excl | decimal(20,6) | NO | 0.000000 | ||
| total_wrapping_tax_incl | decimal(20,6) | NO | 0.000000 | ||
| shop_address | mediumtext | YES | |||
| note | mediumtext | YES | |||
| date_add | datetime | NO |