| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| job_id |
int(10)
|
|
|
|
| applicant_name |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| applicant_code |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| mobile_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| gender |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| qualification |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| experience_years |
decimal(6,2)
|
|
|
|
| current_company |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| current_ctc |
decimal(12,2)
|
|
|
|
| expected_ctc |
decimal(12,2)
|
|
|
|
| notice_period |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| source_type |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| referred_by |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| resume_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| cover_note |
text
|
utf8mb4_unicode_ci
|
|
|
| applicant_stage |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| applicant_status |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| ai_score |
decimal(6,2)
|
|
|
|
| ai_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| applied_date |
date
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| 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
|
|
|
|
