results_propagate


Description

Used by the algorithm that computes results for items that have children and unlocks items if needed.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
participant_id BIGINT 19 null
results.participant_id fk_results_propagate_to_results C
attempt_id BIGINT 19 0
results.attempt_id fk_results_propagate_to_results C
item_id BIGINT 19 null
results.item_id fk_results_propagate_to_results C
state enum('to_be_propagated', 'to_be_recomputed', 'propagating', 'recomputing') 16 null

"to_be_propagated" means that ancestors should be recomputed

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc participant_id + attempt_id + item_id
state Performance Asc state

Relationships

Close relationships within degrees of separation