| id |
bigint(20)
|
|
|
|
| company_id |
bigint(20)
|
|
|
|
| branch_id |
bigint(20)
|
|
|
|
| unit_id |
bigint(20)
|
|
|
|
| batch_code |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| source_file_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| source_file_size |
bigint(20)
|
|
|
|
| source_file_sha256 |
char(64)
|
utf8mb4_unicode_ci
|
|
|
| file_format |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| batch_note |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| total_rows |
int(10)
|
|
|
|
| valid_rows |
int(10)
|
|
|
|
| error_rows |
int(10)
|
|
|
|
| warning_rows |
int(10)
|
|
|
|
| committed_rows |
int(10)
|
|
|
|
| created_by |
bigint(20)
|
|
|
|
| validated_at |
datetime
|
|
|
|
| committed_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|