Index

public.rejected_exercise_task_submissions

Description

If an exercise task submission is rejected, the submission is stored here. Rejections happen usually when there is some bug in the exercise service. This data if used for diagnosing problems.

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone now() false Timestamp when the record was created.
data_json jsonb false The contents of the failed sumbission
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
id uuid uuid_generate_v4() false A unique, stable identifier for the record.
rejected_exercise_slide_submission_id uuid false public.rejected_exercise_slide_submissions The rejected exercise slide submission that this task submission is related to
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
rejected_exercise_task_submis_rejected_exercise_slide_subm_fkey FOREIGN KEY FOREIGN KEY (rejected_exercise_slide_submission_id) REFERENCES rejected_exercise_slide_submissions(id)
rejected_exercise_task_submissions_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
rejected_exercise_task_submissions_pkey CREATE UNIQUE INDEX rejected_exercise_task_submissions_pkey ON public.rejected_exercise_task_submissions USING btree (id)

Triggers

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

Relations

er

Generated by tbls