public.image¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.club public.club_image public.coach public.court_image public.event_template | Unique identifier for the image record(DC2Type:uuid) | ||
| type | varchar(255) | false | Type of image (INTERNAL or PUBLIC) | |||
| path | varchar(255) | NULL::character varying | true | File system path to the image (for internal images) | ||
| url | varchar(255) | NULL::character varying | true | Public URL to access the image | ||
| sort_index | integer | 0 | false | Display order for sorting images |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| image_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| image_pkey | CREATE UNIQUE INDEX image_pkey ON public.image USING btree (id) |
Relations¶
Generated by tbls