|
id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
0
|
|
branch_id
|
int(11)
|
|
|
0
|
|
student_id
|
int(11)
|
|
|
0
|
|
academic_year_id
|
int(11)
|
|
|
0
|
|
attendance_score
|
decimal(5,2)
|
|
|
0.00
|
|
academic_score
|
decimal(5,2)
|
|
|
0.00
|
|
fee_risk_score
|
decimal(5,2)
|
|
|
0.00
|
|
behaviour_score
|
decimal(5,2)
|
|
|
0.00
|
|
health_risk_score
|
decimal(5,2)
|
|
|
0.00
|
|
overall_risk_score
|
decimal(5,2)
|
|
|
0.00
|
|
attendance_risk
|
enum
|
-- |
|
Normal
|
|
academic_risk
|
enum
|
-- |
|
Normal
|
|
fee_risk
|
enum
|
-- |
|
Normal
|
|
behaviour_risk
|
enum
|
-- |
|
Normal
|
|
dropout_risk
|
enum
|
-- |
|
Normal
|
|
ai_summary
|
text
|
|
|
|
|
ai_recommendation
|
text
|
|
|
|
|
next_action
|
text
|
|
|
|
|
action_owner
|
varchar(150)
|
|
|
|
|
action_due_date
|
date
|
|
|
|
|
action_status
|
enum
|
-- |
|
Pending
|
|
generated_date
|
date
|
|
|
|
|
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()
|