|
id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
0
|
|
branch_id
|
int(11)
|
|
|
0
|
|
student_id
|
int(11)
|
|
|
0
|
|
incident_date
|
date
|
|
|
|
|
incident_type
|
enum
|
-- |
|
Behaviour
|
|
severity
|
enum
|
-- |
|
Low
|
|
reported_by
|
varchar(150)
|
|
|
|
|
incident_description
|
text
|
|
|
|
|
action_taken
|
varchar(150)
|
|
|
|
|
parent_status
|
enum
|
-- |
|
Not Informed
|
|
record_status
|
enum
|
-- |
|
Open
|
|
followup_date
|
date
|
|
|
|
|
counsellor_name
|
varchar(150)
|
|
|
|
|
ai_risk_flag
|
enum
|
-- |
|
Normal
|
|
teacher_remarks
|
text
|
|
|
|
|
admin_remarks
|
text
|
|
|
|
|
created_by
|
int(11)
|
|
|
0
|
|
updated_by
|
int(11)
|
|
|
0
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|