```json { "table_name": "datasets", "primary_key": "dataset_id", "candidates": [ { "rank": 0, "partition_key": "dataset_id", "partition_key_label": "E", "partition_key_reasoning": "RPUV=1.00 (perfect uniqueness), 109 unique values across 109 rows. This is the entity whose lifecycle we trace — each dataset has its own timeline of status changes and updates.", "clustering_key": "created_at", "clustering_key_label": "S", "clustering_key_reasoning": "RPUV=1.00, fully unique timestamps. Orders the dataset's lifecycle events chronologically. created_at is the natural sequence axis for path tables tracking entity evolution.", "world_line": "dataset_id", "session_column": null, "confidence": "HIGH", "notes": "This is a path table tracking dataset lifecycle: each dataset_id (E) has a timeline ordered by created_at/updated_at (S). The status field shows state transitions (ingesting → ready → deleted). Partitioning by dataset_id groups all events for a single dataset together; sorting by created_at orders them chronologically." } ] } ```