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_stock_mvt | bigint(20) | NO | PRI | auto_increment | |
| id_stock | int(11) | NO | MUL | ||
| id_order | int(11) | YES | |||
| id_supply_order | int(11) | YES | |||
| id_stock_mvt_reason | int(11) | NO | MUL | ||
| id_employee | int(11) | NO | |||
| employee_lastname | varchar(255) | YES | |||
| employee_firstname | varchar(255) | YES | |||
| physical_quantity | int(10) unsigned | NO | |||
| date_add | datetime | NO | |||
| sign | smallint(6) | NO | 1 | ||
| price_te | decimal(20,6) | YES | 0.000000 | ||
| last_wa | decimal(20,6) | YES | 0.000000 | ||
| current_wa | decimal(20,6) | YES | 0.000000 | ||
| referer | bigint(20) | YES |