Skip to content

public.event_registration

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false public.cart public.refund public.event_term (DC2Type:uuid)
event_id uuid false public.club_event (DC2Type:uuid)
created_at timestamp(0) with time zone false (DC2Type:datetimetz_immutable)
status varchar(255) 'WAITING_FOR_PAYMENT'::character varying false
team_id uuid true public.team (DC2Type:uuid)
created_by_id uuid false public.user (DC2Type:uuid)
cancelled_by_id uuid true public.user (DC2Type:uuid)
cancelled_at timestamp(0) with time zone NULL::timestamp with time zone true (DC2Type:datetimetz_immutable)

Constraints

Name Type Definition
fk_8fbbad54187b2d12 FOREIGN KEY FOREIGN KEY (cancelled_by_id) REFERENCES "user"(id)
fk_8fbbad54b03a8386 FOREIGN KEY FOREIGN KEY (created_by_id) REFERENCES "user"(id)
fk_8fbbad5471f7e88b FOREIGN KEY FOREIGN KEY (event_id) REFERENCES club_event(id)
event_registration_pkey PRIMARY KEY PRIMARY KEY (id)
fk_8fbbad54296cd8ae FOREIGN KEY FOREIGN KEY (team_id) REFERENCES team(id)

Indexes

Name Definition
event_registration_pkey CREATE UNIQUE INDEX event_registration_pkey ON public.event_registration USING btree (id)
idx_8fbbad5471f7e88b CREATE INDEX idx_8fbbad5471f7e88b ON public.event_registration USING btree (event_id)
idx_8fbbad54296cd8ae CREATE INDEX idx_8fbbad54296cd8ae ON public.event_registration USING btree (team_id)
idx_8fbbad54b03a8386 CREATE INDEX idx_8fbbad54b03a8386 ON public.event_registration USING btree (created_by_id)
idx_8fbbad54187b2d12 CREATE INDEX idx_8fbbad54187b2d12 ON public.event_registration USING btree (cancelled_by_id)

Relations

er

Generated by tbls