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↩︎