| id |
bigint(20)
|
|
|
|
| user_id |
bigint(20)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| requested_amount |
decimal(10,2)
|
|
|
|
| approved_amount |
decimal(10,2)
|
|
|
|
| status |
enum('PENDING', 'APPROVED', 'REJECTED', 'CANCELLED')
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| image_url |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| original_filename |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| mime_type |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| file_size |
bigint(20)
|
|
|
|
| qr_code |
text
|
utf8mb4_unicode_ci
|
|
|
| trans_ref |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| submitted_at |
timestamp
|
|
|
|
| reviewed_at |
timestamp
|
|
|
|
| metadata |
longtext
|
utf8mb4_bin
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|