public.player_equipment¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | Unique identifier for the player equipment record(DC2Type:uuid) | |||
| equipment_id | uuid | false | public.equipment | Reference to the equipment item from inventory(DC2Type:uuid) | ||
| player_id | uuid | false | public.match_player | Reference to the player who rented this equipment(DC2Type:uuid) | ||
| type | varchar(255) | false | Type of equipment (e.g., racket, shoes, etc.) | |||
| name | varchar(255) | false | Name or model of the equipment | |||
| rental_fee_amount | bigint | false | ||||
| rental_fee_currency | character(3) | false | (DC2Type:currency) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_7334e0ba517fe9fe | FOREIGN KEY | FOREIGN KEY (equipment_id) REFERENCES equipment(id) |
| fk_7334e0ba99e6f5df | FOREIGN KEY | FOREIGN KEY (player_id) REFERENCES match_player(id) |
| player_equipment_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| player_equipment_pkey | CREATE UNIQUE INDEX player_equipment_pkey ON public.player_equipment USING btree (id) |
| idx_7334e0ba517fe9fe | CREATE INDEX idx_7334e0ba517fe9fe ON public.player_equipment USING btree (equipment_id) |
| idx_7334e0ba99e6f5df | CREATE INDEX idx_7334e0ba99e6f5df ON public.player_equipment USING btree (player_id) |
Relations¶
Generated by tbls