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)]
public.equipment
[BASE TABLE]
id
[uuid]
type
[varchar(255)]
name
[varchar(255)]
fee_amount
[bigint]
fee_currency
[character(3)]
sport_id
[uuid]
FOREIGN KEY (equipment_id) REFERENCES equipment(id)
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 (player_id) REFERENCES match_player(id)