public.event_registration¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.cart public.refund public.event_term		Unique identifier of the event registration.(DC2Type:uuid)
event_id	uuid		false		public.club_event	Club event that this registration is for.(DC2Type:uuid)
created_at	timestamp(0) with time zone		false			Date and time when the event registration was created.(DC2Type:datetimetz_immutable)
status	varchar(255)	'WAITING_FOR_PAYMENT'::character varying	false			Current status: WAITING_FOR_PAYMENT, REGISTRATION_CONFIRMED, CANCELLED, or CALLED_OFF.
team_id	uuid		true		public.team	Unique identifier for the team.(DC2Type:uuid)
created_by_id	uuid		false		public.user	User who created this event registration.(DC2Type:uuid)
cancelled_by_id	uuid		true		public.user	User who cancelled this event registration.(DC2Type:uuid)
cancelled_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			Date and time when the event registration was cancelled.(DC2Type:datetimetz_immutable)

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)

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)

Generated by tbls