expansion

Description

An expansion of a game; it has no meaning on its own.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘expansion_seq’::regclass)	false	public.playset_expansion public.match_expansion public.match_edit_expansion_change
public_id	uuid	gen_random_uuid()	false
game_id	bigint		false		public.game
display_name	varchar(255)		false
description	text		true
image_url	varchar(500)		true
source_ref	varchar(64)		true			Where the expansion came from, e.g. ‘bgg:199727’; unique like game.source_ref. NULL for one entered by hand.
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true
version	bigint		false

Constraints

Name	Type	Definition
fk_expansion_game_id	FOREIGN KEY	FOREIGN KEY (game_id) REFERENCES game(id)
expansion_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_expansion_public_id	UNIQUE	UNIQUE (public_id)
uq_expansion_source_ref	UNIQUE	UNIQUE (source_ref)

Indexes

Name	Definition
expansion_pkey	CREATE UNIQUE INDEX expansion_pkey ON public.expansion USING btree (id)
uq_expansion_public_id	CREATE UNIQUE INDEX uq_expansion_public_id ON public.expansion USING btree (public_id)
uq_expansion_source_ref	CREATE UNIQUE INDEX uq_expansion_source_ref ON public.expansion USING btree (source_ref)
ix_expansion_game_id	CREATE INDEX ix_expansion_game_id ON public.expansion USING btree (game_id)

Relations

---

Generated by tbls