| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| enquiry_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| enquiry_date |
date
|
|
|
|
| source |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| campaign_name |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| student_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| gender |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| dob |
date
|
|
|
|
| age |
varchar(30)
|
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
|
|
|
| parent_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| father_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mother_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| guardian_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mobile_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| alternate_mobile_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| whatsapp_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
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
|
|
|
| previous_school |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| previous_class |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('Low', 'Medium', 'High', 'Hot')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('New', 'Contacted', 'Follow Up', 'Visited', 'Application Given', 'Application Submitted', 'Selected', 'Rejected', 'Cancelled', 'Converted')
|
utf8mb4_unicode_ci
|
|
|
| assigned_to |
int(10)
|
|
|
|
| next_followup_date |
date
|
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| converted_application_id |
int(10)
|
|
|
|
| converted_student_id |
int(10)
|
|
|
|
| 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
|
|
|
|