public.slot¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| game_id | uuid | false | public.game | Unique identifier of the match.(DC2Type:uuid) | ||
| player_id | uuid | true | public.match_player | (DC2Type:uuid) | ||
| index | integer | false | ||||
| fee_amount | bigint | false | ||||
| fee_currency | character(3) | false | (DC2Type:currency) | |||
| expected_payment_by_id | uuid | true | public.match_player | (DC2Type:uuid) | ||
| paid_by_id | uuid | true | public.match_player | (DC2Type:uuid) | ||
| title | varchar(255) | NULL::character varying | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_ac0e2067e48fd905 | FOREIGN KEY | FOREIGN KEY (game_id) REFERENCES game(id) |
| fk_ac0e206724646be9 | FOREIGN KEY | FOREIGN KEY (expected_payment_by_id) REFERENCES match_player(id) |
| fk_ac0e20677f9bc654 | FOREIGN KEY | FOREIGN KEY (paid_by_id) REFERENCES match_player(id) |
| fk_ac0e206799e6f5df | FOREIGN KEY | FOREIGN KEY (player_id) REFERENCES match_player(id) |
| slot_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| slot_pkey | CREATE UNIQUE INDEX slot_pkey ON public.slot USING btree (id) |
| idx_ac0e2067e48fd905 | CREATE INDEX idx_ac0e2067e48fd905 ON public.slot USING btree (game_id) |
| uniq_ac0e206799e6f5df | CREATE UNIQUE INDEX uniq_ac0e206799e6f5df ON public.slot USING btree (player_id) |
| idx_ac0e206724646be9 | CREATE INDEX idx_ac0e206724646be9 ON public.slot USING btree (expected_payment_by_id) |
| idx_ac0e20677f9bc654 | CREATE INDEX idx_ac0e20677f9bc654 ON public.slot USING btree (paid_by_id) |
Relations¶
Generated by tbls