results


Description

Attempts of a group (team or user) to solve a task once or several times with different parameters with the task allows it.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
participant_id BIGINT 19 null
answers.participant_id fk_answers_participant_id_attempt_id_item_id_results C
results_propagate_internal.participant_id fk_results_propagate_internal_to_results C
attempts.participant_id fk_results_participant_id_attempt_id_attempts_participant_id_id C
attempt_id BIGINT 19 0
answers.attempt_id fk_answers_participant_id_attempt_id_item_id_results C
results_propagate_internal.attempt_id fk_results_propagate_internal_to_results C
attempts.id fk_results_participant_id_attempt_id_attempts_participant_id_id C
item_id BIGINT 19 null
answers.item_id fk_answers_participant_id_attempt_id_item_id_results C
results_propagate_internal.item_id fk_results_propagate_internal_to_results C
items.id fk_results_item_id_items_id C
score_computed FLOAT 12 0

Score computed from the best answer or by propagation, with score_edit_rule applied
score_edit_rule enum('set', 'diff') 4 √ null

Whether the edit value replaces and adds up to the score of the best answer
score_edit_value FLOAT 12 √ null

Score which overrides or adds up (depending on score_edit_rule) to the score obtained from best answer or propagation
score_edit_comment VARCHAR 200 √ null

Explanation of the value set in score_edit_value
submissions INT 10 0

Number of submissions. Only for tasks, not propagated
tasks_tried INT 10 0

Number of tasks which have been attempted among this item's descendants (at least one submission), within this attempt
started BIT 1 null

Auto-generated from started_at
validated BIT 1 null

Auto-generated from validated_at
tasks_with_help INT 10 0

Number of this item's descendants tasks within this attempts for which the user asked for hints (or help on the forum - not implemented)
hints_requested MEDIUMTEXT 16777215 √ null

JSON array of the hints that have been requested for this attempt
hints_cached INT 10 0

Number of hints which have been requested for this attempt
started_at DATETIME 19 √ null

Time at which the attempt was manually created or was first marked as started (should be when it is first visited). Not propagated
validated_at DATETIME 19 √ null

Submission time of the first answer that made the attempt validated
latest_activity_at DATETIME 19 CURRENT_TIMESTAMP

Time of the latest activity (attempt creation, submission, hint request) of a user on this attempt or its children
score_obtained_at DATETIME 19 √ null

Submission time of the first answer which led to the best score
latest_submission_at DATETIME 19 √ null

Time of the latest submission. Only for tasks, not propagated
latest_hint_at DATETIME 19 √ null

Time of the last request for a hint. Only for tasks, not propagated
help_requested BIT 1 0

Whether the participant is requesting help on the item in this attempt
recomputing_state enum('recomputing', 'modified', 'unchanged') 11 unchanged

State of the result, used during recomputing

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc participant_id + attempt_id + item_id
item_id Performance Asc item_id
item_id_participant_id_started_at_desc_attempt_id_desc Performance Asc/Asc/Desc/Desc item_id + participant_id + started_at + attempt_id
item_id_participant_id_validated_at_desc_attempt_id_desc Performance Asc/Asc/Desc/Desc item_id + participant_id + validated_at + attempt_id
participant_id_item_id Performance Asc/Asc participant_id + item_id
participant_id_item_id_latest_activity_at_desc Performance Asc/Asc/Desc participant_id + item_id + latest_activity_at
participant_id_item_id_score_desc_score_obtained_at Performance Asc/Asc/Desc/Asc participant_id + item_id + score_computed + score_obtained_at
participant_id_item_id_started_started_at Performance Asc/Asc/Asc/Asc participant_id + item_id + started + started_at
participant_id_item_id_validated_validated_at Performance Asc/Asc/Asc/Asc participant_id + item_id + validated + validated_at
started_at_desc_item_id_participant_id_attempt_id_desc Performance Desc/Asc/Asc/Desc started_at + item_id + participant_id + attempt_id
validated_at_desc_item_id_participant_id_attempt_id_desc Performance Desc/Asc/Asc/Desc validated_at + item_id + participant_id + attempt_id

Relationships

Close relationships within degrees of separation