public.events

#NameTypeNullableDefaultPK
1iduuidNOuuid_generate_v4()PK
2venue_iduuidNO
3title_entextNO
4title_pltextYES
5title_uktextYES
6description_entextYES
7description_pltextYES
8description_uktextYES
9datedateNO
10start_timetime without time zoneNO
11end_timetime without time zoneYES
12is_recurringbooleanNOfalse
13recurrence_ruletextYES
14image_urltextYES
15source_urltextYES
16created_attimestamp with time zoneNOnow()
17updated_attimestamp with time zoneNOnow()

Indexes

NameDefinitionUniquePrimarySize
events_pkeyCREATE UNIQUE INDEX events_pkey ON public.events USING btree (id)16 kB
idx_events_dateCREATE INDEX idx_events_date ON public.events USING btree (date)16 kB
idx_events_venueCREATE INDEX idx_events_venue ON public.events USING btree (venue_id)16 kB

Constraints

NameTypeDefinition
events_venue_id_fkeyFOREIGN KEYFOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE CASCADE
events_pkeyPRIMARY KEYPRIMARY KEY (id)