| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| student_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| admission_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| admission_date |
date
|
|
|
|
| first_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| middle_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| gender |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| dob |
date
|
|
|
|
| blood_group |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| mobile_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| photo |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| aadhaar_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| religion |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| category |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| caste |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| nationality |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| mother_tongue |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| student_status |
enum('Draft', 'Verification', 'Active', 'Inactive', 'TC Requested', 'TC Issued', 'Alumni')
|
utf8mb4_unicode_ci
|
|
|
| parent_app_status |
enum('Pending', 'Invite Sent', 'Activated', 'Disabled')
|
utf8mb4_unicode_ci
|
|
|
| mobile_app_enabled |
tinyint(1)
|
|
|
|
| ai_attendance_risk |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| ai_academic_risk |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| ai_fee_risk |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| ai_dropout_risk |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| ai_discipline_risk |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ai_overall_risk_score |
decimal(5,2)
|
|
|
|
| ai_recommendation |
text
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|