```json { "classifications": [ {"column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique VARCHAR values (na_ prefix pattern)"}, {"column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key reference to dataset (d_ prefix pattern)"}, {"column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key reference to batch (batch_ prefix pattern)"}, {"column": "kind", "role": "dimension", "confidence": 1.0, "reason": "Categorical action type with 3 distinct values (label.clear, label.set, search.rebuild)"}, {"column": "fingerprint", "role": "identifier", "confidence": 1.0, "reason": "Unique hash/fingerprint identifier for deduplication"}, {"column": "target_table", "role": "dimension", "confidence": 1.0, "reason": "Table name being acted upon, used for grouping/filtering"}, {"column": "target_column", "role": "dimension", "confidence": 1.0, "reason": "Column name being acted upon, used for grouping/filtering"}, {"column": "args_json", "role": "attribute", "confidence": 1.0, "reason": "JSON payload with action arguments, displayed but not aggregated"}, {"column": "rationale", "role": "attribute", "confidence": 1.0, "reason": "Free-form text explanation for the action"}, {"column": "evidence_json", "role": "attribute", "confidence": 1.0, "reason": "JSON payload with evidence details, displayed but not aggregated"}, {"column": "blast_radius", "role": "dimension", "confidence": 1.0, "reason": "Categorical impact level (only 'low' observed), used for filtering"}, {"column": "reversible", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag (0/1) indicating reversibility, used for filtering"}, {"column": "status", "role": "dimension", "confidence": 1.0, "reason": "Categorical workflow state with 3 values (executed, identified, rejected)"}, {"column": "job_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key reference to job (j_ prefix pattern)"}, {"column": "reason_code", "role": "dimension", "confidence": 0.8, "reason": "Categorical code field, currently all null but intended for grouping"}, {"column": "decided_by", "role": "dimension", "confidence": 0.8, "reason": "User/system identifier for decision maker, currently all null"}, {"column": "created_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for temporal filtering and grouping"}, {"column": "permitted_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for temporal filtering and grouping"}, {"column": "settled_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for temporal filtering and grouping"}, {"column": "source", "role": "dimension", "confidence": 0.8, "reason": "Categorical source field, currently all null but intended for grouping"} ] } ```