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)]
public.email_address
[BASE TABLE]
id
[uuid]
user_id
[uuid]
email_address
[varchar(255)]
confirmation_token
[uuid]
is_ownership_confirmed
[boolean]
ownership_confirmed_at
[timestamp(0) without time zone]
FOREIGN KEY (email_address_id) REFERENCES email_address(id)
public.coach
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
first_name
[varchar(255)]
last_name
[varchar(255)]
training_prices_as_json
[json]
profile_image_id
[uuid]
email_address
[varchar(255)]
title
[varchar(255)]
phone_number
[varchar(255)]
user_id
[uuid]
is_active
[boolean]
FOREIGN KEY (user_id) REFERENCES "user"(id)
public.court_blocker
[BASE TABLE]
id
[uuid]
starts_at
[timestamp(0) with time zone]
ends_at
[timestamp(0) with time zone]
title
[varchar(255)]
created_at
[timestamp(0) with time zone]
updated_at
[timestamp(0) with time zone]
note
[text]
created_by_id
[uuid]
updated_by_id
[uuid]
FOREIGN KEY (updated_by_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
public.document_approval
[BASE TABLE]
id
[uuid]
user_id
[uuid]
document_id
[uuid]
approved_at
[timestamp(0) with time zone]
FOREIGN KEY (user_id) REFERENCES "user"(id)
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 (cancelled_by_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
public.liked_clubs
[BASE TABLE]
user_id
[uuid]
club_id
[uuid]
FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE CASCADE
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]
FOREIGN KEY (user_id) REFERENCES "user"(id)
public.payment_intent
[BASE TABLE]
id
[uuid]
user_id
[uuid]
match_id
[uuid]
total_in_cents
[varchar(255)]
currency
[varchar(255)]
stripe_client_secret
[varchar(255)]
FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE RESTRICT
public.voucher
[BASE TABLE]
id
[uuid]
code
[varchar(255)]
owner_id
[uuid]
amount_amount
[bigint]
amount_currency
[character(3)]
title
[varchar(255)]
type
[varchar(255)]
percentage
[integer]
created_by_id
[uuid]
expires_at
[timestamp(0) with time zone]
created_at
[timestamp(0) with time zone]
blocked_by_id
[uuid]
blocked_at
[timestamp(0) with time zone]
allowed_redemptions
[integer]
note
[text]
status
[varchar(255)]
kind
[varchar(255)]
max_redemptions_per_user
[integer]
original_kind
[varchar(255)]
FOREIGN KEY (blocked_by_id) REFERENCES "user"(id)
FOREIGN KEY (owner_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
public.voucher_redemption
[BASE TABLE]
id
[uuid]
redeemed_by_id
[uuid]
voucher_id
[uuid]
redeemed_at
[timestamp(0) with time zone]
redeemed_amount_amount
[bigint]
redeemed_amount_currency
[character(3)]
FOREIGN KEY (redeemed_by_id) REFERENCES "user"(id)
public.user_group
[BASE TABLE]
id
[uuid]
public_name
[varchar(255)]
internal_name
[varchar(60)]
note
[text]
created_at
[timestamp(0) with time zone]
type
[varchar(255)]
invite_code
[varchar(10)]
deactivated_by_id
[uuid]
deactivated_at
[timestamp(0) with time zone]
active
[boolean]
FOREIGN KEY (deactivated_by_id) REFERENCES "user"(id)
public.member
[BASE TABLE]
id
[uuid]
group_id
[uuid]
user_id
[uuid]
created_at
[timestamp(0) with time zone]
email_address
[varchar(255)]
status
[varchar(255)]
added_by_id
[uuid]
FOREIGN KEY (added_by_id) REFERENCES "user"(id)
FOREIGN KEY (user_id) REFERENCES "user"(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 (owner_id) REFERENCES "user"(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 (updated_by_id) REFERENCES "user"(id) ON DELETE SET NULL
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 (cancelled_by_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
public.team_member
[BASE TABLE]
id
[uuid]
team_id
[uuid]
created_at
[timestamp(0) without time zone]
first_name
[varchar(255)]
last_name
[varchar(255)]
email_address
[varchar(255)]
user_id
[uuid]
role
[varchar(255)]
FOREIGN KEY (user_id) REFERENCES "user"(id)
public.wellpass_account
[BASE TABLE]
id
[uuid]
created_at
[timestamp(0) with time zone]
is_linked
[boolean]
linked_at
[timestamp(0) with time zone]
member_account_id
[varchar(255)]
owner_id
[uuid]
linked_with_email_address
[varchar(255)]
user_group_member_id
[uuid]
FOREIGN KEY (owner_id) REFERENCES "user"(id)
public.cancellation
[BASE TABLE]
id
[uuid]
initiated_by_id
[uuid]
created_at
[timestamp(0) with time zone]
refund_strategy
[varchar(255)]
reason
[varchar(255)]
initiator_role
[varchar(255)]
game_id
[uuid]
payout_method
[varchar(255)]
FOREIGN KEY (initiated_by_id) REFERENCES "user"(id)
public.voucher_reservation
[BASE TABLE]
id
[uuid]
owner_id
[uuid]
stripe_payment_intent_id
[varchar(255)]
created_at
[timestamp(0) with time zone]
voucher_id
[uuid]
is_paid
[boolean]
amount_amount
[bigint]
amount_currency
[character(3)]
FOREIGN KEY (owner_id) REFERENCES "user"(id)