| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| application_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| application_date |
date
|
|
|
|
| enquiry_id |
int(10)
|
|
|
|
| admission_type |
enum('New', 'Re Admission', 'Transfer', 'Sibling', 'Staff Child')
|
utf8mb4_unicode_ci
|
|
|
| student_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| gender |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| dob |
date
|
|
|
|
| blood_group |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| nationality |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| religion |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| category |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| caste |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sub_caste |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| mother_tongue |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| academic_year_id |
int(10)
|
|
|
|
| academic_year_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| class_id |
int(10)
|
|
|
|
| class_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| section_id |
int(10)
|
|
|
|
| section_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| father_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| father_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_occupation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_income |
decimal(12,2)
|
|
|
|
| mother_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| mother_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_occupation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_income |
decimal(12,2)
|
|
|
|
| guardian_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| guardian_relation |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| guardian_mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| guardian_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| primary_mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| alternate_mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| whatsapp_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| primary_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| current_address |
text
|
utf8mb4_unicode_ci
|
|
|
| permanent_address |
text
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| pincode |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| previous_school |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| previous_class |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| previous_board |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| previous_percentage |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| transfer_certificate_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sibling_available |
tinyint(1)
|
|
|
|
| sibling_details |
text
|
utf8mb4_unicode_ci
|
|
|
| transport_required |
tinyint(1)
|
|
|
|
| hostel_required |
tinyint(1)
|
|
|
|
| application_fee |
decimal(12,2)
|
|
|
|
| registration_fee |
decimal(12,2)
|
|
|
|
| fee_concession_requested |
tinyint(1)
|
|
|
|
| fee_concession_remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| selection_status |
enum('Draft', 'Submitted', 'Under Review', 'Interview Scheduled', 'Selected', 'Waiting List', 'Rejected', 'Cancelled', 'Admitted')
|
utf8mb4_unicode_ci
|
|
|
| approval_status |
enum('Pending', 'Approved', 'Rejected')
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(10)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| admission_no |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| student_id |
int(10)
|
|
|
|
| admitted_at |
datetime
|
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| deleted_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|