public.sport
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
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 (sport_id) REFERENCES sport(id)
public.equipment
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
name
[varchar(255)]
fee_amount
[bigint]
fee_currency
[character(3)]
sport_id
[uuid]
FOREIGN KEY (sport_id) REFERENCES sport(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 (sport_id) REFERENCES sport(id)