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]
public.club
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
name
[varchar(255)]
address_street_name
[varchar(255)]
address_building_number
[varchar(255)]
address_postal_code
[varchar(255)]
address_locality_name
[varchar(255)]
location_latitude
[numeric(9,7)]
location_longitude
[numeric(9,7)]
contact_name
[varchar(255)]
contact_website
[varchar(255)]
contact_phone_number
[varchar(255)]
contact_email_address
[varchar(255)]
contact_profile_image_url
[varchar(255)]
is_active
[boolean]
main_image_id
[uuid]
opening_times_as_json
[json]
operator_name
[varchar(255)]
court_pricing_as_json
[json]
timezone
[varchar(255)]
default_price_per_hour_amount
[bigint]
default_price_per_hour_currency
[character(3)]
description
[text]
subdivision_code
[varchar(255)]
wellpass_api_key
[varchar(255)]
is_wellpass_enabled
[boolean]
is_shown_in_app
[boolean]
FOREIGN KEY (club_id) REFERENCES club(id)
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.training_time
[BASE TABLE]
id
[uuid]
index
[integer]
name
[varchar(255)]
starts_at
[varchar(255)]
ends_at
[varchar(255)]
training_schedule_id
[uuid]
FOREIGN KEY (training_schedule_id) REFERENCES training_schedule(id)