public.match_series¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.game		(DC2Type:uuid)
court_id	uuid		false		public.court	(DC2Type:uuid)
owner_id	uuid		false		public.user	(DC2Type:uuid)
created_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
status	varchar(255)		false
payment_plan	varchar(255)		false
match_duration_in_seconds	integer		false
type	varchar(255)		false
weekday	varchar(255)		false
note	varchar(255)	NULL::character varying	true
starts_at	time(0) without time zone		false			(DC2Type:time_immutable)
discount_percentage	integer		false
club_id	uuid		false		public.club	(DC2Type:uuid)
discount_id	uuid		true		public.discount	(DC2Type:uuid)
activated_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
terminated_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)

Name	Type	Definition
fk_9b7ff82c61190a32	FOREIGN KEY	FOREIGN KEY (club_id) REFERENCES club(id)
fk_9b7ff82ce3184009	FOREIGN KEY	FOREIGN KEY (court_id) REFERENCES court(id)
fk_9b7ff82c7e3c61f9	FOREIGN KEY	FOREIGN KEY (owner_id) REFERENCES "user"(id)
fk_9b7ff82c4c7c611f	FOREIGN KEY	FOREIGN KEY (discount_id) REFERENCES discount(id)
match_series_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
match_series_pkey	CREATE UNIQUE INDEX match_series_pkey ON public.match_series USING btree (id)
idx_9b7ff82ce3184009	CREATE INDEX idx_9b7ff82ce3184009 ON public.match_series USING btree (court_id)
idx_9b7ff82c7e3c61f9	CREATE INDEX idx_9b7ff82c7e3c61f9 ON public.match_series USING btree (owner_id)
idx_9b7ff82c61190a32	CREATE INDEX idx_9b7ff82c61190a32 ON public.match_series USING btree (club_id)
uniq_9b7ff82c4c7c611f	CREATE UNIQUE INDEX uniq_9b7ff82c4c7c611f ON public.match_series USING btree (discount_id)

Generated by tbls