```json { "classifications": [ { "column": "jobs_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing jobs table; used to JOIN tables" }, { "column": "artifact_id", "role": "identifier", "confidence": 0.95, "reason": "High cardinality (794 distinct) unique artifact identifier; used as key" }, { "column": "type", "role": "dimension", "confidence": 1.0, "reason": "Low cardinality (3 values: narrative, sql_result, statistic); categorical field for grouping/filtering" }, { "column": "summary", "role": "attribute", "confidence": 0.95, "reason": "High cardinality descriptive text (729 distinct); displayed but not grouped or aggregated" }, { "column": "sql_query", "role": "attribute", "confidence": 1.0, "reason": "Free-form SQL text content (100% null in sample); descriptive field for display" }, { "column": "narrative_doc_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key reference to narrative documents (100% null in sample but semantically an ID)" }, { "column": "tables_catalog_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key reference to tables catalog (100% null in sample but semantically an ID)" }, { "column": "inline_content_json", "role": "attribute", "confidence": 1.0, "reason": "High cardinality JSON content (1087 distinct); descriptive structured data for display" }, { "column": "disk_path", "role": "attribute", "confidence": 1.0, "reason": "File path strings (673 distinct); descriptive location information for display" } ] } ```