| id |
int(11)
|
|
|
|
| position_id |
int(11)
|
|
|
|
| company |
enum('Top1Movers', 'Bambs Trucking Corp.', 'Shared')
|
utf8mb4_general_ci
|
|
|
| question_text |
text
|
utf8mb4_general_ci
|
|
|
| question_type |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| question_mode |
enum('text', 'video', 'text_video')
|
utf8mb4_general_ci
|
|
|
| question_video_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| question_video_original_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| question_video_stored_filename |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| question_video_mime_type |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| question_video_size |
int(11)
|
|
|
|
| question_video_duration_seconds |
int(11)
|
|
|
|
| show_text_overlay |
tinyint(1)
|
|
|
|
| text_overlay_position |
enum('top', 'bottom')
|
utf8mb4_general_ci
|
|
|
| answer_time_limit_seconds |
int(11)
|
|
|
|
| allow_replay |
tinyint(1)
|
|
|
|
| max_replay_count |
int(11)
|
|
|
|
| require_full_watch_before_answer |
tinyint(1)
|
|
|
|
| allow_answer_retake |
tinyint(1)
|
|
|
|
| max_answer_retake_count |
int(11)
|
|
|
|
| time_limit_seconds |
int(11)
|
|
|
|
| sort_order |
int(11)
|
|
|
|
| is_required |
tinyint(1)
|
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|