public.coach
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
first_name
[varchar(255)]
last_name
[varchar(255)]
training_prices_as_json
[json]
profile_image_id
[uuid]
email_address
[varchar(255)]
title
[varchar(255)]
phone_number
[varchar(255)]
user_id
[uuid]
is_active
[boolean]
public.image
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
path
[varchar(255)]
url
[varchar(255)]
sort_index
[integer]
FOREIGN KEY (profile_image_id) REFERENCES image(id)
public.user
[BASE TABLE]
id
[uuid]
first_name
[varchar(255)]
last_name
[varchar(255)]
email
[varchar(255)]
gender
[varchar(255)]
birthday
[date]
skill_level
[varchar(255)]
is_age_public
[boolean]
profile_image_path
[varchar(255)]
is_marketing_consent_granted
[boolean]
marketing_consent_granted_at
[timestamp(0) with time zone]
get_stream_token
[text]
email_address_id
[uuid]
preferred_playing_times
[text]
dominant_hands
[text]
locale
[varchar(255)]
is_deleted
[boolean]
deleted_at
[timestamp(0) with time zone]
created_at
[timestamp(0) with time zone]
phone_number
[varchar(255)]
FOREIGN KEY (user_id) REFERENCES "user"(id)
public.coach_absence
[BASE TABLE]
id
[uuid]
coach_id
[uuid]
title
[varchar(255)]
starts_at
[timestamp(0) with time zone]
ends_at
[timestamp(0) with time zone]
FOREIGN KEY (coach_id) REFERENCES coach(id)
public.coach_club
[BASE TABLE]
coach_id
[uuid]
club_id
[uuid]
FOREIGN KEY (coach_id) REFERENCES coach(id) ON DELETE CASCADE
public.match_coach
[BASE TABLE]
id
[uuid]
coach_id
[uuid]
first_name
[varchar(255)]
last_name
[varchar(255)]
trained_players
[integer]
price__amount
[bigint]
price__currency
[character(3)]
FOREIGN KEY (coach_id) REFERENCES coach(id)
public.training_schedule
[BASE TABLE]
id
[uuid]
club_id
[uuid]
coach_id
[uuid]
contentful_id
[varchar(64)]
training_time_as_json
[json]
is_visible
[boolean]
FOREIGN KEY (coach_id) REFERENCES coach(id)