public.workbook_questions

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
workbook_id	bigint		false		public.workbooks
question_id	bigint		false		public.questions
order_index	integer	0	false

Constraints

Name	Type	Definition
workbook_questions_order_index_not_null	n	NOT NULL order_index
workbook_questions_question_id_not_null	n	NOT NULL question_id
workbook_questions_workbook_id_not_null	n	NOT NULL workbook_id
workbook_questions_question_id_fkey	FOREIGN KEY	FOREIGN KEY (question_id) REFERENCES questions(id) ON DELETE CASCADE
workbook_questions_workbook_id_fkey	FOREIGN KEY	FOREIGN KEY (workbook_id) REFERENCES workbooks(id) ON DELETE CASCADE
workbook_questions_pkey	PRIMARY KEY	PRIMARY KEY (workbook_id, question_id)

Indexes

Name	Definition
workbook_questions_pkey	CREATE UNIQUE INDEX workbook_questions_pkey ON public.workbook_questions USING btree (workbook_id, question_id)
idx_workbook_questions_workbook_id	CREATE INDEX idx_workbook_questions_workbook_id ON public.workbook_questions USING btree (workbook_id)
idx_workbook_questions_question_id	CREATE INDEX idx_workbook_questions_question_id ON public.workbook_questions USING btree (question_id)

Relations

---

Generated by tbls