raw_artifact

Description

Source material behind a candidate, as received: the BGG API response, the web search result and the LLM extraction.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘raw_artifact_seq’::regclass)	false
public_id	uuid	gen_random_uuid()	false
candidate_id	bigint		false		public.candidate
source	varchar(50)		false
content	jsonb		false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true

Constraints

Name	Type	Definition
fk_raw_artifact_candidate_id	FOREIGN KEY	FOREIGN KEY (candidate_id) REFERENCES candidate(id)
raw_artifact_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_raw_artifact_public_id	UNIQUE	UNIQUE (public_id)

Indexes

Name	Definition
raw_artifact_pkey	CREATE UNIQUE INDEX raw_artifact_pkey ON public.raw_artifact USING btree (id)
uq_raw_artifact_public_id	CREATE UNIQUE INDEX uq_raw_artifact_public_id ON public.raw_artifact USING btree (public_id)
ix_raw_artifact_candidate_id	CREATE INDEX ix_raw_artifact_candidate_id ON public.raw_artifact USING btree (candidate_id)

Relations

---

Generated by tbls