| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| student_id |
int(11)
|
|
|
|
| father_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| father_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_occupation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_income |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| father_aadhaar |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| mother_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| mother_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_occupation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_income |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| mother_aadhaar |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| guardian_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| guardian_relation |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| guardian_mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| guardian_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| primary_contact |
enum('Father', 'Mother', 'Guardian')
|
utf8mb4_unicode_ci
|
|
|
| login_mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| parent_app_status |
enum('Pending', 'Invite Sent', 'Activated', 'Disabled')
|
utf8mb4_unicode_ci
|
|
|
| parent_app_enabled |
tinyint(1)
|
|
|
|
| communication_preference |
enum('App', 'WhatsApp', 'SMS', 'Email', 'Call')
|
utf8mb4_unicode_ci
|
|
|
| notification_language |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| attendance_alerts |
tinyint(1)
|
|
|
|
| fee_reminders |
tinyint(1)
|
|
|
|
| result_notifications |
tinyint(1)
|
|
|
|
| homework_alerts |
tinyint(1)
|
|
|
|
| emergency_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| emergency_mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| emergency_relation |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| pincode |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| sibling_link |
varchar(100)
|
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
|
|
|
|