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).