```json { "classifications": [ { "column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique sequential values" }, { "column": "tables_catalog_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing tables catalog" }, { "column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key with coded format (d_*) for dataset identification" }, { "column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key with coded format (batch_*) for batch identification" }, { "column": "method", "role": "dimension", "confidence": 1.0, "reason": "Categorical field with single value 'least_squares', used for grouping/filtering" }, { "column": "max_degree", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality numeric code (single value: 4) representing polynomial degree configuration" }, { "column": "column_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (2-55) to be aggregated for analysis" }, { "column": "pair_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (1-120) to be aggregated for analysis" }, { "column": "sample_row_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (16-5000) to be aggregated for analysis" }, { "column": "columns_json", "role": "attribute", "confidence": 1.0, "reason": "JSON array of column names, descriptive content for display" }, { "column": "pairs_json", "role": "attribute", "confidence": 1.0, "reason": "Large JSON object with polynomial fit results, descriptive content for display" }, { "column": "computed_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for temporal grouping and filtering" } ] } ```