| id |
bigint(20)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| item_type |
enum('asset', 'consumable')
|
utf8mb4_unicode_ci
|
|
|
| item_id |
int(11)
|
|
|
|
| voucher_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| custody_date |
date
|
|
|
|
| quantity |
decimal(12,2)
|
|
|
|
| item_condition |
enum('new', 'used', 'needs_maintenance', 'damaged')
|
utf8mb4_unicode_ci
|
|
|
| movement_type |
enum('receive', 'return', 'transfer')
|
utf8mb4_unicode_ci
|
|
|
| transferred_to_employee_id |
int(11)
|
|
|
|
| signature_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| verification_qr |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| balance_after |
decimal(12,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
