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)]
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]
FOREIGN KEY (coach_id) REFERENCES coach(id)
public.game
[BASE TABLE]
id
[uuid]
court_id
[uuid]
club_id
[uuid]
coach_id
[uuid]
kind
[varchar(255)]
phase
[varchar(255)]
match_period_starts_at
[timestamp(0) with time zone]
match_period_ends_at
[timestamp(0) with time zone]
court_fee_amount
[bigint]
court_fee_currency
[character(3)]
created_at
[timestamp(0) with time zone]
cancelled_at
[timestamp(0) with time zone]
scheduled_at
[timestamp(0) with time zone]
terminated_at
[timestamp(0) with time zone]
cancelled_by_id
[uuid]
note
[text]
schedule_till_latest
[timestamp(0) with time zone]
match_period_duration_in_seconds
[integer]
day_index
[integer]
day_name
[varchar(255)]
running_at
[timestamp(0) with time zone]
finished_at
[timestamp(0) with time zone]
confirming_at
[timestamp(0) with time zone]
match_series_id
[uuid]
created_by_id
[uuid]
split_payment_id
[uuid]
version
[integer]
is_split_payment_migrated
[boolean]
abandoned_at
[timestamp(0) with time zone]
reserved_at
[timestamp(0) with time zone]
FOREIGN KEY (coach_id) REFERENCES match_coach(id)