public.equipment¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.player_equipment public.club_equipment | (DC2Type:uuid) | ||
| type | varchar(255) | false | ||||
| name | varchar(255) | false | ||||
| fee_amount | bigint | false | ||||
| fee_currency | character(3) | false | (DC2Type:currency) | |||
| sport_id | uuid | false | public.sport | (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¶
Generated by tbls