attempts


Description

Attempts of participants (team or user) to solve a subtree of items. An attempt may have several answers for a same item. Every participant has a default attempt.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
participant_id BIGINT 19 null
results.participant_id fk_results_participant_id_attempt_id_attempts_participant_id_id C
groups.id fk_attempts_participant_id_groups_id C
id BIGINT 19 null
results.attempt_id fk_results_participant_id_attempt_id_attempts_participant_id_id C

Identifier of this attempt for this participant, 0 is the default attempt for the participant, the next ones are sequentially assigned.
creator_id BIGINT 19 √ null
users.group_id fk_attempts_creator_id_users_group_id N

The user who created this attempt
parent_attempt_id BIGINT 19 √ null

The attempt from which this one was forked. NULL for the default attempt.
root_item_id BIGINT 19 √ null
items.id fk_attempts_root_item_id_items_id N

The item on which the attempt was created
created_at DATETIME 19 CURRENT_TIMESTAMP

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

Time at which the attempt was (typically manually) ended
allows_submissions_until DATETIME 19 9999-12-31 23:59:59

Time until which the participant can submit an answer on this attempt

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc participant_id + id
fk_attempts_creator_id_users_group_id Performance Asc creator_id
fk_attempts_root_item_id_items_id Performance Asc root_item_id
participant_id_parent_attempt_id_root_item_id Performance Asc/Asc/Asc participant_id + parent_attempt_id + root_item_id
participant_id_root_item_id Performance Asc/Asc participant_id + root_item_id

Relationships

Close relationships within degrees of separation