| id |
int(11)
|
|
|
|
| applicant_code |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| middle_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| suffix |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| birthdate |
date
|
|
|
|
| gender |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| civil_status |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| contact_number |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| position_id |
int(11)
|
|
|
|
| preferred_company |
enum('Top1Movers', 'Bambs Trucking Corp.', 'Either company')
|
utf8mb4_general_ci
|
|
|
| expected_salary |
decimal(12,2)
|
|
|
|
| availability_date |
date
|
|
|
|
| employment_history |
text
|
utf8mb4_general_ci
|
|
|
| educational_background |
text
|
utf8mb4_general_ci
|
|
|
| skills |
text
|
utf8mb4_general_ci
|
|
|
| certifications |
text
|
utf8mb4_general_ci
|
|
|
| driver_license_details |
text
|
utf8mb4_general_ci
|
|
|
| work_experience |
text
|
utf8mb4_general_ci
|
|
|
| referral_source |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| remarks |
text
|
utf8mb4_general_ci
|
|
|
| status |
enum('draft', 'submitted', 'under_review', 'for_online_interview', 'interview_link_sent', 'online_interview_in_progress', 'online_interview_completed', 'for_hr_review', 'shortlisted', 'for_final_interview', 'failed', 'hired', 'cancelled', 'converted_to_employee')
|
utf8mb4_general_ci
|
|
|
| consent_accepted |
tinyint(1)
|
|
|
|
| consent_accepted_at |
datetime
|
|
|
|
| consent_ip |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| consent_version |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| converted_employee_id |
int(11)
|
|
|
Browse foreign values
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|