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_supply_order_detail | int(11) unsigned | NO | PRI | auto_increment | |
| id_supply_order | int(11) unsigned | NO | MUL | ||
| id_currency | int(11) unsigned | NO | |||
| id_product | int(11) unsigned | NO | MUL | ||
| id_product_attribute | int(11) unsigned | NO | MUL | ||
| reference | varchar(64) | NO | |||
| supplier_reference | varchar(64) | NO | |||
| name | varchar(128) | NO | |||
| ean13 | varchar(13) | YES | |||
| isbn | varchar(32) | YES | |||
| upc | varchar(12) | YES | |||
| mpn | varchar(40) | YES | |||
| exchange_rate | decimal(20,6) | YES | 0.000000 | ||
| unit_price_te | decimal(20,6) | YES | 0.000000 | ||
| quantity_expected | int(11) unsigned | NO | |||
| quantity_received | int(11) unsigned | NO | |||
| price_te | decimal(20,6) | YES | 0.000000 | ||
| discount_rate | decimal(20,6) | YES | 0.000000 | ||
| discount_value_te | decimal(20,6) | YES | 0.000000 | ||
| price_with_discount_te | decimal(20,6) | YES | 0.000000 | ||
| tax_rate | decimal(20,6) | YES | 0.000000 | ||
| tax_value | decimal(20,6) | YES | 0.000000 | ||
| price_ti | decimal(20,6) | YES | 0.000000 | ||
| tax_value_with_order_discount | decimal(20,6) | YES | 0.000000 | ||
| price_with_order_discount_te | decimal(20,6) | YES | 0.000000 |