```json { "table_name": "2014_DIVISIONAL PLAYOFFS_plays", "primary_key": "Season,Week,AwayTeam,HomeTeam,DriveNumber,PlayNumberInDrive", "candidates": [ { "rank": 0, "partition_key": "TeamWithPossession", "partition_key_label": "E", "partition_key_reasoning": "TeamWithPossession is the entity whose play-by-play timeline we trace. RPUV=85.25 (8 unique teams, 682 rows) provides good distribution. Top 3 coverage is 41.06%, indicating balanced partitioning across teams. Semantically, this groups all plays by the team executing them, enabling team-centric play sequence analysis.", "clustering_key": "PlayNumberInDrive", "clustering_key_label": "S", "clustering_key_reasoning": "PlayNumberInDrive is the sequence axis ordering plays within each drive. Monotonicity=0.878 confirms strong sequential ordering. Values range 1-18, representing the chronological progression of plays within a possession. Combined with DriveNumber context, this orders the complete play timeline for each team.", "world_line": "TeamWithPossession", "session_column": "DriveNumber", "confidence": "HIGH", "notes": "This is an event table capturing individual plays in NFL playoff games. The composite primary key (Season,Week,AwayTeam,HomeTeam,DriveNumber,PlayNumberInDrive) uniquely identifies each play. TeamWithPossession is the natural entity perspective—each team's sequence of plays forms their offensive timeline. DriveNumber acts as a session boundary (each possession is a drive), and PlayNumberInDrive orders plays within that drive. Alternative perspectives (by game via AwayTeam+HomeTeam) are less natural since plays are fundamentally team actions, not game-level events." } ] } ```