```json { "table_name": "quality_scorecards", "primary_key": "id", "candidates": [ { "rank": 0, "partition_key": "id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV = 1.00 (perfect uniqueness), 116 unique values across 116 rows, monotonicity = 1.000 indicating sequential assignment. Semantically serves as the primary identifier for each quality scorecard record.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require internal sorting. Each scorecard is a standalone quality assessment record.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table storing quality scorecard metadata. The id column is the natural primary identifier. Alternative candidates like dataset_id (RPUV=1.55) or batch_id (RPUV=1.03) represent foreign keys to other entities rather than organizing principles for this table. The table captures quality assessment snapshots, each uniquely identified by id." } ] } ```