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