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 | int(11) unsigned | NO | PRI | auto_increment | |
| id_supplier | int(11) unsigned | NO | MUL | ||
| supplier_name | varchar(64) | NO | |||
| id_lang | int(11) unsigned | NO | |||
| id_warehouse | int(11) unsigned | NO | MUL | ||
| id_supply_order_state | int(11) unsigned | NO | |||
| id_currency | int(11) unsigned | NO | |||
| id_ref_currency | int(11) unsigned | NO | |||
| reference | varchar(64) | NO | MUL | ||
| date_add | datetime | NO | |||
| date_upd | datetime | NO | |||
| date_delivery_expected | datetime | YES | |||
| total_te | decimal(20,6) | YES | 0.000000 | ||
| total_with_discount_te | decimal(20,6) | YES | 0.000000 | ||
| total_tax | decimal(20,6) | YES | 0.000000 | ||
| total_ti | decimal(20,6) | YES | 0.000000 | ||
| discount_rate | decimal(20,6) | YES | 0.000000 | ||
| discount_value_te | decimal(20,6) | YES | 0.000000 | ||
| is_template | tinyint(1) | YES | 0 |