| id |
int(11)
|
|
|
|
| interview_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| application_id |
int(11)
|
|
|
|
| application_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| enquiry_id |
int(11)
|
|
|
|
| enquiry_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| student_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| class_id |
int(11)
|
|
|
|
| class_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| interview_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| scheduled_date |
date
|
|
|
|
| scheduled_time |
time
|
|
|
|
| venue |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| conducted_by |
int(11)
|
|
|
|
| conducted_by_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| marks_obtained |
decimal(10,2)
|
|
|
|
| max_marks |
decimal(10,2)
|
|
|
|
| grade |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| result_status |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| recommendation |
text
|
utf8mb4_unicode_ci
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| deleted_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|