README.md

# Grand Archive Cardbase

Generated: 20260425
Source: https://api.gatcg.com

## Row counts
- `cards`: 2236
- `editions`: 4416
- `circulations`: 4446
- `sets`: 55
- `rarities`: 9
- `types`: 15
- `subtypes`: 153
- `elements`: 13
- `classes`: 9
- `set_groups`: 9
- `set_group_members`: 35

## Tables
- `cards`: one row per card (uuid PK).
- `editions`: one row per printing of a card. FK: `card_uuid` -> `cards.uuid`.
- `circulations`: one row per circulation kind per edition. FKs: `card_uuid`, `edition_uuid`.
- `sets`, `rarities`, `types`, `subtypes`, `elements`, `classes`: dimension tables from `/option/search`.
- `set_groups`, `set_group_members`: featured sets from `/featured-sets`.
  `set_group_members.group_uuid` -> `set_groups.group_uuid`,
  `set_group_members.set_id` -> `editions.set_id`.

`ga.duckdb` exposes the parquet files as views via relative paths (`parquet/<name>.parquet`).