| id |
bigint(20)
|
|
|
|
| status |
enum('pending', 'confirmed')
|
utf8mb4_unicode_ci
|
|
|
| original_filename |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| stored_filename |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| mime_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| file_size |
int(10)
|
|
|
|
| extracted_payload |
longtext
|
utf8mb4_bin
|
|
|
| unresolved_fields |
longtext
|
utf8mb4_bin
|
|
|
| repair_in_date |
date
|
|
|
|
| invoice_date |
date
|
|
|
|
| payment_date |
date
|
|
|
|
| invoice_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| supplier |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| extracted_license_plate |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_id |
bigint(20)
|
|
|
|
| is_general |
tinyint(1)
|
|
|
|
| extracted_operation_type |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| extracted_operation_subtype |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| service_operation_type_id |
bigint(20)
|
|
|
|
| service_operation_subtype_id |
bigint(20)
|
|
|
|
| mileage |
int(10)
|
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| amount |
decimal(12,2)
|
|
|
|
| vat |
decimal(12,2)
|
|
|
|
| amount_excl_vat |
decimal(12,2)
|
|
|
|
| service_record_id |
bigint(20)
|
|
|
|
| confirmed_at |
timestamp
|
|
|
|
| uploaded_by |
bigint(20)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
