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]
public.image
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
path
[varchar(255)]
url
[varchar(255)]
sort_index
[integer]
FOREIGN KEY (main_image_id) REFERENCES image(id)
public.club_facility
[BASE TABLE]
club_id
[uuid]
facility_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
public.club_image
[BASE TABLE]
club_id
[uuid]
image_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
public.coach_club
[BASE TABLE]
coach_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
public.court
[BASE TABLE]
id
[uuid]
name
[varchar(255)]
club_id
[uuid]
location_type
[varchar(255)]
match_type
[varchar(255)]
contentful_id
[varchar(64)]
is_active
[boolean]
sport_id
[uuid]
is_premium
[boolean]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
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 (club_id) REFERENCES club(id)
public.group
[BASE TABLE]
id
[uuid]
club_id
[uuid]
name
[varchar(255)]
keycloak_id
[uuid]
role_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id)
public.liked_clubs
[BASE TABLE]
user_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
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 (club_id) REFERENCES club(id)
public.user_group_club
[BASE TABLE]
user_group_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
public.opening_time
[BASE TABLE]
id
[uuid]
club_id
[uuid]
index
[integer]
name
[varchar(255)]
opens_at
[varchar(255)]
closes_at
[varchar(255)]
opened_hours
[numeric(4,2)]
type
[varchar(255)]
is_opened
[boolean]
FOREIGN KEY (club_id) REFERENCES club(id)
public.match_series
[BASE TABLE]
id
[uuid]
court_id
[uuid]
owner_id
[uuid]
created_at
[timestamp(0) with time zone]
status
[varchar(255)]
payment_plan
[varchar(255)]
match_duration_in_seconds
[integer]
type
[varchar(255)]
weekday
[varchar(255)]
note
[varchar(255)]
starts_at
[time(0) without time zone]
discount_percentage
[integer]
club_id
[uuid]
discount_id
[uuid]
activated_at
[timestamp(0) with time zone]
terminated_at
[timestamp(0) with time zone]
FOREIGN KEY (club_id) REFERENCES club(id)
public.club_event
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
is_active
[boolean]
club_id
[uuid]
template_id
[uuid]
event_period_starts_at
[timestamp(0) with time zone]
event_period_ends_at
[timestamp(0) with time zone]
event_period_duration_in_seconds
[integer]
price_per_person_amount
[bigint]
price_per_person_currency
[character(3)]
stripe_price_id
[varchar(64)]
status
[varchar(255)]
max_confirmed_registrations
[integer]
registration_opens_at
[timestamp(0) with time zone]
description
[text]
persons_per_team
[integer]
type
[varchar(255)]
is_registrations_hidden
[boolean]
registration_closes_at
[timestamp(0) with time zone]
free_cancellation_strategy
[varchar(255)]
updated_by_id
[uuid]
cancellation_reason
[varchar(255)]
updated_at
[timestamp(0) with time zone]
sport_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id)
public.club_price_list
[BASE TABLE]
id
[uuid]
assigned_club_id
[uuid]
created_at
[date]
valid_from
[date]
pricing
[json]
contentful_id
[varchar(64)]
fallback_price_per_hour_amount
[bigint]
fallback_price_per_hour_currency
[character(3)]
is_active
[boolean]
title
[varchar(255)]
FOREIGN KEY (assigned_club_id) REFERENCES club(id)
public.day_opening_time_override
[BASE TABLE]
id
[uuid]
club_id
[uuid]
created_at
[timestamp(0) with time zone]
date
[date]
opens_at
[varchar(255)]
closes_at
[varchar(255)]
opened_hours
[numeric(4,2)]
is_opened
[boolean]
FOREIGN KEY (club_id) REFERENCES club(id)
public.access_grant
[BASE TABLE]
id
[uuid]
club_id
[uuid]
created_at
[timestamp(0) with time zone]
entity_type
[varchar(255)]
code
[varchar(255)]
valid_from
[date]
valid_till
[date]
contentful_id
[varchar(64)]
FOREIGN KEY (club_id) REFERENCES club(id)
public.club_equipment
[BASE TABLE]
id
[uuid]
equipment_id
[uuid]
club_id
[uuid]
price_amount
[bigint]
price_currency
[character(3)]
FOREIGN KEY (club_id) REFERENCES club(id)