```json { "classifications": [ { "column": "style_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values (157 distinct in 157 rows), used to identify beer styles" }, { "column": "name", "role": "attribute", "confidence": 0.95, "reason": "Descriptive name of beer style, fully unique (157 distinct), displayed but not typically grouped" }, { "column": "description", "role": "attribute", "confidence": 1.0, "reason": "Long-form descriptive text explaining beer styles, never aggregated or grouped" }, { "column": "parent_style_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing parent style in hierarchical relationship, used for joins" }, { "column": "category", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality numeric code (4 distinct values), used to group/filter beer styles by category" }, { "column": "srm_range", "role": "dimension", "confidence": 0.9, "reason": "Low-cardinality categorical range (13 distinct values), used to filter/group by color range" } ] } ```