Index

public.regradings

Description

A collection of submissions that will be graded again in the background. Created either by request from teachers or when we have edited exercise task specifications.

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone now() false Timestamp when the record was created
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
error_message text true
id uuid uuid_generate_v4() false public.exercise_task_regrading_submissions A unique, stable identifier for the record.
regrading_completed_at timestamp with time zone true When we got all results from all the grading tasks from exercise services.
regrading_started_at timestamp with time zone true When we started to post the grading tasks in this regrading to exercise services
total_grading_progress grading_progress ‘not-ready’::grading_progress false What is the overall status of the regrading operation. See https://rage.github.io/secret-project-331/headless_lms_actix/models/exercises/enum.GradingProgress.html.
updated_at timestamp with time zone now() false Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.
user_id uuid true public.users The user that created the regrading. If NULL, the decision was added automatically without the involment of a user.
user_points_update_strategy user_points_update_strategy false When we get results from a grading, how should we update the user’s points. See https://rage.github.io/secret-project-331/headless_lms_actix/models/gradings/enum.UserPointsUpdateStrategy.html.

Constraints

Name Type Definition
regradings_created_at_not_null n NOT NULL created_at
regradings_id_not_null n NOT NULL id
regradings_pkey PRIMARY KEY PRIMARY KEY (id)
regradings_total_grading_progress_not_null n NOT NULL total_grading_progress
regradings_updated_at_not_null n NOT NULL updated_at
regradings_user_id_fkey FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id)
regradings_user_points_update_strategy_not_null n NOT NULL user_points_update_strategy

Indexes

Name Definition
regradings_pkey CREATE UNIQUE INDEX regradings_pkey ON public.regradings USING btree (id)

Triggers

Name Definition
set_timestamp CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.regradings FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls