| id |
int(11)
|
|
|
|
| applicant_id |
int(11)
|
|
|
Browse foreign values
|
| position_id |
int(11)
|
|
|
|
| token |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| token_expires_at |
datetime
|
|
|
|
| status |
enum('pending', 'in_progress', 'completed', 'expired', 'cancelled')
|
utf8mb4_general_ci
|
|
|
| expires_at |
datetime
|
|
|
|
| allow_retake |
tinyint(1)
|
|
|
|
| retakes_allowed |
int(11)
|
|
|
|
| allow_preview |
tinyint(1)
|
|
|
|
| require_all_questions |
tinyint(1)
|
|
|
|
| consent_accepted |
tinyint(1)
|
|
|
|
| consent_accepted_at |
datetime
|
|
|
|
| consent_ip |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| consent_user_agent |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| applicant_agreed_interview_rules |
tinyint(1)
|
|
|
|
| rules_agreed_at |
datetime
|
|
|
|
| rules_agreed_ip |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| rules_agreed_user_agent |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| first_client_id |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| active_client_id |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| active_client_seen_at |
datetime
|
|
|
|
| last_device_info |
text
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| started_at |
datetime
|
|
|
|
| completed_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|