| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| student_id |
int(11)
|
|
|
|
| admission_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| enquiry_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| application_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| admission_type |
enum('New Admission', 'Transfer Admission', 'Promoted', 'Re-admission')
|
utf8mb4_unicode_ci
|
|
|
| previous_school |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| previous_class |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| previous_percentage |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| previous_tc_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| counsellor_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| admission_approved_by |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| admission_approved_date |
date
|
|
|
|
| verification_status |
enum('Pending', 'Verified', 'Rejected')
|
utf8mb4_unicode_ci
|
|
|
| verification_remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| public_remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| internal_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|