public.match_player
[BASE TABLE]
id
[uuid]
user_id
[uuid]
game_id
[uuid]
slot
[integer]
is_host
[boolean]
terms_of_service_id
[uuid]
joined_match_at
[timestamp(0) with time zone]
confirmed_match_at
[timestamp(0) with time zone]
left_match_at
[timestamp(0) with time zone]
status
[varchar(255)]
discount_id
[uuid]
expected_payment_of_slots
[integer]
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 (user_id) REFERENCES "user"(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 (game_id) REFERENCES game(id)
public.terms_of_service
[BASE TABLE]
id
[uuid]
FOREIGN KEY (terms_of_service_id) REFERENCES terms_of_service(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.cart
[BASE TABLE]
id
[uuid]
event_registration_id
[uuid]
match_player_id
[uuid]
FOREIGN KEY (match_player_id) REFERENCES match_player(id)
public.player_equipment
[BASE TABLE]
id
[uuid]
equipment_id
[uuid]
player_id
[uuid]
type
[varchar(255)]
name
[varchar(255)]
rental_fee_amount
[bigint]
rental_fee_currency
[character(3)]
FOREIGN KEY (player_id) REFERENCES match_player(id)
public.refund
[BASE TABLE]
id
[uuid]
player_id
[uuid]
status
[varchar(255)]
refunded_at
[timestamp(0) with time zone]
stripe_refund_id
[varchar(255)]
total_amount
[bigint]
total_currency
[character(3)]
created_at
[timestamp(0) with time zone]
voucher_id
[uuid]
refunded_amount_voucher_amount
[bigint]
refunded_amount_voucher_currency
[character(3)]
refunded_amount_online_amount
[bigint]
refunded_amount_online_currency
[character(3)]
strategy
[varchar(255)]
event_registration_id
[uuid]
FOREIGN KEY (player_id) REFERENCES match_player(id)
public.slot
[BASE TABLE]
id
[uuid]
game_id
[uuid]
player_id
[uuid]
index
[integer]
fee_amount
[bigint]
fee_currency
[character(3)]
expected_payment_by_id
[uuid]
paid_by_id
[uuid]
title
[varchar(255)]
FOREIGN KEY (expected_payment_by_id) REFERENCES match_player(id)
FOREIGN KEY (paid_by_id) REFERENCES match_player(id)
FOREIGN KEY (player_id) REFERENCES match_player(id)