| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| academic_year_id |
int(11)
|
|
|
|
| log_type |
enum('MASTER_SETUP', 'TEACHER_SELF_ENTRY', 'AI_GENERATION', 'MANUAL_ADJUST', 'LOCK', 'UNLOCK', 'APPROVAL', 'PUBLISH', 'UNPUBLISH', 'VERSION', 'ROOM_BOOKING', 'DAILY_CHANGE', 'LEAVE', 'SUBSTITUTION', 'IMPORT', 'REPORT', 'OTHER')
|
utf8mb4_general_ci
|
|
|
| reference_table |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| reference_id |
int(11)
|
|
|
|
| action_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| old_data_json |
longtext
|
utf8mb4_general_ci
|
|
|
| new_data_json |
longtext
|
utf8mb4_general_ci
|
|
|
| ip_address |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| user_agent |
text
|
utf8mb4_general_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|