|
id
|
bigint(20) unsigned
|
|
|
|
|
attempt_id
|
bigint(20) unsigned
|
|
|
|
|
test_id
|
bigint(20) unsigned
|
|
|
|
|
test_question_id
|
bigint(20) unsigned
|
|
|
|
|
section_id
|
bigint(20) unsigned
|
|
|
|
|
question_id
|
bigint(20) unsigned
|
|
|
|
|
question_version_id
|
bigint(20) unsigned
|
|
|
|
|
attempt_question_number
|
int(10) unsigned
|
|
|
|
|
section_question_number
|
int(10) unsigned
|
|
|
0
|
|
option_order_json
|
longtext
|
|
|
|
|
positive_marks
|
decimal(8,2)
|
|
|
4.00
|
|
negative_marks
|
decimal(8,2)
|
|
|
0.00
|
|
question_state
|
varchar(40)
|
|
|
NOT_VISITED
|
|
is_marked_for_review
|
tinyint(1)
|
|
|
0
|
|
first_viewed_at
|
datetime
|
|
|
|
|
last_viewed_at
|
datetime
|
|
|
|
|
visit_count
|
int(10) unsigned
|
|
|
0
|
|
time_spent_seconds
|
int(10) unsigned
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|