public.club_equipment¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| equipment_id | uuid | false | public.equipment | (DC2Type:uuid) | ||
| club_id | uuid | false | public.club | (DC2Type:uuid) | ||
| price_amount | bigint | false | ||||
| price_currency | character(3) | false | (DC2Type:currency) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_cfee1bce61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) |
| fk_cfee1bce517fe9fe | FOREIGN KEY | FOREIGN KEY (equipment_id) REFERENCES equipment(id) |
| club_equipment_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| club_equipment_pkey | CREATE UNIQUE INDEX club_equipment_pkey ON public.club_equipment USING btree (id) |
| idx_7c317565517fe9fe | CREATE INDEX idx_7c317565517fe9fe ON public.club_equipment USING btree (equipment_id) |
| idx_7c31756561190a32 | CREATE INDEX idx_7c31756561190a32 ON public.club_equipment USING btree (club_id) |
Relations¶
Generated by tbls