public.course_specific_consent_form_questions

Description

Stores a custom research consent questions for a specific course

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
course_id	uuid		false		public.courses	The course for which the research consent form belongs to
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.
id	uuid	uuid_generate_v4()	false	public.course_specific_consent_form_answers
question	varchar(8192)		false			The question in the research consent form
research_consent_form_id	uuid		false		public.course_specific_research_consent_forms	The form for which the question belongs 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
course_specific_consent_form_ques_research_consent_form_id_fkey	FOREIGN KEY	FOREIGN KEY (research_consent_form_id) REFERENCES course_specific_research_consent_forms(id)
course_specific_consent_form_questions_course_id_fkey	FOREIGN KEY	FOREIGN KEY (course_id) REFERENCES courses(id)
course_specific_consent_form_questions_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
course_specific_consent_form_questions_pkey	CREATE UNIQUE INDEX course_specific_consent_form_questions_pkey ON public.course_specific_consent_form_questions USING btree (id)

Triggers

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

Relations

er

Generated by tbls