```json { "table_name": "column_tags", "primary_key": "id", "candidates": [ { "rank": 0, "partition_key": "id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "id is the unique identifier with RPUV=1.00, uniqueness=1.000, and perfect monotonicity=1.000. Each row represents a distinct tag assignment to a column in the catalog. As a dimension table, the primary identifier serves as the natural partition key.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require internal sorting. No clustering key is needed.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table storing metadata tags for columns in a data catalog. The id column uniquely identifies each tag assignment. Alternative perspective by columns_catalog_id (RPUV=6.37) would group tags by column, but the primary use case is to look up individual tag records by their unique id." } ] } ```