public.court_blocker¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.court_blocker_court		Unique identifier for the court blocker.(DC2Type:uuid)
starts_at	timestamp(0) with time zone		false			Start date and time when the court blocking period begins.(DC2Type:datetimetz_immutable)
ends_at	timestamp(0) with time zone		false			End date and time when the court blocking period ends.(DC2Type:datetimetz_immutable)
title	varchar(255)		false			Descriptive title of the court blocking period (e.g., "Maintenance", "Tournament").
created_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			Timestamp when this court blocker was created.(DC2Type:datetimetz_immutable)
updated_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			Timestamp when this court blocker was last updated.(DC2Type:datetimetz_immutable)
note	text		true			Optional note providing additional context or details about the court blocking period.
created_by_id	uuid		true		public.user	User who created this court blocker.(DC2Type:uuid)
updated_by_id	uuid		true		public.user	User who last updated this court blocker.(DC2Type:uuid)

Name	Type	Definition
court_blocker_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_9e65a63896dbbde	FOREIGN KEY	FOREIGN KEY (updated_by_id) REFERENCES "user"(id)
fk_9e65a63b03a8386	FOREIGN KEY	FOREIGN KEY (created_by_id) REFERENCES "user"(id)

Name	Definition
court_blocker_pkey	CREATE UNIQUE INDEX court_blocker_pkey ON public.court_blocker USING btree (id)
idx_9e65a63b03a8386	CREATE INDEX idx_9e65a63b03a8386 ON public.court_blocker USING btree (created_by_id)
idx_9e65a63896dbbde	CREATE INDEX idx_9e65a63896dbbde ON public.court_blocker USING btree (updated_by_id)

Generated by tbls