|
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)
|
|
|
0
|
|
recording_stop_reason
|
varchar(40)
|
|
|
|
|
upload_started_at
|
datetime
|
|
|
|
|
upload_completed_at
|
datetime
|
|
|
|
|
uploaded_at
|
datetime
|
|
|
|
|
is_early_submitted
|
tinyint(1)
|
|
|
0
|
|
confirmed_short_answer
|
tinyint(1)
|
|
|
0
|
|
answer_video_path
|
varchar(255)
|
|
|
|
|
answer_video_original_filename
|
varchar(255)
|
|
|
|
|
answer_video_stored_filename
|
varchar(255)
|
|
|
|
|
answer_video_mime_type
|
varchar(120)
|
|
|
|
|
answer_video_size
|
int(11)
|
|
|
0
|
|
answer_duration_seconds
|
int(11)
|
|
|
|
|
retake_count
|
int(11)
|
|
|
0
|
|
retake_request_id
|
int(11)
|
|
|
|
|
retake_attempt
|
int(11)
|
|
|
0
|
|
answer_version
|
int(11)
|
|
|
1
|
|
replaced_by_answer_id
|
int(11)
|
|
|
|
|
replaced_at
|
datetime
|
|
|
|
|
replaced_by_user_id
|
int(11)
|
|
|
|
|
video_file_path
|
varchar(255)
|
|
|
|
|
video_filename
|
varchar(255)
|
|
|
|
|
video_size
|
int(11)
|
|
|
0
|
|
mime_type
|
varchar(120)
|
|
|
|
|
duration_seconds
|
int(11)
|
|
|
|
|
attempt_no
|
int(11)
|
|
|
1
|
|
recorded_at
|
datetime
|
|
|
current_timestamp()
|
|
submitted_at
|
datetime
|
|
|
|
|
upload_status
|
enum
|
-- |
|
uploaded
|
|
status
|
enum
|
-- |
|
active
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|