|
id
|
bigint(20) unsigned
|
|
|
|
|
part_id
|
bigint(20) unsigned
|
|
|
|
|
warehouse_id
|
bigint(20) unsigned
|
|
|
|
|
movement_type
|
enum
|
-- |
|
|
|
reference_type
|
varchar(100)
|
|
|
|
|
reference_id
|
bigint(20) unsigned
|
|
|
|
|
quantity
|
decimal(15,2)
|
|
|
|
|
unit_cost
|
decimal(15,2)
|
|
|
0.00
|
|
unit_price
|
decimal(15,2)
|
|
|
0.00
|
|
balance_before
|
decimal(15,2)
|
|
|
0.00
|
|
balance_after
|
decimal(15,2)
|
|
|
0.00
|
|
notes
|
text
|
|
|
|
|
performed_by
|
bigint(20) unsigned
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|