```json { "classifications": [ {"column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique BIGINT values identifying each report section"}, {"column": "jobs_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key linking to jobs table, used for joins"}, {"column": "report_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key VARCHAR identifier linking to reports, used for joins"}, {"column": "index", "role": "dimension", "confidence": 0.95, "reason": "Low-cardinality numeric (0-6) representing section order/position, used for grouping and filtering"}, {"column": "slug", "role": "dimension", "confidence": 1.0, "reason": "Categorical identifier with 7 distinct values, used for filtering and grouping sections"}, {"column": "section_group_id", "role": "identifier", "confidence": 0.8, "reason": "Intended as foreign key for grouping (100% null currently, but semantic purpose is joining)"}, {"column": "title", "role": "attribute", "confidence": 0.95, "reason": "Descriptive display text for section names, not grouped or aggregated"}, {"column": "content_md", "role": "attribute", "confidence": 1.0, "reason": "Long-form markdown content for display, never grouped or aggregated"}, {"column": "chart_ids_json", "role": "attribute", "confidence": 0.9, "reason": "JSON array of chart references for display, not aggregated"}, {"column": "chart_captions_json", "role": "attribute", "confidence": 0.9, "reason": "JSON object with descriptive captions for display purposes"}, {"column": "cited_artifacts_json", "role": "attribute", "confidence": 0.85, "reason": "JSON field for artifact references (100% null, but semantic purpose is descriptive)"}, {"column": "generated_by", "role": "dimension", "confidence": 0.95, "reason": "Categorical flag indicating generation method, used for filtering/grouping"}, {"column": "model", "role": "dimension", "confidence": 0.95, "reason": "Categorical identifier for AI model used, suitable for grouping and filtering"}, {"column": "provider", "role": "dimension", "confidence": 0.95, "reason": "Categorical identifier for AI provider, used for grouping and filtering"} ] } ```