| id |
bigint(20)
|
|
|
|
| attachment_uuid |
char(36)
|
utf8mb4_unicode_ci
|
|
|
| field_operation_id |
bigint(20)
|
|
|
|
| entity_uuid |
char(36)
|
utf8mb4_unicode_ci
|
|
|
| entity_type |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| evidence_role |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| attachment_kind |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| original_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| client_mime_type |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| verified_mime_type |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| byte_size |
bigint(20)
|
|
|
|
| sha256 |
char(64)
|
utf8mb4_unicode_ci
|
|
|
| total_chunks |
int(10)
|
|
|
|
| received_chunks |
int(10)
|
|
|
|
| upload_state |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| stored_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| latitude |
decimal(10,7)
|
|
|
|
| longitude |
decimal(10,7)
|
|
|
|
| accuracy_meters |
decimal(10,2)
|
|
|
|
| captured_at_utc |
datetime
|
|
|
|
| user_id |
int(11)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| finance_year_id |
int(11)
|
|
|
|
| device_id |
bigint(20)
|
|
|
|
| completed_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|