| id |
bigint(20)
|
|
|
|
| part_id |
bigint(20)
|
|
|
|
| warehouse_id |
bigint(20)
|
|
|
|
| movement_type |
enum('opening', 'purchase', 'sale', 'adjustment', 'transfer_in', 'transfer_out', 'return_in', 'return_out')
|
utf8mb4_unicode_ci
|
|
|
| reference_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| reference_id |
bigint(20)
|
|
|
|
| quantity |
decimal(15,2)
|
|
|
|
| unit_cost |
decimal(15,2)
|
|
|
|
| unit_price |
decimal(15,2)
|
|
|
|
| balance_before |
decimal(15,2)
|
|
|
|
| balance_after |
decimal(15,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| performed_by |
bigint(20)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
