bgg_ranking

Description

A row of the imported BGG ranking CSV. The pipeline creates a candidate for it, best ranked first; candidate_id is NULL until then.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘bgg_ranking_seq’::regclass)	false
public_id	uuid	gen_random_uuid()	false
bgg_id	bigint		false
display_name	varchar(500)		false
year_published	integer		false
rank	integer		false			BGG rank; 0 for an entry that BGG does not rank, such as most expansions.
is_expansion	boolean		false
candidate_id	bigint		true		public.candidate
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true

Constraints

Name	Type	Definition
fk_bgg_ranking_candidate_id	FOREIGN KEY	FOREIGN KEY (candidate_id) REFERENCES candidate(id)
bgg_ranking_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_bgg_ranking_public_id	UNIQUE	UNIQUE (public_id)
uq_bgg_ranking_bgg_id	UNIQUE	UNIQUE (bgg_id)

Indexes

Name	Definition
bgg_ranking_pkey	CREATE UNIQUE INDEX bgg_ranking_pkey ON public.bgg_ranking USING btree (id)
uq_bgg_ranking_public_id	CREATE UNIQUE INDEX uq_bgg_ranking_public_id ON public.bgg_ranking USING btree (public_id)
uq_bgg_ranking_bgg_id	CREATE UNIQUE INDEX uq_bgg_ranking_bgg_id ON public.bgg_ranking USING btree (bgg_id)
ix_bgg_ranking_rank	CREATE INDEX ix_bgg_ranking_rank ON public.bgg_ranking USING btree (rank)
ix_bgg_ranking_candidate_id	CREATE INDEX ix_bgg_ranking_candidate_id ON public.bgg_ranking USING btree (candidate_id)

Relations

---

Generated by tbls