game-catalog
Tables
Section titled “Tables”| Name | Columns | Comment | Type |
|---|---|---|---|
| public.candidate | 26 | A game or expansion on its way into the engine’s catalogue: created from BGG data, enriched with rules found on the web and interpreted by an LLM, reviewed by a human and then published to the engine. A published candidate can be approved again with new values; the pipeline then updates the engine’s game or expansion. | BASE TABLE |
| public.candidate_reliability_check | 9 | One field compared between the BGG data and the LLM’s reading of the rules; together they explain the candidate’s reliability. | BASE TABLE |
| public.bgg_ranking | 10 | A row of the imported BGG ranking CSV. The pipeline creates a candidate for it, best ranked first; candidate_id is NULL until then. | BASE TABLE |
| public.raw_artifact | 7 | Source material behind a candidate, as received: the BGG API response, the web search result and the LLM extraction. | BASE TABLE |
| public.pipeline_control | 6 | A step runs only when it is not paused (through the API) and not suspended (an external service answered 5xx/429; suspended_until is when it may try again). | BASE TABLE |
| public.idempotency_record | 9 | BASE TABLE |
Relations
Section titled “Relations”
Generated by tbls