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]
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 (court_id) REFERENCES court(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 (owner_id) REFERENCES "user"(id)
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.discount
[BASE TABLE]
id
[uuid]
group_id
[uuid]
created_at
[timestamp(0) with time zone]
valid_from
[timestamp(0) with time zone]
valid_till
[timestamp(0) with time zone]
percentage
[integer]
is_enabled
[boolean]
applicable_on_days
[text]
applicable_from_time
[time(0) without time zone]
applicable_till_time
[time(0) without time zone]
applicable_on_sports
[text]
applicable_on_locations
[text]
max_playable_hours_in_validity_period
[integer]
kind
[varchar(255)]
played_hours_in_validity_period
[double precision]
played_hours_last_computed_at
[timestamp(0) with time zone]
origin
[varchar(255)]
FOREIGN KEY (discount_id) REFERENCES discount(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 (match_series_id) REFERENCES match_series(id)