playset

Description

A reusable match configuration (variants, scenario, expansions) for one game. Soft-deleted: matches keep referring to a deleted playset, but it can no longer be chosen. Invariant (application): its expansions belong to its game.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘playset_seq’::regclass)	false	public.playset_expansion public.match public.match_edit
public_id	uuid	gen_random_uuid()	false
owner_user_id	bigint		false		public.app_user
game_id	bigint		false		public.game
display_name	varchar(100)		true
variants	text[]	‘{}’::text[]	false
scenario	varchar(200)		true
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true
deleted_at	timestamp with time zone		true
version	bigint		false

Constraints

Name	Type	Definition
fk_playset_owner_user_id	FOREIGN KEY	FOREIGN KEY (owner_user_id) REFERENCES app_user(id)
fk_playset_game_id	FOREIGN KEY	FOREIGN KEY (game_id) REFERENCES game(id)
playset_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_playset_public_id	UNIQUE	UNIQUE (public_id)

Indexes

Name	Definition
playset_pkey	CREATE UNIQUE INDEX playset_pkey ON public.playset USING btree (id)
uq_playset_public_id	CREATE UNIQUE INDEX uq_playset_public_id ON public.playset USING btree (public_id)
ix_playset_owner_user_id	CREATE INDEX ix_playset_owner_user_id ON public.playset USING btree (owner_user_id)
ix_playset_game_id	CREATE INDEX ix_playset_game_id ON public.playset USING btree (game_id)

Relations

---

Generated by tbls