public.club_event¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.event_registration		(DC2Type:uuid)
contentful_id	varchar(64)		false
is_active	boolean	false	false
club_id	uuid		false		public.club	(DC2Type:uuid)
template_id	uuid		false		public.event_template	(DC2Type:uuid)
event_period_starts_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
event_period_ends_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
event_period_duration_in_seconds	integer		false
price_per_person_amount	bigint		false
price_per_person_currency	character(3)		false			(DC2Type:currency)
stripe_price_id	varchar(64)	NULL::character varying	true
status	varchar(255)	'OPEN_FOR_REGISTRATION'::character varying	false
max_confirmed_registrations	integer	10	false
registration_opens_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
description	text		true
persons_per_team	integer	1	false
type	varchar(255)	NULL::character varying	false
is_registrations_hidden	boolean	false	false
registration_closes_at	timestamp(0) with time zone	NULL::timestamp without time zone	true			(DC2Type:datetimetz_immutable)
free_cancellation_strategy	varchar(255)	'UNTIL_24H_BEFORE_EVENT'::character varying	false
updated_by_id	uuid		true		public.user	(DC2Type:uuid)
cancellation_reason	varchar(255)	NULL::character varying	true
updated_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
sport_id	uuid		false		public.sport	(DC2Type:uuid)

Name	Type	Definition
fk_9bc0201561190a32	FOREIGN KEY	FOREIGN KEY (club_id) REFERENCES club(id)
fk_9bc02015896dbbde	FOREIGN KEY	FOREIGN KEY (updated_by_id) REFERENCES "user"(id) ON DELETE SET NULL
fk_9bc02015ac78bcf8	FOREIGN KEY	FOREIGN KEY (sport_id) REFERENCES sport(id)
fk_9bc020155da0fb8	FOREIGN KEY	FOREIGN KEY (template_id) REFERENCES event_template(id)
club_event_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
club_event_pkey	CREATE UNIQUE INDEX club_event_pkey ON public.club_event USING btree (id)
uniq_9bc02015d756ce8c	CREATE UNIQUE INDEX uniq_9bc02015d756ce8c ON public.club_event USING btree (contentful_id)
idx_9bc0201561190a32	CREATE INDEX idx_9bc0201561190a32 ON public.club_event USING btree (club_id)
idx_9bc020155da0fb8	CREATE INDEX idx_9bc020155da0fb8 ON public.club_event USING btree (template_id)
uniq_9bc020158b531bd4	CREATE UNIQUE INDEX uniq_9bc020158b531bd4 ON public.club_event USING btree (stripe_price_id)
idx_9bc02015896dbbde	CREATE INDEX idx_9bc02015896dbbde ON public.club_event USING btree (updated_by_id)
idx_9bc02015ac78bcf8	CREATE INDEX idx_9bc02015ac78bcf8 ON public.club_event USING btree (sport_id)

Generated by tbls