Skip to content

public.equipment

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false public.player_equipment public.club_equipment Unique identifier of the equipment item.(DC2Type:uuid)
type varchar(255) false Equipment type identifier (e.g., BADMINTON_RACKET, TENNIS_RACKET, PADEL_BAT).
name varchar(255) false Display name of the equipment item.
fee_amount bigint false
fee_currency character(3) false (DC2Type:currency)
sport_id uuid false public.sport The sport this equipment is designed for.(DC2Type:uuid)

Constraints

Name Type Definition
equipment_pkey PRIMARY KEY PRIMARY KEY (id)
fk_d338d583ac78bcf8 FOREIGN KEY FOREIGN KEY (sport_id) REFERENCES sport(id)

Indexes

Name Definition
equipment_pkey CREATE UNIQUE INDEX equipment_pkey ON public.equipment USING btree (id)
uniq_d338d5838cde5729 CREATE UNIQUE INDEX uniq_d338d5838cde5729 ON public.equipment USING btree (type)
idx_d338d583ac78bcf8 CREATE INDEX idx_d338d583ac78bcf8 ON public.equipment USING btree (sport_id)

Relations

er

Generated by tbls