|
id
|
int(11)
|
|
|
|
|
position_id
|
int(11)
|
|
|
|
|
company
|
enum
|
-- |
|
Shared
|
|
question_text
|
text
|
|
|
|
|
question_type
|
varchar(80)
|
|
|
Behavioral question
|
|
question_mode
|
enum
|
-- |
|
text
|
|
question_video_path
|
varchar(255)
|
|
|
|
|
question_video_original_filename
|
varchar(255)
|
|
|
|
|
question_video_stored_filename
|
varchar(255)
|
|
|
|
|
question_video_mime_type
|
varchar(120)
|
|
|
|
|
question_video_size
|
int(11)
|
|
|
0
|
|
question_video_duration_seconds
|
int(11)
|
|
|
|
|
show_text_overlay
|
tinyint(1)
|
|
|
0
|
|
text_overlay_position
|
enum
|
-- |
|
bottom
|
|
answer_time_limit_seconds
|
int(11)
|
|
|
|
|
allow_replay
|
tinyint(1)
|
|
|
1
|
|
max_replay_count
|
int(11)
|
|
|
2
|
|
require_full_watch_before_answer
|
tinyint(1)
|
|
|
1
|
|
allow_answer_retake
|
tinyint(1)
|
|
|
1
|
|
max_answer_retake_count
|
int(11)
|
|
|
1
|
|
time_limit_seconds
|
int(11)
|
|
|
120
|
|
sort_order
|
int(11)
|
|
|
0
|
|
is_required
|
tinyint(1)
|
|
|
1
|
|
status
|
enum
|
-- |
|
active
|
|
created_by
|
int(11)
|
|
|
|
|
updated_by
|
int(11)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|