public.question_images¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| question_id | bigint | false | public.questions | |||
| image_id | bigint | false | public.images | |||
| order_index | integer | 0 | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| question_images_image_id_not_null | n | NOT NULL image_id |
| question_images_order_index_not_null | n | NOT NULL order_index |
| question_images_question_id_not_null | n | NOT NULL question_id |
| question_images_question_id_fkey | FOREIGN KEY | FOREIGN KEY (question_id) REFERENCES questions(id) ON DELETE CASCADE |
| question_images_image_id_fkey | FOREIGN KEY | FOREIGN KEY (image_id) REFERENCES images(id) ON DELETE CASCADE |
| question_images_pkey | PRIMARY KEY | PRIMARY KEY (question_id, image_id) |
| question_images_question_id_order_index_key | UNIQUE | UNIQUE (question_id, order_index) |
Indexes¶
| Name | Definition |
|---|---|
| question_images_pkey | CREATE UNIQUE INDEX question_images_pkey ON public.question_images USING btree (question_id, image_id) |
| question_images_question_id_order_index_key | CREATE UNIQUE INDEX question_images_question_id_order_index_key ON public.question_images USING btree (question_id, order_index) |
| idx_question_images_question_id | CREATE INDEX idx_question_images_question_id ON public.question_images USING btree (question_id) |
| idx_question_images_image_id | CREATE INDEX idx_question_images_image_id ON public.question_images USING btree (image_id) |
Relations¶
Generated by tbls