Index

public.exercises

Description

Exercise is an collection of exercise tasks. The exercise itself does not contain any information on what kind of activities it contains – that information lives inside the tasks. This enables us for example to combine different exercise types or to provide different assignments to different students.

Columns

Name Type Default Nullable Children Parents Comment
chapter_id uuid true public.chapters (Redundant) Chapter in which the exercise belongs to.
copied_from uuid true public.exercises The original exercises record of a copy.
course_id uuid true public.courses Course where this exercise belongs to. Exercises are related to courses and not to course instances because if a course instance wants to have a different exercise from other course instances, the teacher is supposed to clone the course to create a new one.
created_at timestamp with time zone now() false Timestamp when the record was created
deadline timestamp with time zone true Overrides the deadline from the chapter. Should be null if we want to use the same deadline as in the chapter.
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
exam_id uuid true public.exams The exam the exercise is associated with.
exercise_language_group_id uuid true public.exercise_language_groups If the exercise is related to a course, this can be used to find this exercise in other languages. If two exercises share the same id, they are the same exercise but in different languages. For exercises not related to a course, like exam exercises, this is always null.
id uuid uuid_generate_v4() false public.exercise_reset_logs public.exercise_slide_submissions public.exercise_slides public.exercise_task_gradings public.exercises public.offered_answers_to_peer_review_temporary public.peer_or_self_review_configs public.peer_or_self_review_submissions public.peer_review_queue_entries public.user_exercise_states A unique, stable identifier for the record.
limit_number_of_tries boolean false false Whether the number of attempts the user is allowed to submit an exercise slide is limited. If true, the actual limit is defined by max_tries_per_slide. If null, the limit is unlimited.
max_tries_per_slide integer true The maximum number of attempts the user is allowed submit the exercise for each slide. Enforced only if limit_number_of_tries is true. If limit_number_of_tries is false, this column just stores what the teacher has previously typed in the exercise editor.
name varchar(255) false A human readable name of the exercise.
needs_peer_review boolean false false Does this exercise need to be peer reviewed before it can be marked as complete. The corresponding peer review can be found from the peer reviews table.
needs_self_review boolean false false If true, students are required to review their own submissions before getting any points.
order_number integer 0 false Used for sorting the exercises within a chapter.
page_id uuid false public.pages Page where this exercise can be found on.
score_maximum integer 1 false Maximum number of points that can be obtained from this exercise.
teacher_reviews_answer_after_locking boolean true false When true (default), answers go to manual review when chapter is locked.
When false, exercises with automated grading receive points immediately and lock without teacher review.
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.
use_course_default_peer_or_self_review_config boolean true false Shows if exercise uses course’s default peer review config. Default peer review config is needed to exists for this to work. Default peer review config is shared among all course’s exercises that has this set to true

Constraints

Name Type Definition Comment
check_exercise_language_group_id_defined CHECK CHECK (((course_id IS NULL) OR ((course_id IS NOT NULL) AND (exercise_language_group_id IS NOT NULL))))
course_or_exam_id_set CHECK CHECK (((course_id IS NULL) <> (exam_id IS NULL))) An exercise must be associated with either a course or an exam.
exercises_chapter_id_fkey FOREIGN KEY FOREIGN KEY (chapter_id) REFERENCES chapters(id)
exercises_copied_from_fkey FOREIGN KEY FOREIGN KEY (copied_from) REFERENCES exercises(id)
exercises_course_id_fkey FOREIGN KEY FOREIGN KEY (course_id) REFERENCES courses(id)
exercises_created_at_not_null n NOT NULL created_at
exercises_exam_id_fkey FOREIGN KEY FOREIGN KEY (exam_id) REFERENCES exams(id)
exercises_exercise_language_group_id_fkey FOREIGN KEY FOREIGN KEY (exercise_language_group_id) REFERENCES exercise_language_groups(id)
exercises_id_not_null n NOT NULL id
exercises_limit_number_of_tries_not_null n NOT NULL limit_number_of_tries
exercises_name_not_null n NOT NULL name
exercises_needs_peer_review_not_null n NOT NULL needs_peer_review
exercises_needs_self_review_not_null n NOT NULL needs_self_review
exercises_order_number_not_null n NOT NULL order_number
exercises_page_id_fkey FOREIGN KEY FOREIGN KEY (page_id) REFERENCES pages(id)
exercises_page_id_not_null n NOT NULL page_id
exercises_pkey PRIMARY KEY PRIMARY KEY (id)
exercises_score_maximum_not_null n NOT NULL score_maximum
exercises_teacher_reviews_answer_after_locking_not_null n NOT NULL teacher_reviews_answer_after_locking
exercises_updated_at_not_null n NOT NULL updated_at
exercises_use_course_default_peer_review_config_not_null n NOT NULL use_course_default_peer_or_self_review_config

Indexes

Name Definition
exercises_chapter_id_idx CREATE INDEX exercises_chapter_id_idx ON public.exercises USING btree (chapter_id)
exercises_course_id_idx CREATE INDEX exercises_course_id_idx ON public.exercises USING btree (course_id)
exercises_pkey CREATE UNIQUE INDEX exercises_pkey ON public.exercises USING btree (id)

Triggers

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

Relations

er

Generated by tbls