public.cart
[BASE TABLE]
id
[uuid]
event_registration_id
[uuid]
match_player_id
[uuid]
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 (match_player_id) REFERENCES match_player(id)
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 (event_registration_id) REFERENCES event_registration(id)
public.cart_item
[BASE TABLE]
id
[uuid]
cart_id
[uuid]
type
[varchar(255)]
amount_amount
[bigint]
amount_currency
[character(3)]
quantity
[integer]
discount_percentage
[integer]
quantity_discountable
[integer]
FOREIGN KEY (cart_id) REFERENCES cart(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]
public.image
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
path
[varchar(255)]
url
[varchar(255)]
sort_index
[integer]
FOREIGN KEY (main_image_id) REFERENCES image(id)
public.club_facility
[BASE TABLE]
club_id
[uuid]
facility_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
public.facility
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
type
[varchar(255)]
name
[varchar(255)]
icon_url
[varchar(255)]
FOREIGN KEY (facility_id) REFERENCES facility(id) ON DELETE CASCADE
public.club_image
[BASE TABLE]
club_id
[uuid]
image_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
FOREIGN KEY (image_id) REFERENCES image(id) ON DELETE CASCADE
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 (profile_image_id) REFERENCES image(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 (user_id) REFERENCES "user"(id)
public.coach_absence
[BASE TABLE]
id
[uuid]
coach_id
[uuid]
title
[varchar(255)]
starts_at
[timestamp(0) with time zone]
ends_at
[timestamp(0) with time zone]
FOREIGN KEY (coach_id) REFERENCES coach(id)
public.coach_club
[BASE TABLE]
coach_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
FOREIGN KEY (coach_id) REFERENCES coach(id) ON DELETE CASCADE
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 (club_id) REFERENCES club(id) ON DELETE CASCADE
public.sport
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
FOREIGN KEY (sport_id) REFERENCES sport(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.court_image
[BASE TABLE]
court_id
[uuid]
image_id
[uuid]
FOREIGN KEY (court_id) REFERENCES court(id) ON DELETE CASCADE
FOREIGN KEY (image_id) REFERENCES image(id) ON DELETE CASCADE
public.doctrine_migration_versions
[BASE TABLE]
version
[varchar(191)]
executed_at
[timestamp(0) without time zone]
execution_time
[integer]
public.document
[BASE TABLE]
id
[uuid]
contentful_id
[varchar(64)]
type
[varchar(255)]
public.document_approval
[BASE TABLE]
id
[uuid]
user_id
[uuid]
document_id
[uuid]
approved_at
[timestamp(0) with time zone]
FOREIGN KEY (document_id) REFERENCES document(id)
FOREIGN KEY (user_id) REFERENCES "user"(id)
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 (user_id) REFERENCES "user"(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.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 (club_id) REFERENCES club(id)
FOREIGN KEY (court_id) REFERENCES court(id)
public.match_coach
[BASE TABLE]
id
[uuid]
coach_id
[uuid]
first_name
[varchar(255)]
last_name
[varchar(255)]
trained_players
[integer]
price__amount
[bigint]
price__currency
[character(3)]
FOREIGN KEY (coach_id) REFERENCES match_coach(id)
FOREIGN KEY (cancelled_by_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_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 (match_series_id) REFERENCES match_series(id)
public.split_payment
[BASE TABLE]
id
[uuid]
is_split_payment_enabled
[boolean]
FOREIGN KEY (split_payment_id) REFERENCES split_payment(id)
public.group
[BASE TABLE]
id
[uuid]
club_id
[uuid]
name
[varchar(255)]
keycloak_id
[uuid]
role_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id)
public.role
[BASE TABLE]
id
[uuid]
name
[varchar(255)]
keycloak_id
[uuid]
FOREIGN KEY (role_id) REFERENCES role(id)
public.liked_clubs
[BASE TABLE]
user_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE CASCADE
FOREIGN KEY (coach_id) REFERENCES coach(id)
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)
FOREIGN KEY (user_id) REFERENCES "user"(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.payment
[BASE TABLE]
id
[uuid]
status
[varchar(255)]
total_amount
[bigint]
total_currency
[character(3)]
stripe_client_secret
[varchar(255)]
is_paid
[boolean]
paid_at
[timestamp(0) with time zone]
voucher_id
[uuid]
stripe_payment_intent_id
[varchar(255)]
payment_source
[varchar(255)]
expired_at
[timestamp(0) with time zone]
voucher_redemption_id
[uuid]
cart_id
[uuid]
FOREIGN KEY (cart_id) REFERENCES cart(id)
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 (voucher_id) REFERENCES voucher(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 (voucher_redemption_id) REFERENCES voucher_redemption(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 (match_id) REFERENCES game(id) ON DELETE RESTRICT
FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE RESTRICT
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 (equipment_id) REFERENCES equipment(id)
FOREIGN KEY (player_id) REFERENCES match_player(id)
public.training_schedule
[BASE TABLE]
id
[uuid]
club_id
[uuid]
coach_id
[uuid]
contentful_id
[varchar(64)]
training_time_as_json
[json]
is_visible
[boolean]
FOREIGN KEY (club_id) REFERENCES club(id)
FOREIGN KEY (coach_id) REFERENCES coach(id)
FOREIGN KEY (email_address_id) REFERENCES email_address(id)
FOREIGN KEY (blocked_by_id) REFERENCES "user"(id)
FOREIGN KEY (owner_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
FOREIGN KEY (redeemed_by_id) REFERENCES "user"(id)
FOREIGN KEY (voucher_id) REFERENCES voucher(id)
public.service_term
[BASE TABLE]
id
[uuid]
terms_of_service_id
[uuid]
action
[varchar(255)]
applicable_phases
[text]
due_fee_amount
[bigint]
due_fee_currency
[varchar(3)]
applicable_kinds
[text]
type
[varchar(255)]
applicable_from
[timestamp(0) with time zone]
applicable_till
[timestamp(0) with time zone]
is_action_allowed
[boolean]
applicable_roles
[text]
legacy_type
[varchar(255)]
FOREIGN KEY (terms_of_service_id) REFERENCES terms_of_service(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)
FOREIGN KEY (voucher_id) REFERENCES voucher(id)
FOREIGN KEY (event_registration_id) REFERENCES event_registration(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.user_group_club
[BASE TABLE]
user_group_id
[uuid]
club_id
[uuid]
FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
FOREIGN KEY (user_group_id) REFERENCES user_group(id) ON DELETE CASCADE
public.opening_time
[BASE TABLE]
id
[uuid]
club_id
[uuid]
index
[integer]
name
[varchar(255)]
opens_at
[varchar(255)]
closes_at
[varchar(255)]
opened_hours
[numeric(4,2)]
type
[varchar(255)]
is_opened
[boolean]
FOREIGN KEY (club_id) REFERENCES club(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)
FOREIGN KEY (group_id) REFERENCES user_group(id)
FOREIGN KEY (group_id) REFERENCES user_group(id)
FOREIGN KEY (club_id) REFERENCES club(id)
FOREIGN KEY (court_id) REFERENCES court(id)
FOREIGN KEY (owner_id) REFERENCES "user"(id)
FOREIGN KEY (discount_id) REFERENCES discount(id)
public.event_template
[BASE TABLE]
id
[uuid]
teaser_image_id
[uuid]
contentful_id
[varchar(64)]
title
[varchar(255)]
subtitle
[varchar(255)]
description
[text]
is_active
[boolean]
stripe_product_id
[varchar(64)]
FOREIGN KEY (teaser_image_id) REFERENCES image(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 (club_id) REFERENCES club(id)
FOREIGN KEY (updated_by_id) REFERENCES "user"(id) ON DELETE SET NULL
FOREIGN KEY (sport_id) REFERENCES sport(id)
FOREIGN KEY (template_id) REFERENCES event_template(id)
FOREIGN KEY (cancelled_by_id) REFERENCES "user"(id)
FOREIGN KEY (created_by_id) REFERENCES "user"(id)
FOREIGN KEY (event_id) REFERENCES club_event(id)
public.team
[BASE TABLE]
id
[uuid]
FOREIGN KEY (team_id) REFERENCES team(id)
public.court_blocker_court
[BASE TABLE]
court_blocker_id
[uuid]
court_id
[uuid]
FOREIGN KEY (court_id) REFERENCES court(id) ON DELETE CASCADE
FOREIGN KEY (court_blocker_id) REFERENCES court_blocker(id) ON DELETE CASCADE
public.training_time
[BASE TABLE]
id
[uuid]
index
[integer]
name
[varchar(255)]
starts_at
[varchar(255)]
ends_at
[varchar(255)]
training_schedule_id
[uuid]
FOREIGN KEY (training_schedule_id) REFERENCES training_schedule(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)
FOREIGN KEY (team_id) REFERENCES team(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)
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 (game_id) REFERENCES game(id)
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)
public.club_price_list
[BASE TABLE]
id
[uuid]
assigned_club_id
[uuid]
created_at
[date]
valid_from
[date]
pricing
[json]
contentful_id
[varchar(64)]
fallback_price_per_hour_amount
[bigint]
fallback_price_per_hour_currency
[character(3)]
is_active
[boolean]
title
[varchar(255)]
FOREIGN KEY (assigned_club_id) REFERENCES club(id)
public.location
[BASE TABLE]
id
[uuid]
created_at
[timestamp(0) with time zone]
name
[varchar(255)]
position_latitude
[numeric(9,7)]
position_longitude
[numeric(9,7)]
public.holiday
[BASE TABLE]
id
[uuid]
created_at
[timestamp(0) with time zone]
start_date
[date]
end_date
[date]
is_nationwide
[boolean]
open_holiday_id
[uuid]
name
[varchar(255)]
country_iso_code
[varchar(10)]
subdivisions
[text]
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)
FOREIGN KEY (user_group_member_id) REFERENCES member(id)
public.holiday_name
[BASE TABLE]
id
[uuid]
holiday_id
[uuid]
name
[varchar(255)]
language_iso_code
[varchar(10)]
FOREIGN KEY (holiday_id) REFERENCES holiday(id)
public.day_opening_time_override
[BASE TABLE]
id
[uuid]
club_id
[uuid]
created_at
[timestamp(0) with time zone]
date
[date]
opens_at
[varchar(255)]
closes_at
[varchar(255)]
opened_hours
[numeric(4,2)]
is_opened
[boolean]
FOREIGN KEY (club_id) REFERENCES club(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 (game_id) REFERENCES game(id)
FOREIGN KEY (initiated_by_id) REFERENCES "user"(id)
public.access_grant
[BASE TABLE]
id
[uuid]
club_id
[uuid]
created_at
[timestamp(0) with time zone]
entity_type
[varchar(255)]
code
[varchar(255)]
valid_from
[date]
valid_till
[date]
contentful_id
[varchar(64)]
FOREIGN KEY (club_id) REFERENCES club(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)
FOREIGN KEY (voucher_id) REFERENCES voucher(id)
public.club_equipment
[BASE TABLE]
id
[uuid]
equipment_id
[uuid]
club_id
[uuid]
price_amount
[bigint]
price_currency
[character(3)]
FOREIGN KEY (club_id) REFERENCES club(id)
FOREIGN KEY (equipment_id) REFERENCES equipment(id)
public.audit_log
[BASE TABLE]
id
[bigint]
occurred_at
[timestamp(0) without time zone]
action
[varchar(16)]
target_class
[varchar(191)]
target_id
[text]
actor_user_id
[uuid]
actor_email
[varchar(191)]
request_id
[uuid]
ip
[varchar(255)]
user_agent
[text]
source
[varchar(64)]
changes
[json]
before_snapshot
[json]
after_snapshot
[json]
type
[varchar(64)]
type_id
[uuid]