{
    "table_name": "players_tournament_man_",
    "primary_key": "name, year, tournament",
    "candidates": [
        {
            "rank": 0,
            "partition_key": "name",
            "partition_key_label": "primary_identifier",
            "partition_key_reasoning": "name is the player identifier. It has 462 unique values and RPUV 13.90, and top-3 coverage is only 9.87%, so it is a reasonable organizer. It is not unique per row, because each player has many tournament-year rows. The composite (name, year, tournament) is what identifies a row.",
            "clustering_key": "year",
            "clustering_key_label": null,
            "clustering_key_reasoning": "year (23 unique values, range 2002-2024) orders a player's tournament participations chronologically. The table is a dimension, so this is optional sorting only, and no X label applies.",
            "world_line": null,
            "session_column": null,
            "confidence": "MEDIUM",
            "notes": "The table is given as a dimension: one row per player, year and tournament, with the rounds reached stored as a list string. No single column is unique (name 0.072, tournament 0.058, year 0.004), so the primary key is composite. The rank-0 partition is the player. The alternative is partitioning by tournament. Metadata columns (_ingestion_timestamp, _batch_id, _source_file, _source_system) are constant and unusable as keys."
        },
        {
            "rank": 1,
            "partition_key": "tournament",
            "partition_key_label": "primary_identifier",
            "partition_key_reasoning": "tournament has 370 unique values, RPUV 17.36 and top-3 coverage of 15.43%. It is a valid alternative organizer for analysis by event.",
            "clustering_key": "year",
            "clustering_key_label": null,
            "clustering_key_reasoning": "year orders editions of the same tournament over time.",
            "world_line": null,
            "session_column": null,
            "confidence": "LOW",
            "notes": "Alternative perspective: participation by tournament across years. It is less natural than the player view, because the table is named for players and tournament is a label rather than a stable ID."
        }
    ]
}