Index

public.peer_or_self_review_configs

Description

Collection of settings and peer review questions that users have to answer to evaluate each others’ answers.

Columns

Name Type Default Nullable Children Parents Comment
accepting_threshold real 2.1 false The threshold on the average review received for “passing” a peer reviewed exercise. If points_are_all_or_nothing is true, this threshold tells whether to give full points or zero points. If points_are_all_or_nothing is false and peer_review_processing_strategy is automatically_grade_or_manual_review_by average all averages under this threshold will cause an answer to be sent to manual review. In all other cases, this column will be ignored. Peer review questions are on a scale from 1 to 5.
course_id uuid false public.courses Course that this peer review is a part of.
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.
exercise_id uuid true public.exercises Exercise that this peer review is for. There can be one peer review per course where this field is null, which then will be used as the default option for all peer reviewed exercises on that course.
id uuid uuid_generate_v4() false public.peer_or_self_review_questions public.peer_or_self_review_submissions A unique, stable identifier for the record.
manual_review_cutoff_in_days integer 21 false Number of days that needs to pass for the exercise submission to move to manual review
peer_reviews_to_give integer 3 false The number of peer reviews that the user must give before completing the exercise. Users must always give more peer reviews than receive, to make sure that there are enough peer reviews for each student.
peer_reviews_to_receive integer 2 false The number of peer reviews that the user must receive before completing the exercise.
points_are_all_or_nothing boolean true false True by default and recommended to keep it that way for most courses. If set to true, the student will always receive either full points or no points from the peer reviewed exercise. If set to false, the points will be weighted according to a weight in each peer review question.
processing_strategy peer_review_processing_strategy ‘automatically_grade_by_average’::peer_review_processing_strategy false Determines how we will treat the answer being peer reviewed once it has received enough reviews. Some variants depend on accepting threshold.
reset_answer_if_zero_points_from_review boolean false false If true, the users answer will be automatically reset when peer/self review final score is zero.
review_instructions jsonb true Content of additional instructions shown when self of peer review starts. The content is in an abstract format, the same as pages.content.
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.

Constraints

Name Type Definition
courses_have_only_one_default_peer_review UNIQUE UNIQUE NULLS NOT DISTINCT (course_id, exercise_id, deleted_at)
more_given_than_received_peer_reviews CHECK CHECK ((peer_reviews_to_give > peer_reviews_to_receive))
peer_or_self_review_configs_reset_answer_if_zero_point_not_null n NOT NULL reset_answer_if_zero_points_from_review
peer_review_configs_manual_review_cutoff_in_days_not_null n NOT NULL manual_review_cutoff_in_days
peer_review_configs_points_are_all_or_nothing_not_null n NOT NULL points_are_all_or_nothing
peer_reviews_accepting_strategy_not_null n NOT NULL processing_strategy
peer_reviews_accepting_threshold_not_null n NOT NULL accepting_threshold
peer_reviews_course_id_fkey FOREIGN KEY FOREIGN KEY (course_id) REFERENCES courses(id)
peer_reviews_course_id_not_null n NOT NULL course_id
peer_reviews_created_at_not_null n NOT NULL created_at
peer_reviews_exercise_id_fkey FOREIGN KEY FOREIGN KEY (exercise_id) REFERENCES exercises(id)
peer_reviews_id_not_null n NOT NULL id
peer_reviews_peer_reviews_to_give_not_null n NOT NULL peer_reviews_to_give
peer_reviews_peer_reviews_to_receive_not_null n NOT NULL peer_reviews_to_receive
peer_reviews_pkey PRIMARY KEY PRIMARY KEY (id)
peer_reviews_updated_at_not_null n NOT NULL updated_at

Indexes

Name Definition
courses_have_only_one_default_peer_review CREATE UNIQUE INDEX courses_have_only_one_default_peer_review ON public.peer_or_self_review_configs USING btree (course_id, exercise_id, deleted_at) NULLS NOT DISTINCT
peer_or_self_review_configs_exercise_id_idx CREATE INDEX peer_or_self_review_configs_exercise_id_idx ON public.peer_or_self_review_configs USING btree (exercise_id)
peer_reviews_pkey CREATE UNIQUE INDEX peer_reviews_pkey ON public.peer_or_self_review_configs USING btree (id)

Triggers

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

Relations

er

Generated by tbls