answers


Description

All the submissions made by users on tasks, as well as saved answers and the current answer

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
gradings.answer_id fk_submissions_answer_id_answers_id C
participant_id BIGINT 19 null
results.participant_id fk_answers_participant_id_attempt_id_item_id_results C
attempt_id BIGINT 19 null
results.attempt_id fk_answers_participant_id_attempt_id_item_id_results C
item_id BIGINT 19 null
results.item_id fk_answers_participant_id_attempt_id_item_id_results C
author_id BIGINT 19 null
users.group_id fk_answers_author_id_users_group_id C
type enum('Submission', 'Saved', 'Current') 10 null

'Submission' for answers submitted for grading, 'Saved' for manual backups of answers, 'Current' for automatic snapshots of the latest answers (unique for a user on an attempt)
state MEDIUMTEXT 16777215 √ null

Saved state (sent by the task platform)
answer MEDIUMTEXT 16777215 √ null

Saved answer (sent by the task platform)
created_at DATETIME 19 null

Submission time
activity_type_int TINYINT 3 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
attempt_id Performance Asc attempt_id
created_at_d_item_id_participant_id_attempt_id_d_atype_d_id_a_t Performance Desc/Asc/Asc/Desc/Desc/Asc/Asc/Asc created_at + item_id + participant_id + attempt_id + activity_type_int + id + author_id + type
fk_answers_participant_id_attempt_id_item_id_results Performance Asc/Asc/Asc participant_id + attempt_id + item_id
type_created_at_desc_item_id_participant_id_attempt_id_desc Performance Asc/Desc/Asc/Asc/Desc type + created_at + item_id + participant_id + attempt_id
type_participant_id_item_id_created_at_desc_attempt_id_desc Performance Asc/Asc/Asc/Desc/Desc type + participant_id + item_id + created_at + attempt_id
user_id Performance Asc author_id

Relationships

Close relationships within degrees of separation