public.slot¶

Description¶

Name	Type	Default	Nullable	Parents	Comment
id	uuid		false		Unique identifier for the slot.(DC2Type:uuid)
game_id	uuid		false	public.game	Reference to the game this slot belongs to. Required for all slots.(DC2Type:uuid)
player_id	uuid		true	public.match_player	Reference to the player occupying this slot. Null if the slot is unoccupied.(DC2Type:uuid)
index	integer		false		Zero-based index position of the slot within the game (e.g., 0-3 for a 4-player game).
fee_amount	bigint		false
fee_currency	character(3)		false		(DC2Type:currency)
expected_payment_by_id	uuid		true	public.match_player	Reference to the player who is expected to pay for this slot when split payment is enabled.(DC2Type:uuid)
paid_by_id	uuid		true	public.match_player	Reference to the player who actually paid for this slot. Null if not yet paid.(DC2Type:uuid)
title	varchar(255)	NULL::character varying	true		Optional descriptive title for the slot (e.g., team name, position name).

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)

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)

Generated by tbls