public.coach

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.coach_absence public.coach_club public.match_coach public.training_schedule		(DC2Type:uuid)
contentful_id	varchar(64)		false
first_name	varchar(255)		false
last_name	varchar(255)		false
training_prices_as_json	json		false
profile_image_id	uuid		true		public.image	(DC2Type:uuid)
email_address	varchar(255)		false
title	varchar(255)		false
phone_number	varchar(255)		false
user_id	uuid		true		public.user	(DC2Type:uuid)
is_active	boolean	false	false

Constraints

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)

Indexes

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)

Relations

---

Generated by tbls