candidate_reliability_check

Description

One field compared between the BGG data and the LLM’s reading of the rules; together they explain the candidate’s reliability.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘candidate_reliability_check_seq’::regclass)	false
public_id	uuid	gen_random_uuid()	false
candidate_id	bigint		false		public.candidate
field	varchar(32)		false
bgg_value	varchar(255)		true
llm_value	varchar(255)		true
matches	boolean		false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true

Constraints

Name	Type	Definition
fk_candidate_reliability_check_candidate_id	FOREIGN KEY	FOREIGN KEY (candidate_id) REFERENCES candidate(id)
candidate_reliability_check_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_candidate_reliability_check_public_id	UNIQUE	UNIQUE (public_id)

Indexes

Name	Definition
candidate_reliability_check_pkey	CREATE UNIQUE INDEX candidate_reliability_check_pkey ON public.candidate_reliability_check USING btree (id)
uq_candidate_reliability_check_public_id	CREATE UNIQUE INDEX uq_candidate_reliability_check_public_id ON public.candidate_reliability_check USING btree (public_id)
ix_candidate_reliability_check_candidate_id	CREATE INDEX ix_candidate_reliability_check_candidate_id ON public.candidate_reliability_check USING btree (candidate_id)

Relations

---

Generated by tbls