public.match_player¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.cart public.player_equipment public.refund public.slot		(DC2Type:uuid)
user_id	uuid		false		public.user	(DC2Type:uuid)
game_id	uuid		false		public.game	Unique identifier of the match.(DC2Type:uuid)
slot	integer		false
is_host	boolean	false	false
terms_of_service_id	uuid		false		public.terms_of_service	(DC2Type:uuid)
joined_match_at	timestamp(0) with time zone	'2013-01-01 13:37:00+00'::timestamp with time zone	false			(DC2Type:datetimetz_immutable)
confirmed_match_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
left_match_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			(DC2Type:datetimetz_immutable)
status	varchar(255)	'WAITING_FOR_PLAYER'::character varying	false
discount_id	uuid		true		public.discount	(DC2Type:uuid)
expected_payment_of_slots	integer		false

Name	Type	Definition
fk_39768364e48fd905	FOREIGN KEY	FOREIGN KEY (game_id) REFERENCES game(id)
match_player_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_39768364a5debc29	FOREIGN KEY	FOREIGN KEY (terms_of_service_id) REFERENCES terms_of_service(id)
fk_39768364a76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)
fk_397683644c7c611f	FOREIGN KEY	FOREIGN KEY (discount_id) REFERENCES discount(id)

Name	Definition
match_player_pkey	CREATE UNIQUE INDEX match_player_pkey ON public.match_player USING btree (id)
idx_39768364a76ed395	CREATE INDEX idx_39768364a76ed395 ON public.match_player USING btree (user_id)
idx_39768364e48fd905	CREATE INDEX idx_39768364e48fd905 ON public.match_player USING btree (game_id)
uniq_39768364a5debc29	CREATE UNIQUE INDEX uniq_39768364a5debc29 ON public.match_player USING btree (terms_of_service_id)
idx_397683644c7c611f	CREATE INDEX idx_397683644c7c611f ON public.match_player USING btree (discount_id)

Generated by tbls