```json { "table_name": "report_insights", "primary_key": "jobs_id,index", "candidates": [ { "rank": 0, "partition_key": "jobs_id", "partition_key_label": "E", "partition_key_reasoning": "Entity column identified by classifier. RPUV=11.91 is excellent for partitioning (116 unique jobs, ~12 insights per job on average). Top 3 coverage 12.17% indicates good distribution. Semantically represents the analysis job that generated these insights.", "clustering_key": "index", "clustering_key_label": "S", "clustering_key_reasoning": "Time axis identified by classifier as sequence column. Monotonicity=0.917 confirms strong sequential ordering. Each insight within a job has an index (0-67 range), ordering the insights generated during that analysis run.", "world_line": "jobs_id", "session_column": null, "confidence": "HIGH", "notes": "Event table tracking insights generated per analysis job. Each job produces a sequence of insights (table_count, column_range, other) indexed in order. Partitioning by jobs_id groups all insights from the same analysis run together, clustering by index preserves their generation order." } ] } ```