public.coach¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.coach_absence public.coach_club public.match_coach public.training_schedule		Unique identifier for the coach(DC2Type:uuid)
contentful_id	varchar(64)		false			Unique identifier from Contentful CMS for syncing coach data
first_name	varchar(255)		false			First name of the coach
last_name	varchar(255)		false			Last name of the coach
training_prices_as_json	json		false			JSON encoded training prices configuration with different session types and durations
profile_image_id	uuid		true		public.image	Reference to the coach profile image(DC2Type:uuid)
email_address	varchar(255)		false			Contact email address of the coach
title	varchar(255)		false			Professional title or designation of the coach (e.g., Head Coach, Tennis Pro)
phone_number	varchar(255)		false			Contact phone number of the coach
user_id	uuid		true		public.user	Reference to user account if coach has logged in access(DC2Type:uuid)
is_active	boolean	false	false			Flag indicating whether the coach is currently active and available for bookings

Name	Type	Definition
coach_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_3f596dccc4cf44dc	FOREIGN KEY	FOREIGN KEY (profile_image_id) REFERENCES image(id)
fk_3f596dcca76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)

Name	Definition
coach_pkey	CREATE UNIQUE INDEX coach_pkey ON public.coach USING btree (id)
uniq_3f596dcca76ed395	CREATE UNIQUE INDEX uniq_3f596dcca76ed395 ON public.coach USING btree (user_id)
uniq_3f596dccc4cf44dc	CREATE UNIQUE INDEX uniq_3f596dccc4cf44dc ON public.coach USING btree (profile_image_id)
uniq_3f596dccd756ce8c	CREATE UNIQUE INDEX uniq_3f596dccd756ce8c ON public.coach USING btree (contentful_id)

Generated by tbls