| id |
int(11)
|
|
|
|
| interview_session_id |
int(11)
|
|
|
Browse foreign values
|
| applicant_id |
int(11)
|
|
|
Browse foreign values
|
| question_id |
int(11)
|
|
|
Browse foreign values
|
| question_shown_at |
datetime
|
|
|
|
| question_video_started_at |
datetime
|
|
|
|
| question_video_ended_at |
datetime
|
|
|
|
| countdown_started_at |
datetime
|
|
|
|
| recording_started_at |
datetime
|
|
|
|
| recording_ended_at |
datetime
|
|
|
|
| auto_started_recording |
tinyint(1)
|
|
|
|
| recording_stop_reason |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| upload_started_at |
datetime
|
|
|
|
| upload_completed_at |
datetime
|
|
|
|
| uploaded_at |
datetime
|
|
|
|
| is_early_submitted |
tinyint(1)
|
|
|
|
| confirmed_short_answer |
tinyint(1)
|
|
|
|
| answer_video_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| answer_video_original_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| answer_video_stored_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| answer_video_mime_type |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| answer_video_size |
int(11)
|
|
|
|
| answer_duration_seconds |
int(11)
|
|
|
|
| retake_count |
int(11)
|
|
|
|
| retake_request_id |
int(11)
|
|
|
|
| retake_attempt |
int(11)
|
|
|
|
| answer_version |
int(11)
|
|
|
|
| replaced_by_answer_id |
int(11)
|
|
|
|
| replaced_at |
datetime
|
|
|
|
| replaced_by_user_id |
int(11)
|
|
|
|
| video_file_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| video_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| video_size |
int(11)
|
|
|
|
| mime_type |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| duration_seconds |
int(11)
|
|
|
|
| attempt_no |
int(11)
|
|
|
|
| recorded_at |
datetime
|
|
|
|
| submitted_at |
datetime
|
|
|
|
| upload_status |
enum('uploaded', 'failed', 'processing')
|
utf8mb4_general_ci
|
|
|
| status |
enum('active', 'replaced', 'archived')
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|