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]
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.event_template
[BASE TABLE]
id
[uuid]
teaser_image_id
[uuid]
contentful_id
[varchar(64)]
title
[varchar(255)]
subtitle
[varchar(255)]
description
[text]
is_active
[boolean]
stripe_product_id
[varchar(64)]
FOREIGN KEY (template_id) REFERENCES event_template(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 (updated_by_id) REFERENCES "user"(id) ON DELETE SET NULL
public.sport
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
FOREIGN KEY (sport_id) REFERENCES sport(id)
public.event_registration
[BASE TABLE]
id
[uuid]
event_id
[uuid]
created_at
[timestamp(0) with time zone]
status
[varchar(255)]
team_id
[uuid]
created_by_id
[uuid]
cancelled_by_id
[uuid]
cancelled_at
[timestamp(0) with time zone]
FOREIGN KEY (event_id) REFERENCES club_event(id)