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]
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 (event_id) REFERENCES club_event(id)
public.team
[BASE TABLE]
id
[uuid]
FOREIGN KEY (team_id) REFERENCES team(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 (created_by_id) REFERENCES "user"(id)
FOREIGN KEY (cancelled_by_id) REFERENCES "user"(id)
public.cart
[BASE TABLE]
id
[uuid]
event_registration_id
[uuid]
match_player_id
[uuid]
FOREIGN KEY (event_registration_id) REFERENCES event_registration(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 (event_registration_id) REFERENCES event_registration(id)
public.event_term
[BASE TABLE]
id
[uuid]
action
[varchar(255)]
applicable_from
[timestamp(0) with time zone]
applicable_till
[timestamp(0) with time zone]
type
[varchar(255)]
legacy_type
[varchar(255)]
due_fee_amount
[bigint]
due_fee_currency
[varchar(3)]
is_action_allowed
[boolean]
event_registration_id
[uuid]
FOREIGN KEY (event_registration_id) REFERENCES event_registration(id)