|
id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
0
|
|
branch_id
|
int(11)
|
|
|
0
|
|
student_code
|
varchar(50)
|
|
|
|
|
admission_no
|
varchar(50)
|
|
|
|
|
admission_date
|
date
|
|
|
|
|
first_name
|
varchar(100)
|
|
|
|
|
middle_name
|
varchar(100)
|
|
|
|
|
last_name
|
varchar(100)
|
|
|
|
|
full_name
|
varchar(255)
|
|
|
|
|
gender
|
varchar(20)
|
|
|
|
|
dob
|
date
|
|
|
|
|
blood_group
|
varchar(10)
|
|
|
|
|
mobile_no
|
varchar(20)
|
|
|
|
|
email
|
varchar(150)
|
|
|
|
|
photo
|
varchar(255)
|
|
|
|
|
aadhaar_no
|
varchar(30)
|
|
|
|
|
religion
|
varchar(80)
|
|
|
|
|
category
|
varchar(80)
|
|
|
|
|
caste
|
varchar(100)
|
|
|
|
|
nationality
|
varchar(80)
|
|
|
Indian
|
|
mother_tongue
|
varchar(80)
|
|
|
|
|
student_status
|
enum
|
-- |
|
Draft
|
|
parent_app_status
|
enum
|
-- |
|
Pending
|
|
mobile_app_enabled
|
tinyint(1)
|
|
|
0
|
|
ai_attendance_risk
|
varchar(30)
|
|
|
Normal
|
|
ai_academic_risk
|
varchar(30)
|
|
|
Normal
|
|
ai_fee_risk
|
varchar(30)
|
|
|
Normal
|
|
ai_dropout_risk
|
varchar(30)
|
|
|
Normal
|
|
ai_discipline_risk
|
varchar(50)
|
|
|
Normal
|
|
ai_overall_risk_score
|
decimal(5,2)
|
|
|
0.00
|
|
ai_recommendation
|
text
|
|
|
|
|
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()
|