public.questions_single_choice_choices¶

Description¶

Name	Type	Default	Nullable	Parents
id	bigint	nextval('questions_single_choice_choices_id_seq'::regclass)	false
single_choice_id	bigint		false	public.questions_single_choice
choice_index	integer		false
text	text		false
is_correct	boolean	false	false

Name	Type	Definition
questions_single_choice_choices_choice_index_not_null	n	NOT NULL choice_index
questions_single_choice_choices_id_not_null	n	NOT NULL id
questions_single_choice_choices_is_correct_not_null	n	NOT NULL is_correct
questions_single_choice_choices_single_choice_id_not_null	n	NOT NULL single_choice_id
questions_single_choice_choices_text_not_null	n	NOT NULL text
questions_single_choice_choices_single_choice_id_fkey	FOREIGN KEY	FOREIGN KEY (single_choice_id) REFERENCES questions_single_choice(id) ON DELETE CASCADE
questions_single_choice_choices_pkey	PRIMARY KEY	PRIMARY KEY (id)
questions_single_choice_choic_single_choice_id_choice_index_key	UNIQUE	UNIQUE (single_choice_id, choice_index)

Name	Definition
questions_single_choice_choices_pkey	CREATE UNIQUE INDEX questions_single_choice_choices_pkey ON public.questions_single_choice_choices USING btree (id)
questions_single_choice_choic_single_choice_id_choice_index_key	CREATE UNIQUE INDEX questions_single_choice_choic_single_choice_id_choice_index_key ON public.questions_single_choice_choices USING btree (single_choice_id, choice_index)
idx_questions_single_choice_choices_single_choice_id	CREATE INDEX idx_questions_single_choice_choices_single_choice_id ON public.questions_single_choice_choices USING btree (single_choice_id)

Generated by tbls