An exam is a special set of exercises with a common deadline.
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. | |||
ends_at | timestamp with time zone | true | The timestamp after which students can no longer work on the exam. | |||
grade_manually | boolean | false | false | True if the exam is graded manually, false if automatically | ||
id | uuid | uuid_generate_v4() | false | public.course_exams public.ended_processed_exams public.exam_enrollments public.exercise_repositories public.exercise_slide_submissions public.exercise_task_gradings public.exercises public.feedback public.page_visit_datum public.page_visit_datum_summary_by_courses public.page_visit_datum_summary_by_courses_countries public.page_visit_datum_summary_by_courses_device_types public.page_visit_datum_summary_by_pages public.pages public.roles public.user_course_exercise_service_variables public.user_exercise_states | A unique, stable identifier for the record. | |
instructions | jsonb | ‘[]’::jsonb | false | Instructions written in the Gutenberg Editor | ||
language | varchar(15) | true | ||||
minimum_points_treshold | integer | false | The minimum amount of points from the exam for student to pass it. | |||
name | varchar(255) | false | A name for the exam to differentiate it from other exams. | |||
organization_id | uuid | false | public.organizations | |||
starts_at | timestamp with time zone | true | The timestamp after which the exam can be started. | |||
time_minutes | integer | false | The duration the exam stays open for the student after they have started it. If the exam ends before the timer runs out (by ends_at), the student’s time is cut short. | |||
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. |
Name | Type | Definition |
---|---|---|
exams_created_at_not_null | n | NOT NULL created_at |
exams_grade_manually_not_null | n | NOT NULL grade_manually |
exams_id_not_null | n | NOT NULL id |
exams_instructions_not_null | n | NOT NULL instructions |
exams_language_check | CHECK | CHECK (((language)::text ~ ‘1{2,3}(-[A-Z][a-z]{3})?-[A-Z]{2}$’::text)) |
exams_minimum_points_treshold_not_null | n | NOT NULL minimum_points_treshold |
exams_name_check | CHECK | CHECK ((TRIM(BOTH FROM name) <> ’’::text)) |
exams_name_not_null | n | NOT NULL name |
exams_organization_id_fkey | FOREIGN KEY | FOREIGN KEY (organization_id) REFERENCES organizations(id) |
exams_organization_id_not_null | n | NOT NULL organization_id |
exams_pkey | PRIMARY KEY | PRIMARY KEY (id) |
exams_time_minutes_check | CHECK | CHECK ((time_minutes > 0)) |
exams_time_minutes_not_null | n | NOT NULL time_minutes |
exams_updated_at_not_null | n | NOT NULL updated_at |
Name | Definition |
---|---|
exams_pkey | CREATE UNIQUE INDEX exams_pkey ON public.exams USING btree (id) |
Name | Definition |
---|---|
set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.exams FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls
a-z↩︎