|
id
|
int(11)
|
|
|
|
|
reference_type
|
varchar(30)
|
|
|
Enquiry
|
|
enquiry_id
|
int(11)
|
|
|
0
|
|
application_id
|
int(11)
|
|
|
0
|
|
reference_no
|
varchar(50)
|
|
|
|
|
student_name
|
varchar(150)
|
|
|
|
|
class_id
|
int(11)
|
|
|
0
|
|
class_name
|
varchar(100)
|
|
|
|
|
contact_person
|
varchar(150)
|
|
|
|
|
contact_no
|
varchar(20)
|
|
|
|
|
followup_date
|
date
|
|
|
|
|
followup_time
|
time
|
|
|
|
|
followup_type
|
varchar(30)
|
|
|
Call
|
|
followup_status
|
varchar(50)
|
|
|
Open
|
|
next_followup_date
|
date
|
|
|
|
|
next_followup_time
|
time
|
|
|
|
|
assigned_to
|
int(11)
|
|
|
0
|
|
remarks
|
text
|
|
|
|
|
next_action
|
text
|
|
|
|
|
company_id
|
int(11)
|
|
|
1
|
|
branch_id
|
int(11)
|
|
|
1
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_by
|
int(11)
|
|
|
0
|
|
updated_by
|
int(11)
|
|
|
0
|
|
deleted_by
|
int(11)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
|
deleted_at
|
datetime
|
|
|
|