match_edit_loadout_change

Description

The new loadout attributes of one participant, proposed by a match edit; they replace the current ones.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘match_edit_loadout_change_seq’::regclass)	false
public_id	uuid	gen_random_uuid()	false
match_edit_id	bigint		false		public.match_edit
match_participant_id	bigint		false		public.match_participant
attributes	jsonb		false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true

Constraints

Name	Type	Definition
fk_match_edit_loadout_change_match_participant_id	FOREIGN KEY	FOREIGN KEY (match_participant_id) REFERENCES match_participant(id)
fk_match_edit_loadout_change_match_edit_id	FOREIGN KEY	FOREIGN KEY (match_edit_id) REFERENCES match_edit(id)
match_edit_loadout_change_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_match_edit_loadout_change_public_id	UNIQUE	UNIQUE (public_id)
uq_match_edit_loadout_change_match_edit_participant	UNIQUE	UNIQUE (match_edit_id, match_participant_id)

Indexes

Name	Definition
match_edit_loadout_change_pkey	CREATE UNIQUE INDEX match_edit_loadout_change_pkey ON public.match_edit_loadout_change USING btree (id)
uq_match_edit_loadout_change_public_id	CREATE UNIQUE INDEX uq_match_edit_loadout_change_public_id ON public.match_edit_loadout_change USING btree (public_id)
uq_match_edit_loadout_change_match_edit_participant	CREATE UNIQUE INDEX uq_match_edit_loadout_change_match_edit_participant ON public.match_edit_loadout_change USING btree (match_edit_id, match_participant_id)
ix_match_edit_loadout_change_match_participant_id	CREATE INDEX ix_match_edit_loadout_change_match_participant_id ON public.match_edit_loadout_change USING btree (match_participant_id)

Relations

---

Generated by tbls