Table for queueing up for peer reviews. Once user has given enough peer reviews, they will get added to this queue where additional peer reviews given will increase their own priority of receiving peer reviews.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| course_id | uuid | false | public.courses | |||
| created_at | timestamp with time zone | now() | false | Timestamp when the record was created. In this table this is the moment when the user has given enough peer reviews | ||
| deleted_at | timestamp with time zone | true | Timestamp when the record was deleted. If null, the record is not deleted. | |||
| exercise_id | uuid | false | public.exercises | The exercise that is being peer reviewed. | ||
| id | uuid | uuid_generate_v4() | false | A unique, stable identifier for the record. | ||
| peer_review_priority | integer | 0 | false | How fast this user should receive peer reviews. Usually based on the amount of peer reviews given. | ||
| received_enough_peer_reviews | boolean | false | false | Whether or not this queue entry has already received enough peer reviews. Simply a boolean for performance reasons. | ||
| receiving_peer_reviews_exercise_slide_submission_id | uuid | false | public.exercise_slide_submissions | The users submission that should receive peer reviews. | ||
| removed_from_queue_for_unusual_reason | boolean | false | false | If true, the answer won’t be given to others to be peer reviewed. This will not be set to true when user receives enough reviews and concludes the peer review process. This will be set to true for example when teacher grades the answer manually and peer reviews are no longer true or when an anwer would be removed from the peer review queue due to it being spam. | ||
| 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 | false | public.users | The user who is in queue. |
| Name | Type | Definition |
|---|---|---|
| peer_review_queue_entries_course_id_fkey | FOREIGN KEY | FOREIGN KEY (course_id) REFERENCES courses(id) |
| peer_review_queue_entries_course_id_not_null | n | NOT NULL course_id |
| peer_review_queue_entries_created_at_not_null | n | NOT NULL created_at |
| peer_review_queue_entries_exercise_id_fkey | FOREIGN KEY | FOREIGN KEY (exercise_id) REFERENCES exercises(id) |
| peer_review_queue_entries_exercise_id_not_null | n | NOT NULL exercise_id |
| peer_review_queue_entries_id_not_null | n | NOT NULL id |
| peer_review_queue_entries_peer_review_priority_not_null | n | NOT NULL peer_review_priority |
| peer_review_queue_entries_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| peer_review_queue_entries_received_enough_peer_reviews_not_null | n | NOT NULL received_enough_peer_reviews |
| peer_review_queue_entries_receiving_peer_reviews_exerc_not_null | n | NOT NULL receiving_peer_reviews_exercise_slide_submission_id |
| peer_review_queue_entries_receiving_peer_reviews_exercise__fkey | FOREIGN KEY | FOREIGN KEY (receiving_peer_reviews_exercise_slide_submission_id) REFERENCES exercise_slide_submissions(id) |
| peer_review_queue_entries_removed_from_queue_for_unusu_not_null | n | NOT NULL removed_from_queue_for_unusual_reason |
| peer_review_queue_entries_unique_user_exercise_course | UNIQUE | UNIQUE NULLS NOT DISTINCT (user_id, exercise_id, course_id, deleted_at) |
| peer_review_queue_entries_updated_at_not_null | n | NOT NULL updated_at |
| peer_review_queue_entries_user_id_fkey | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) |
| peer_review_queue_entries_user_id_not_null | n | NOT NULL user_id |
| Name | Definition |
|---|---|
| peer_review_priority | CREATE INDEX peer_review_priority ON public.peer_review_queue_entries USING btree (peer_review_priority) |
| peer_review_queue_entries_exercise_id_created_at_idx | CREATE INDEX peer_review_queue_entries_exercise_id_created_at_idx ON public.peer_review_queue_entries USING btree (exercise_id, created_at) |
| peer_review_queue_entries_pkey | CREATE UNIQUE INDEX peer_review_queue_entries_pkey ON public.peer_review_queue_entries USING btree (id) |
| peer_review_queue_entries_receiving_peer_reviews_exercise_s_idx | CREATE INDEX peer_review_queue_entries_receiving_peer_reviews_exercise_s_idx ON public.peer_review_queue_entries USING btree (receiving_peer_reviews_exercise_slide_submission_id) |
| peer_review_queue_entries_unique_user_exercise_course | CREATE UNIQUE INDEX peer_review_queue_entries_unique_user_exercise_course ON public.peer_review_queue_entries USING btree (user_id, exercise_id, course_id, deleted_at) NULLS NOT DISTINCT |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.peer_review_queue_entries FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls