| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| academic_year_id |
int(11)
|
|
|
|
| import_type |
enum('PERIODS', 'ROOMS', 'QUOTAS', 'TEACHER_MAPPING', 'TIMETABLE_ENTRIES', 'FULL_IMPORT')
|
utf8mb4_general_ci
|
|
|
| file_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| file_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| total_rows |
int(11)
|
|
|
|
| success_rows |
int(11)
|
|
|
|
| failed_rows |
int(11)
|
|
|
|
| status |
enum('UPLOADED', 'PROCESSING', 'COMPLETED', 'FAILED')
|
utf8mb4_general_ci
|
|
|
| error_json |
longtext
|
utf8mb4_general_ci
|
|
|
| summary_json |
longtext
|
utf8mb4_general_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|