Skip to content

public.court_image

Description

Columns

Name Type Default Nullable Children Parents Comment
court_id uuid false public.court Unique identifier for the court.(DC2Type:uuid)
image_id uuid false public.image Unique identifier for the image record(DC2Type:uuid)

Constraints

Name Type Definition
court_image_pkey PRIMARY KEY PRIMARY KEY (court_id, image_id)
fk_30fcb307e3184009 FOREIGN KEY FOREIGN KEY (court_id) REFERENCES court(id) ON DELETE CASCADE
fk_30fcb3073da5256d FOREIGN KEY FOREIGN KEY (image_id) REFERENCES image(id) ON DELETE CASCADE

Indexes

Name Definition
court_image_pkey CREATE UNIQUE INDEX court_image_pkey ON public.court_image USING btree (court_id, image_id)
idx_30fcb3073da5256d CREATE INDEX idx_30fcb3073da5256d ON public.court_image USING btree (image_id)
idx_30fcb307e3184009 CREATE INDEX idx_30fcb307e3184009 ON public.court_image USING btree (court_id)

Relations

er

Generated by tbls