public.questions_single_choice¶

Description¶

Name	Type	Default	Nullable	Children	Parents
id	bigint	nextval('questions_single_choice_id_seq'::regclass)	false	public.questions_single_choice_choices
question_id	bigint		false		public.questions
text	text		false
explanation	text		true
created_at	timestamp without time zone	CURRENT_TIMESTAMP	true
updated_at	timestamp without time zone	CURRENT_TIMESTAMP	true

Name	Type	Definition
questions_single_choice_id_not_null	n	NOT NULL id
questions_single_choice_question_id_not_null	n	NOT NULL question_id
questions_single_choice_text_not_null	n	NOT NULL text
questions_single_choice_question_id_fkey	FOREIGN KEY	FOREIGN KEY (question_id) REFERENCES questions(id) ON DELETE CASCADE
questions_single_choice_pkey	PRIMARY KEY	PRIMARY KEY (id)
questions_single_choice_question_id_key	UNIQUE	UNIQUE (question_id)

Name	Definition
questions_single_choice_pkey	CREATE UNIQUE INDEX questions_single_choice_pkey ON public.questions_single_choice USING btree (id)
questions_single_choice_question_id_key	CREATE UNIQUE INDEX questions_single_choice_question_id_key ON public.questions_single_choice USING btree (question_id)
idx_questions_single_choice_question_id	CREATE INDEX idx_questions_single_choice_question_id ON public.questions_single_choice USING btree (question_id)

Generated by tbls